Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
OIC — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

OIC

Accepted answer
21
Views
6
Comments
edited May 17, 2021 5:53PM in Integration 6 comments

Content

Hello Friends,

If you have zip file ( having 10 csv in it ), I know how to download, unzip,  Use 2 For Each loops ( one for each File and One for each records in file) and then transform / enrich records and stage write and create a ZIP (FBDI transformed zip ) and upload to ERP.

But if I have to deal with Accounts Payable it has Headers and Lines sitting on SFTP. I do not know how to use For Each to transform Headers and Lines. Do I use 2 integrations one dealing with Headers FBDI transformation and another dealing with Lines FBDI transform ?  I have seen some videos but the video depicts the use case where it reads ZIP file ( that was already in FBDI format )  sitting on SFTP and all it uses OIC is to use ERP adapter to upload this zip to ERP. These video does not help my use case.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!