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.