India T Special Bonus:
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 solid 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.
•
Solid 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
📍 Hyderabad