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):