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
edited Mar 18, 2021 7:26PM in Integration 2 comments


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.


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