Oracle Fusion AR Integration with Third Party

PaaS as integration platform – 

Oracle PaaS service is one of the most flexible platform to integrate data / transactions from any third party system to Oracle . We integrated AR invoices from third party system to Oracle using oracle PaaS service for one of our Clients.

Challenges - Here the challenge was that the transactional data was available only in .CSV format and placing the file on the PaaS environment was next to impossible .

Solution - The solution suggested / accepted and implemented was –

Any Invoice file coming from third party will be pushed to Oracle fusion.

Below is the sequence of steps that will be followed for doing the same.

• Third party system will call UCM upload webservice and will place invoice file/s ( csv ) on UCM. Seeded oracle webservice will be called for the same .

  https://xyz.oraclecloud.com/fscmService/ErpIntegrationService?WSDL

• PaaS will call UCM download webservice and download the file on PaaS.

  https://xyz.oraclecloud.com/idcws/GenericSoapPort?WSDL

• DBMS JOB scheduler on PaaS will pick eligible records and insert it into staging table.
• After eligible records are inserted in PaaS staging table, validation program will be called to validate all fields.
• All validated records will be inserted in AR interface .
• The ESS job to import invoices will be called from PaaS to create AR invoices.
• The custom report will be run from PaaS and successful and error out transaction will be updated on PaaS.
• PaaS will call UCM upload webservice and place the Invoice detail output file on UCM.
• Email notification will be sent to respective teams as per the requirement.
  

Boomi as Integration platform – 

Using Boomi as integration platform is one of the most efficient and popular way to integrate data with two different systems. At one of our clients , client wanted to push AR invoices from almost 9 different platforms.

Challenge – All platforms has data present in different format in terms of data fields , file format , frequency of data availability and many others .

Designing the different processes in Boomi to fetch the data from different platforms was possible. However getting that data uniformly in oracle with proper grouping was a challenge.

Solution – Following is the design proposed and implemented -

• Fetch Invoice File from AWS S3 Bucket / using platform APIs and upload data to Staging DB. Staging DB can be any cloud DB.
  
• Using oracle fusion webservice move data from Staging DB to Oracle AR interface.
• Call oracle webservice to submit the ESS job to import AR invoices.
  
• Once invoices are created /processed , staging DB is updated with the invoice number / error status.