Expert Oracle ERP Application Developer

JOB PURPOSE:

The Expert Oracle ERP Application Developer will design, develop, enhance, and support Oracle

E-Business Suite (R12.2.x) applications. The role requires strong technical skills in Oracle ERP,

Oracle APEX, and Oracle OAF, in addition to advanced PL/SQL and integration knowledge. The

developer will collaborate with functional teams, deliver high-quality solutions, and provide

technical leadership within the ERP environment.

Description

1- Application Development & Customization

• Develop and customize Oracle ERP (R12.2.x) components using:
• Oracle APEX (Mandatory)
• Oracle OAF (Mandatory)
• Oracle Forms , Reports (10g/12c) and BI Publisher
• Oracle Workflow Builder
• Create and maintain:
• PL/SQL packages, functions, procedures, and APIs
• Reports, interfaces, conversions, extensions (RICE)
• Custom concurrent programs
• Support development for new modules, system enhancements, and upgrades
  
  

2- Functional & Technical Support

• Provide technical support for key Oracle ERP modules such as:
• Financials: AP, AR, GL, FA
• Supply Chain: PO, INV, OM
• HRMS/Payroll (as applicable)
• Troubleshoot system issues and provide timely resolutions
• Analyze business requirements and design scalable solutions
• Support patching, cloning, and maintenance tasks during R12.2 online patching (adop)
  
  

3- Integration & APIs

• Develop integrations using:
• REST/SOAP web services
• Oracle public APIs & Interface tables
• Develop secure data exchange processes with external systems (APEX/OAF-based solutions included)
  
  

4- Performance & Quality Assurance

• Conduct PL/SQL optimization and tuning
• Perform code reviews and ensure compliance with EBS development standards
• Prepare technical documents: MD050, MD070, TE020, and deployment guides
  
  

5- Collaboration & Leadership

• Work closely with functional consultants and technical teams
• Mentor junior developers and ensure use of best practices
• Participate actively in system design and architecture discussions
  
  

Requirements

• Bachelor's degree in computer science, Information Technology, or related field
  
  

Experience

• 3 to 8 years of hands-on experience in Oracle ERP application development (R12.1/R12.2)
• Strong experience in Oracle E-Business Suite R12.2.x, including online patching
  
  

Mandatory Technical Skills

• Oracle APEX - Advanced development
• Oracle OAF - Customizations & Extensions
• PL/SQL (expert-level)
• Oracle Forms / Reports
• BI Publisher & XML Publisher
• Oracle Workflow
• Unix/Linux shell scripting
• Understanding of EBS architecture, file system, patches, and adop cycles
  
  

Preferred Skills

• Knowledge of:
• Oracle SOA / Integration Cloud (OIC)
• REST/SOAP API integration
• Oracle ADF
• Version control (Git/SVN)
• Experience working in Agile environments
  
  

BEHAVIOURAL COMPETENCIES

• Strong analytical and problem-solving abilities
• Excellent communication and documentation skills
• Ability to work under pressure and meet deadlines
• Leadership and mentoring capabilities
• Strong ownership and commitment to quality