Oracle OAF Technical Consultant / Developer

Location : Oman

Employment Type : Full-Time

Experience : 5 -10 Years

About the Role :

We are looking for an experienced Oracle OAF Technical Consultant / Developer with strong expertise in Oracle E-Business Suite (EBS) R12.2.x and Oracle Application Framework (OAF) development. The ideal candidate will be responsible for designing, developing, customizing, integrating, and supporting Oracle EBS technical components while adhering to Oracle development standards and best practices. The candidate should have hands-on experience in OAF development, Oracle Forms, Oracle Reports, PL/SQL, Oracle Workflow, integrations, and ERP production support.

Key Responsibilities :

Oracle Application Framework (OAF) Development :

- Design, develop, customize, and maintain Oracle OAF pages and extensions.

- Perform OAF personalization and extensions for Oracle EBS standard pages.

- Develop and customize :

1. View Objects (VO)

2. Application Modules (AM)

3. Controllers (CO)

4. Entity Objects (EO)

- Create reusable OAF components.

- Troubleshoot and resolve OAF application issues.

- Implement technical enhancements based on business requirements.

Oracle E-Business Suite Technical Development :

- Develop and maintain Oracle EBS R12.2.x technical components.

- Develop PL/SQL objects, including :

1. Packages

2. Procedures

3. Functions

4. Triggers

- Develop and maintain :

1. Concurrent Programs

2. Oracle APIs

3. Open Interface Tables

4. Custom Workflows

- Perform Oracle EBS customizations and enhancements.

Oracle Reports & BI Publisher :

- Develop and customize Oracle Reports.

- Create BI Publisher and XML Publisher templates.

- Support reporting requirements and enhancements.

Oracle Forms Development :

- Modify and maintain Oracle Forms applications.

- Develop custom Oracle Forms based on business requirements.

- Support legacy Oracle technical components.

Database Development :

- Develop and optimize complex SQL queries and PL/SQL code.

- Perform performance tuning and database optimization.

- Create and maintain database objects such as tables, views, indexes, and sequences.

- Support data migration activities.

Integration Development :

- Develop integrations between Oracle EBS and external systems.

- Support :

1. REST APIs

2. SOAP Web Services

3. Inbound Interfaces

4. Outbound Interfaces

- Monitor and troubleshoot integration issues.

Production Support :

- Provide technical support for Oracle EBS production environments.

- Perform issue analysis, root cause analysis, bug fixing, and performance improvements.

- Support UAT, deployment, and release management activities.

- Prepare and maintain technical documentation.

Mandatory Skills :

- 5 - 10 years of Oracle EBS Technical experience.

- Hands-on experience with Oracle E-Business Suite R12.2.x.

- Strong expertise in Oracle Application Framework (OAF).

- Experience with JDeveloper and Java.

- Strong SQL and PL/SQL programming skills.

- Experience with Oracle Forms and Oracle Reports.

- Experience with BI Publisher and XML Publisher.

- Hands-on experience with Concurrent Programs.

- Knowledge of Oracle Workflow.

- Experience with Oracle APIs and interface development.

- Experience supporting Oracle ERP production environments.

Preferred Skills :

- Oracle APEX.

- REST API development.

- Git.

- FlexDeploy.

- Oracle EBS implementation and support experience.

Education :

- Bachelors degree in Computer Science, Information Technology, Engineering, or equivalent.

- Oracle certifications will be an added advantage.

Benefits :

- Company-sponsored employment visa.

- One-way flight ticket to Oman upon joining.

- Annual leave after completion of one year of service.

- Return flight ticket for the employee, spouse, and one child during annual leave.

- Medical insurance coverage for the employee, spouse, and one child.