Oracle EBS Cloud import data into OS Cloud

Hi,

my two cents here for the Oracle Financials Cloud integration

- you would need to define what data set you need. 

- Assuming you need GL balances, be aware that the REST API for GL balances has limitations (ex: 10000k records). Same applies to many others. You may end up with inconsistent logic to run multiple REST API calls behind the scenes to get a full data set (some kind of pagination)

- If you need journals, everything overcomplicates because, in addition to limitations, you introduce journals details being in 3 tables (3 REST APIs): journal batch, journal header and journal lines.

- The best solution to me, would be to consume a BIP Cloud report via REST API or SOAP. That's the only way you can extract data from relational underlying database for Oracle Financials cloud. You could even do a delta journal extract.

With this approach, data would be in the web service response. There also limitations (i think 25k rows) but pagination would be much easier than the REST API one above. You can find some good references in the internet.

- Another approach that can be used it's to execute a ESS job via REST which generates data in UCM and then download the output file via REST. This is much more flexible but the solution architecture gets more complex. No limitations for rows as ESS job runs as a background process. You need an async process which 1) triggers the ESS job and 2)checks UCM for file being created and 3)download the file when it is created.

All above are options for direct pull from Oracle Financials Cloud. Another option, as mentioned in the other reply, is to have a process exporting data from OFC to data warehouse and then feeding OS from there. You need to have a good synchronization between Refresh and Feed processes to get near-real time data.

HTH