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
How to read data from DBCS & Convert to FBDI Format in 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

How to read data from DBCS & Convert to FBDI Format in OIC

Received Response
23
Views
2
Comments
edited Mar 18, 2021 7:26PM in Integration 2 comments

Content

Hello all,

We have requirement to automate the Requisition FBDI Import into Oracle ERP cloud. Our source system enters the data into DBCS Table. I need inputs on how to read the data from DB table and convert it to FBDI format so that i can import them

1) source application is custom ADF DI Excel enabled Workbook that inserts data into table (DBCS).

2) we can develop pl/sql package to transform the source data as per FBDI format and enter in there Requisition hdr/lines/dist Temp tables.

after this how can we read the data from above DB tables and convert them to FBDI format to automate it from OIC. Any Example/suggestions is highly appreciated.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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