Enterprise Resource Planning Advisor

Enterprise Resource Planning Advisor

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.

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