Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

Execute SQL Query against Cloud ERP/HCM without using DataModel/BI Report

Summary:

Hello,

Usually Oracle Fusion BI Report/Data model was used to create SQL(like "select * from poz_suppliers_int") against Fusion DB ( like ApplicationDB_FSCM,ApplicationDB_HCM,ApplicationDB_CRM) and fetch the expected results in table/PDF/CSV etc.

Similarly , Same SQL query (like "select * from poz_suppliers_int"), we want to pass into Oracle Standard REST/SOAP API(if applicable) as input and that has to

provide the expected results in any format.

Kindly provide the Oracle Fusion REST/SOAP Api's to do that activity.

Content (required):


Version (include the version you are using, if applicable):


Code Snippet (add any code snippets that support your topic, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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