Job Description:

We are looking for a hands-on Oracle EBS R12.2 Techno-Functional Consultant to support Oracle EBS applications, Oracle Integration Cloud (OIC), and Oracle APEX solutions from an offshore delivery model. The consultant will work with the internal IT Applications and Integration teams.

Key Responsibilities :

Oracle EBS R12.2 Support and Enhancements :

- Analyze and resolve Oracle EBS production, interface, and data issues.

- Perform root-cause analysis using Oracle EBS base tables, interface tables, staging tables, logs, and concurrent request outputs.

- Develop and enhance SQL, PL/SQL packages, procedures, triggers, custom programs, and reports.

- Support concurrent programs, workflows, XML Publisher reports, Oracle Forms personalizations, and customizations.

Oracle Integration Cloud Support :

- Review and support existing OIC integrations enabled between Oracle EBS and connected systems.

- Investigate failed integrations by reviewing logs, payloads, fault details, staging records, and error flags.

- Enhance integration error handling, exception capture, fault policies, and recovery logic.

- Perform retry and reprocessing of errored integrations as per IT-approved procedures.

Oracle APEX Dashboard and Monitoring :

- Develop and enhance Oracle APEX applications for integration monitoring and exception tracking.

- Prepare APEX dashboards for IT operations, covering integration health, failed transactions, retry status, pending records, and error aging.

Technical Skills :

- Oracle EBS R12.2: Architecture, data model, APIs, interface tables, concurrent programs, workflows, XML Publisher, Forms personalization/customization.

- Database: Advanced SQL, PL/SQL, performance tuning, data analysis.

- OIC: Integration monitoring, fault handling, REST/SOAP services, file integrations.

- APEX: Dashboard development, reports, charts, exception management.

Functional Knowledge :

- Good understanding of Oracle EBS Finance modules (GL, AP, AR, Cash Management).

- Working knowledge of Procurement, Inventory, Order Management, and Supply Chain transaction flows.