Oracle ERP 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.

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

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