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

image

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.

clip_image003 Blog clip_image005 Twitter clip_image004 LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

Technorati Tags: SOA Community,Oracle SOA,Oracle BPM,OPN,Jürgen Kress,

Top tweets PaaS Partner Community June 2020

imageJune top tweets by PaaSCommunity

Send your tweets @soacommunity #PaaSCommunity and follow us at http://twitter.com/soacommunity. Make sure you share your content with the community!

PaaS Partner Community

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

clip_image003 Blog clip_image005 Twitter clip_image004 LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

Technorati Tags: SOA Community,Oracle SOA,Oracle BPM,OPN,Jürgen Kress, Twitter

Top tweets PaaS Partner Community May 2020

imageMay top tweets by PaaSCommunity

Send your tweets @soacommunity #PaaSCommunity and follow us at http://twitter.com/soacommunity. Make sure you share your content with the community!

PaaS Partner Community

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

clip_image003 Blog clip_image005 Twitter clip_image004 LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

Technorati Tags: SOA Community,Oracle SOA,Oracle BPM,OPN,Jürgen Kress, Twitter

Top tweets PaaS Partner Community April 2020

imageApril top tweets by PaaSCommunity

Send your tweets @soacommunity #PaaSCommunity and follow us at http://twitter.com/soacommunity. Make sure you share your content with the community!

PaaS Partner Community

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

clip_image003 Blog clip_image005 Twitter clip_image004 LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

Technorati Tags: SOA Community,Oracle SOA,Oracle BPM,OPN,Jürgen Kress, Twitter

Top tweets PaaS Partner Community March 2020

imageMarch top tweets by PaaSCommunity

Send your tweets @soacommunity #PaaSCommunity and follow us at http://twitter.com/soacommunity. Make sure you share your content with the community!

PaaS Partner Community

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

clip_image003 Blog clip_image005 Twitter clip_image004 LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

Technorati Tags: SOA Community,Oracle SOA,Oracle BPM,OPN,Jürgen Kress, Twitter

Top tweets PaaS Partner Community February 2020

imageFebruary top tweets by PaaSCommunity

Send your tweets @soacommunity #PaaSCommunity and follow us at http://twitter.com/soacommunity. Make sure you share your content with the community!

PaaS Partner Community

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

clip_image003 Blog clip_image005 Twitter clip_image004 LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

Technorati Tags: SOA Community,Oracle SOA,Oracle BPM,OPN,Jürgen Kress, Twitter

Top tweets PaaS Partner Community January 2020

imageJanuary top tweets by PaaSCommunity

Send your tweets @soacommunity #PaaSCommunity and follow us at http://twitter.com/soacommunity. Make sure you share your content with the community!

PaaS Partner Community

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

clip_image003 Blog clip_image005 Twitter clip_image004 LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

Technorati Tags: SOA Community,Oracle SOA,Oracle BPM,OPN,Jürgen Kress, Twitter

Top tweets PaaS Partner Community December 2019

imageDecember 2019 top tweets by PaaSCommunity

Send your tweets @soacommunity #PaaSCommunity and follow us at http://twitter.com/soacommunity. Make sure you share your content with the community!

PaaS Partner Community

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

clip_image003 Blog clip_image005 Twitter clip_image004 LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

Technorati Tags: SOA Community,Oracle SOA,Oracle BPM,OPN,Jürgen Kress, Twitter

Top tweets PaaS Partner Community November 2019

imageNovember 2019 top tweets by PaaSCommunity

Send your tweets @soacommunity #PaaSCommunity and follow us at http://twitter.com/soacommunity. Make sure you share your content with the community!

PaaS Partner Community

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

clip_image003 Blog clip_image005 Twitter clip_image004 LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

Technorati Tags: SOA Community,Oracle SOA,Oracle BPM,OPN,Jürgen Kress, Twitter

Top tweets PaaS Partner Community October 2019

imageOctober 2019 top tweets by PaaSCommunity

Send your tweets @soacommunity #PaaSCommunity and follow us at http://twitter.com/soacommunity. Make sure you share your content with the community!

PaaS Partner Community

For regular information on Oracle PaaS become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center.

clip_image003 Blog clip_image005 Twitter clip_image004 LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

Technorati Tags: SOA Community,Oracle SOA,Oracle BPM,OPN,Jürgen Kress, Twitter