Discussion on "Interfacing Data from APEX to Oracle Fusion Cloud ERP over REST"

Jon Dixon · 2024-08-29T16:14:06.740Z

Introduction Oracle APEX and Visual Builder are the go-to development platforms for extending and integrating with Oracle Fusion Cloud ERP. 😉 Obviously, I believe APEX is the best tool for the job. This post will show you how to integrate data fr...

Hi Jon, Thanks for the useful example. One question if I may. How do you handle authentication in ORDS REST callback? Do you have to leave the endpoint open for Fusion to be able to invoke it or are you able to set the auth parameters somewhere in Fusion? Thanks in advance!

Hi, The web service is open, but I use custom authentication to verify that the ESS Job ID in the response matches the one that I received in the initial request. Once I receive a response, I mark a record in a table to say that the ESS Job ID has been consumed. This ensures the Job ID can only be used once.

Hi, A very nice approach to use Apex/PLSQL for fusion integrations without OIC. A question I have - how did you get the columns and the sequence to construct the csv row in the cursor. Is it based on the loader ctl file of the FBDI. Also, Oracle may update FBDI to add more columns how does the Apex PLSQL code tackle such issues?

Hi Arun, The code in the cursor cr_fbdi_line is generating the CSV to match the format of the FBDI file (for journals in this case). If Oracle were to change the FBDI format, I would hope they would only add columns to the end of the CSV, which should not impact existing code. An FBDI file format is effectively a public API If Oracle makes breaking changes to the FBDI file, they are breaking a sacred contract that is implicit in all public APIs.

Search Hashnode

Interfacing Data from APEX to Oracle Fusion Cloud ERP over REST

Responses2