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:

o Oracle APEX (Mandatory)

o Oracle OAF (Mandatory)

o Oracle Forms , Reports (10g/12c) and BI Publisher

o Oracle Workflow Builder

• Create and maintain:

o PL/SQL packages, functions, procedures, and APIs

o Reports, interfaces, conversions, extensions (RICE)

o 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:

o Financials: AP, AR, GL, FA

o Supply Chain: PO, INV, OM

o 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:

o REST/SOAP web services

o 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:

o Oracle SOA / Integration Cloud (OIC)

o REST/SOAP API integration

o Oracle ADF

o 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.