POSITION SUMMARY STATEMENT:

Seeking an experienced Plan to Manufacture (PTM) – Developer with robust expertise as an Oracle E‑Business Suite (EBS) SCM PL/SQL Developer, specializing in data conversion and migration from EBS to Oracle Fusion SCM.
The ideal candidate will have deep hands‑on experience in PL/SQL development, legacy data conversions, and Oracle EBS SCM data models, combined with a solid functional understanding of Plan to Manufacture (PTM) processes. This role is critical to ensuring accurate, performant, and validated data migration as part of Oracle Fusion transformation programs.
The role works closely with SCM functional consultants, Fusion functional teams, data migration leads, and business stakeholders to deliver high‑quality conversion outcomes.

DETAILED RESPONSIBILITIES / DUTIES:
Design, develop, and execute PL/SQL‑based data conversion programs to support EBS to Oracle Fusion SCM migration, including:
Data extraction from Oracle E‑Business Suite
Data transformation and cleansing
Loading data into Fusion staging or interface layers




Support Plan to Manufacture (PTM)–related SCM modules, including:
Inventory
Bills of Material (BOM)
Routings
Work in Process (WIP)
Manufacturing and Supply Chain Planning
Analyze and interpret Oracle EBS SCM data models, setups, and dependencies to ensure accurate data mapping to Fusion
Work closely with SCM functional teams to:
Understand business rules, setup dependencies, and master/transactional data
Translate functional conversion requirements into technical specifications
Validate migrated data through reconciliation and business sign‑off
Develop and maintain:
PL/SQL packages, procedures, functions, and validation scripts
Conversion and reconciliation reports
Error handling and restart mechanisms for conversion cycles
Support mock conversions, SIT, UAT, dress rehearsals, and production cutover activities
Troubleshoot and resolve data migration issues, performance bott

📌 Oracle Ebs Fusion Bengaluru
🏢 HCL INDIA
📍 Bengaluru