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