Blog Posts Process Management Service Oriented Architecture (SOA)

ERP Integration using File Based Data Import: Oracle Integration by Ankur Jain

Blog: PaaS Community

The Oracle ERP integration is one of the most common integration requirement in today’s world as most of the big organization is having Enterprise Resource Planning(ERP) to manage enterprise functions including accounting, financial management, project management, and procurement etc. The article is focused on the aspects which is required in order to connect Oracle ERP system with Oracle Integration Cloud (OIC) using File Based Data Import (FBDI).

For this article, we’ll consider the import of Account Receivables (AR) invoices as an example.

Some important link which might help you to extend your knowledge

Web Application in Oracle Visual Builder

Parent Child relationship in Oracle Visual Builder

Dependent/Cascading List Of Values (LOV) in VBCS

Here is the use case which we are trying to sort out here:

The third party application generates CSV file and keeps the data at SFTP location. The file may be large than 10 MB
Convert the source file into the pre-defined FBDI format and upload into the ERP
Once ERP completes the import job, it will send a callback to OIC to notify the status of import job. Read the complete article here.

PaaS Partner Community

For regular information on Oracle PaaS become a member in the PaaS (Integration & Process) Partner Community please register here.

Blog Twitter LinkedIn Facebook Wiki