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.

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.

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:

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