Oracle EBS R12.2 Techno-Functional Consultant

Oracle EBS R12.2 Techno-Functional Consultant

Pan India

Role Mix 60% Technical / 40% Functional

Experience 8 to 10 years

Role Overview

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. The role focuses on issue analysis, integration monitoring,

error handling improvements, retry and reprocessing of failed integrations, and creation of APEX dashboards for IT

operational visibility.

Key Responsibilities

Oracle EBS R12.2 Support and Enhancements

- Analyze and resolve Oracle EBS production, interface, and data issues assigned by the IT team.

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

- Review interface designs and recommend technical improvements for stability and performance.

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.

- Identify recurring integration failure patterns and propose permanent fixes.

- Support REST, SOAP, scheduled, and file-based integrations.

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.

- Create dashboard filters, drill-down reports, and summary views for faster investigation by IT support teams.

- Implement role-based views and maintain technical documentation for dashboard components.

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, reconciliation queries, package/procedure development

OIC - Integration monitoring, fault handling, retry/recovery, REST/SOAP services, file integrations, payload analysis

APEX - Dashboard development, reports, charts, exception management screens, operational monitoring applications

Documentation Technical design notes, support runbooks, issue analysis

notes, knowledge transfer documents

Functional Knowledge Required

- Good understanding of Oracle EBS Finance modules such as General Ledger, Accounts Payable, Accounts

Receivable, and Cash Management.

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

- Ability to understand business transaction lifecycle from a system and data perspective.

- Ability to support reconciliation, interface validation, and exception resolution through IT team inputs.