Senior Oracle EBS R12 & OIC Technical Consultant – SCM Integration
Posted Updated
Description
Key Responsibilities
- Design, develop, and maintain Oracle EBS R12 technical components using SQL, PL/SQL packages, procedures, functions, views, triggers, and staging tables.
- Develop Oracle EBS public APIs, open interfaces, custom concurrent programs, and request sets.
- Implement FND_REQUEST processing and interface error-handling mechanisms.
- Design, develop, and support OIC integrations using REST, SOAP, JSON, XML, SFTP, database, and file-based integration methods.
- Develop bidirectional integrations between Oracle EBS R12 and Oracle Fusion Cloud.
- Build data extracts and interfaces for Inventory, BOM, WIP, Purchasing, Order Management, MRP/ASCP, and SCM Planning.
- Support integration of items, suppliers, inventory balances, forecasts, demand, supply, purchase orders, work orders, and planning recommendations.
- Implement integration controls, including logging, reconciliation, retry mechanisms, duplicate prevention, and monitoring.
- Troubleshoot SQL performance, concurrent program failures, API errors, OIC mappings, and data-quality issues.
- Support technical design documentation, unit testing, CRP, SIT, UAT, cutover, go-live, and hypercare.
- Develop or support custom Oracle Forms when required.
Required Skills
- 8–10+ years of Oracle technical development experience.
- Strong hands-on Oracle EBS R12 development.
- Advanced SQL/PLSQL programming, debugging, and performance tuning.
- Oracle EBS public APIs, open interfaces, concurrent programs, and staging tables.
- Hands-on Oracle Integration Cloud (OIC) development.
- REST/SOAP web services, JSON, XML, and SFTP integration experience.
- Knowledge of Oracle EBS manufacturing and SCM modules.
- Experience with Inventory, BOM, WIP, Purchasing, Order Management, and MRP/ASCP.
- Unix/Linux and shell scripting.
- Experience supporting integration testing, troubleshooting, and production deployments.
Preferred Skills
- Oracle Fusion SCM Planning Cloud.
- Oracle Demand Management.
- Oracle Supply Planning.
- Oracle Application Framework (OAF).
- Oracle Forms development.
- Oracle EBS Integrated SOA Gateway.
- Manufacturing or global supply chain implementation experience.
Skills
Sign in to read and join the discussion.