Senior Oracle EBS R12 Forms & Manufacturing Developer

Senior Oracle EBS R12 Forms & Manufacturing Developer

Engagement Length: 1–2 years

Environment:
On-Prem Oracle EBS R12.0.6 (mandatory)

Location:

Onsite Austin, Texas for the first couple of months and then hybrid thereafter.

We are seeking a senior, hands‑on Oracle E-Business Suite R12 Technical Developer with strong working experience in SQL, PL/SQL, Oracle Forms and Oracle Reports within SCM and Manufacturing modules
.

This position will support and enhance a highly customized, on‑premises Oracle EBS environment that relies extensively on Oracle Forms and legacy custom development. The successful candidate must be comfortable analyzing existing code, tracing complex business logic and learning custom functionality developed over many years.

The primary objective is to improve operator efficiency by automating processes that currently require significant manual interaction with Oracle Forms. This includes moving transactions and system‑generated information across Manufacturing, Inventory, Order Management and Shipping processes with minimal user intervention.

• Analyze, troubleshoot, modify and enhance customized Oracle Forms.
• Develop and maintain Oracle Reports supporting SCM and Manufacturing operations.
• Design and develop automation solutions using SQL, PL/SQL, Oracle Forms, Reports, workflows, APIs and interfaces.
• Review existing Forms, PL/SQL packages, workflows, database objects and interfaces to understand established business logic.
• Automate manual processes involving manufacturing work centers, WIP, BOM, Inventory, Order Management and Shipping.
• Develop and maintain PL/SQL packages, procedures, functions, triggers and concurrent programs.
• Customize and troubleshoot Oracle Workflows supporting manufacturing and operational processes.
• Build and support integrations using Oracle standard APIs, open interfaces and custom interfaces.
• Develop enhancements that move transactions and information between EBS modules with minimal manual intervention.
• Integrate external, system‑generated or machine‑generated data into Oracle EBS processes where applicable.
• Diagnose production issues involving Oracle Forms, Reports, workflows, interfaces, concurrent programs and backend database logic.
• Perform root‑cause analysis and implement sustainable technical fixes.
• Support existing custom applications, web modules, OAF components and operational interfaces.
• Document custom Forms, Reports, workflows, interfaces, automation processes and technical dependencies.
• Work closely with the existing Oracle development team to learn the current architecture and custom business processes.
• Provide knowledge transfer and technical support across development, testing, UAT and production environments.

• Strong hands‑on working experience with SQL, PL/SQL, Oracle Forms and Oracle Reports within Oracle EBS SCM and Manufacturing modules
  .
• Strong experience developing, modifying, compiling and deploying Oracle Forms.
• Experience developing and maintaining custom and standard Oracle Reports.
• Strong Oracle SQL and PL/SQL development experience.
• Experience with Oracle Workflow Builder, including workflow development, customization and troubleshooting.

• Technical experience supporting Oracle Manufacturing and SCM processes, including:

  • Work in Process
  • Bills of Material
  • Inventory
  • Work centers and shop‑floor transactions
  • Material movements and manufacturing business flows
  • Order Management
  • Shipping Execution
• Experience working in a highly customized, on‑premises Oracle EBS R12 environment.
• Ability to trace business logic across Forms, Reports, PL/SQL, workflows, APIs, interface tables and concurrent programs.
• Experience developing and supporting RICEW components, including reports, interfaces,…