Oracle Fusion - E-Invoice Integration Using OIC

Customer Based out of India belongs to Engineering Vertical and they use Oracle EBS R12.2.12 – SCM, Order Management, Financials & CRM Modules.
Successfully integrated using PL/SQL Concurrent Programs
Challenges

Customer has complex scenarios involving AR and specific tax rates.

Multiple Business Entities/Groups across India

Multiple reports exist for each entity.

They require report outputs to be placed in SharePoint.

The customer does not have a middleware license but has requested a dashboard.

Handling 3000+ invoice documents across multiple entities/groups

 

Solution Delivered

Handled using PL/SQL Concurrent Programs and scheduled it on a regular Basis

Multiple conditions were created in the report to meet the requirements.

Custom logic was implemented in the Concurrent Programs to call the PDF.

Custom logic was developed in the Concurrent Program to place the files in SharePoint.

A dashboard has developed in Oracle Apex for monitoring.

Key Highlights

PL/SQL & Concurrent Program Integration

Real Time Data Transmission AR Integration

100% Error Reduction & Multiple Integration Modes