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.

Position Overview

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.

Key Responsibilities

• 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.

Required Qualifications

• 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, conversions, extensions and workflows.
• Experience automating business processes that previously required manual Oracle Forms interaction.
• Strong troubleshooting and root‑cause analysis skills.
• Ability to understand legacy code and work effectively when technical documentation is limited.
• Strong communication and collaboration skills.
• Willingness to learn existing customizations and business processes from incumbent developers.

Preferred Qualifications

• Experience automating end‑to‑end processes across Manufacturing, Inventory, Order Management and Shipping.
• Experience with OAF, BI Publisher and XML Publisher.
• Experience using Oracle standard and custom APIs.
• REST service or Oracle Integrated SOA Gateway experience.
• Experience integrating Oracle EBS with WMS, MES, TMS, 3PL, carrier or shop‑floor systems.
• EDI or Oracle eCommerce Gateway experience.
• Oracle‑to‑SAP or SAP‑to‑Oracle integration experience.
• Unix shell scripting experience.
• SQL and PL/SQL performance tuning experience using EXPLAIN PLAN, SQL Trace or TKPROF.
• Experience supporting older Oracle EBS releases and legacy development tools.

Ideal Candidate

The ideal candidate is a senior Oracle EBS technical developer who has remained actively involved in Oracle Forms, Oracle Reports, SQL, PL/SQL and Workflow development within SCM and Manufacturing environments .

This person does not need immediate knowledge of every existing customization. However, they must possess the technical depth to examine legacy Forms, Reports and database code; understand manufacturing business processes; learn the current architecture; and gradually assume ownership of complex customized functionality.

Candidates whose recent experience is primarily focused on Oracle Fusion Cloud, solution architecture or team management without current hands‑on Forms and Reports development are unlikely to be successful in this position.

#TECHIND