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 .