Oracle OIC / ATP Technical Consultant – Financial Integrations

Experience: 5+ Years
Primary Skills: Oracle Integration Cloud (OIC), Oracle ATP, REST APIs, Oracle Fusion Financials Integration
Project: Oracle Cloud Prepaid & Ad Hoc Amortization Solution

Role Overview

We are seeking a strong Oracle OIC / ATP Technical Consultant to design and develop the integration and database components of a custom Oracle Cloud Prepaid and Ad Hoc Amortization solution.

The consultant will be responsible for integrations between Oracle Fusion Financials, VBCS and ATP , amortization schedule processing, approval/status persistence, scheduled GL journal creation, posting-status tracking, exception handling, and notification/report generation.

Key Responsibilities

OIC Integration

- Design and develop OIC integrations between:

- Oracle Fusion Payables

- VBCS

- ATP

- Oracle Fusion General Ledger

- Develop integrations to retrieve eligible AP invoice and distribution details from Oracle Fusion.

- Retrieve required master/reference information such as Business Units, Suppliers, Ledgers and account combinations.

- Develop scheduled integrations for monthly amortization journal processing.

- Configure OIC scheduling to identify approved and unposted amortization transactions eligible for processing.

- Validate Oracle GL accounting period status before journal creation.

- Ensure journals are not created for Closed/Future Enterable periods based on agreed business rules.

- Create Oracle Fusion GL journal batches/journals through supported Oracle integration mechanisms/APIs.

- Group journals appropriately by:

- Amortization Type

- Ledger

- Accounting Period





- Create detailed journal lines with appropriate debit/credit accounting and transaction-level descriptions.

- Capture Oracle journal batch/reference information and update ATP following successful journal creation.

- Implement comprehensive exception handling, error logging and reprocessing mechanisms.

- Develop email notifications containing transaction/posting details and supporting Excel/PDF output as required.

ATP Development

- Design the ATP database model for the amortization solution.

- Design tables to maintain:

- Invoice/ad hoc transaction details

- Amortization parameters

- Amortization schedules

- Periodic amortization amounts

- Cumulative amortized amounts

- Approval status

- Approval/rejection audit history

- GL posting status

- Journal batch/reference details

- Integration error/reprocessing information

- Develop PL/SQL procedures/packages required for amortization calculations and transaction processing.

- Implement straight-line amortization schedule generation based on start/end dates.

- Handle partial periods according to the defined business rule.

- Ensure rounding differences are appropriately handled so that the total schedule equals the amount to be amortized.

- Implement controls to prevent duplicate invoice-line selection and duplicate journal creation.

- Maintain line-level traceability between AP Invoice → ATP Amortization Schedule → GL Journal .





- Design the solution to support opening amortization balances if approved as part of the final scope.

- Support integration/reporting requirements for the Prepaid Roll Forward Report where technically feasible.

Mandatory Skills

- 5+ years of Oracle technical/integration experience.

- Strong hands-on expertise in Oracle Integration Cloud (OIC) .

- Strong experience with Oracle Autonomous Transaction Processing (ATP) .

- Strong SQL and PL/SQL development skills.

- Experience integrating with Oracle Fusion Financials , particularly:

- Payables

- General Ledger

- Strong experience with Oracle Fusion REST/SOAP APIs and/or FBDI-based integration patterns.

- Experience creating GL journals through integrations.

- Solid understanding of scheduled integrations and orchestration.

- Experience with:

- Error handling

- Fault management

- Retry/reprocessing mechanisms

- Integration logging

- Audit controls

- Experience designing ATP custom tables and transaction/audit data models.

- Strong understanding of integration security, authentication and connectivity.

- Ability to troubleshoot end-to-end integrations across Fusion Cloud, OIC, ATP and VBCS.

Preferred Skills

- Experience implementing financial amortization, accrual or journal automation solutions.

- Experience with BI Publisher/report integration.

- Experience generating Excel/PDF outputs through Oracle integration solutions.

- Understanding of Oracle Fusion accounting periods, journals and subledger accounting.

- Experience implementing financial integrations requiring strong auditability, reconciliation and duplicate-prevention controls .

📌 Enterprise Resource Planning Advisor (Hyderabad)
🏢 NTT DATA Services
📍 Hyderabad