Seeking a skilled Oracle OIC / ATP Technical Consultant to architect and build the integration and database facets of a bespoke Oracle Cloud Prepaid and Ad Hoc Amortization solution.

This role involves managing integrations between Oracle Fusion Financials, VBCS, and ATP. Key duties include processing amortization schedules, handling approvals and status updates, creating scheduled GL journals, tracking posting statuses, managing exceptions, and generating notifications and reports.

Design and implement OIC integrations connecting Oracle Fusion Payables, VBCS, ATP, and Oracle Fusion General Ledger.

Develop integrations to extract essential AP invoice and distribution details from Oracle Fusion, along with master data like Business Units, Suppliers, and Ledgers.

Configure scheduled integrations for monthly amortization journal processing, ensuring timely execution based on approved transactions.

Create Oracle Fusion GL journal batches via supported APIs, grouping journals by Amortization Type, Ledger, and Accounting Period.

Implement robust error handling, logging, and reprocessing capabilities to ensure data integrity.

Design the ATP database model to meticulously track invoice details, amortization parameters, schedules, periodic amounts, approval statuses, GL posting information, and error logs.

Develop PL/SQL procedures for amortization calculations and transaction processing, including straight-line amortization and partial period handling.

Establish clear line-level traceability from AP Invoice to ATP Amortization Schedule to GL Journal, incorporating controls against duplicates and ensuring accurate rounding.

A minimum of 5 years of comprehensive Oracle technical and integration experience is essential.

Demonstrated expertise in Oracle Integration Cloud (OIC) and Oracle Autonomous Transaction Processing (ATP) is required.

Proficiency in SQL and PL/SQL development, coupled with strong experience integrating with Oracle Fusion Financials (Payables and General Ledger) is crucial.

Solid experience with Oracle Fusion REST/SOAP APIs and/or FBDI integration patterns, including GL journal creation through integrations, is a must.

Advanced understanding of scheduled integrations, orchestration, error handling, fault management, and retry mechanisms is expected.

Experience designing ATP custom tables and transaction/audit data models, along with a strong grasp of integration security, authentication, and connectivity, are vital for success.

Ability to troubleshoot complex, end-to-end integrations across Oracle Fusion Cloud, OIC, ATP, and VBCS is a key requirement.