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