How to Run SQL on Oracle Fusion (HCM/ERP/SCM) Database? 

Share it
How to Run SQL on Oracle Fusion (HCM/ERP/SCM) Database? 

If you’re working with Oracle Fusion Cloud and want to run SQL queries directly on the database, you might find it a bit tricky at first. Oracle doesn’t provide direct database access like traditional systems. Instead, it allows you to run SQL through the Business Intelligence (BI) layer, which can be a bit complex and limited. 

In this guide, we’ll show you: 

  1. How to run SQL using Oracle’s built-in BI tools 
  2. An easier alternative using a third-party SQL editor like CloudSQL Desktop

Method 1: Using Oracle’s Built-in BI Layer 

Oracle Fusion Cloud allows SQL access through BI Publisher. 

Note: Oracle Fusion Cloud only supports read-only access to the database. 
You can only run SELECT statements—INSERT, UPDATE, DELETE, CREATE, ALTER, or any other DDL/DML operations are not allowed. 

In simple terms, treat the Oracle Fusion database as read-only, meant strictly for querying data, not modifying it. 

Step-by-Step Instructions: 

Prerequisite: You must have one of the following roles to access and run SQL: 

  • BI Administrator 
  • BI Author 
  • BI Consumer (with extra privileges) 

Step1: – Log in to your Oracle Fusion Cloud account. 

Step2:- Navigate to Tools > Reports and Analytics.

Log in to your Oracle Fusion Cloud account. Navigate to Tools > Reports and Analytics.

Step3:- Click Browse Catalog to open the BI Publisher screen. 

Click Browse Catalog to open the BI Publisher screen. 

Step4:- Create a new Data Model. 

Create a new Data Model. 

Step5:- Click on the ‘+’ icon and select SQL Query A screen pops up. 

Click on the ‘+’ icon and select SQL Query A screen pops up. 

Step6:- In the popup screen, Give a name, choose the Datasource and enter your SQL query (SELECT only) and click on ok. 

In the popup screen, Give a name, choose the Datasource and enter your SQL query (SELECT only) and click on ok. 

Step7:- Once sql is ready, go to Data tab(1) and click on View(2)

Step 8:- Save(3) and test the Data Model. 

Once sql is ready, go to Data tab(1) and click on View(2). Save(3) and test the Data Model. 

Step9: Once Data set is tested and saved, click on Save as Sample Data(4). This is needed to create report. 

Step10: Now Click on Create report(5). A new screen pops up. 

Step11: In the popup wizard,  select the datamodel and click on next 

Once Data set is tested and saved, click on Save as Sample Data(4). This is needed to create report.  Now Click on Create report(5). A new screen pops up.  In the popup wizard,  select the datamodel and click on next 

Step12: Click Next button after selecting the layout

Click Next button after selecting the layout

Step13:- In the Create Table screen, drag and drop the columns needed for the report and click on Next 

In the Create Table screen, drag and drop the columns needed for the report and click on Next 

Step14:- Click on Finish to save the report and save it. 

Step15:- Run the Report to see the results. 

This process works, but as you can see, it takes several steps just to run a basic query. 

Method 2: A Simpler Way Using CloudSQL

If you’re looking for a faster, developer-friendly way to run SQL on your Oracle Fusion data, tools like CloudSQL Desktop make it much easier. 

CloudSQL Desktop provides a clean, SQL Developer-style interface where you can just paste your SQL and click Run—no need to create reports or data models. 

Step-by-Step Instructions: 

✅ Prerequisite: You must have one of the following roles to access and run SQL: 

  • BI Administrator 
  • BI Author 
  • BI Consumer (with extra privileges) 

You should download CloudSQL from here , unzip it on your local Windows machine and activate the trial licence. 

  1. Open DataFusing CloudSQL 
  1. Create a connection using your Fusion application credentials (you should have one of the roles mentioned above) 
Open DataFusing CloudSQL  Create a connection using your Fusion application credentials (you should have one of the roles mentioned above) 
Create a connection using your Fusion application credentials (you should have one of the roles mentioned above) 

3. Run your first SQL and view the results

Run your first SQL and view the results

Summary 

Running SQL on Oracle Fusion Cloud using Oracle’s own tools is possible but time-consuming. For a simpler and faster experience, CloudSQL Desktop can save you time and streamline your workflow. 

Picture of Binuraj Somanathan Nair

Binuraj Somanathan Nair

Since 2006, Binuraj Nair has been driving successful Oracle ERP projects worldwide, progressing from software developer to project leader on complex, high-value implementations. Drawing on this deep end-to-end experience, he co-founded DataFusing to create powerful tools that streamline Oracle ERP deployments and deliver measurable value to both implementation partners and Oracle’s clients.

Related Posts

Oracle Fusion Reporting

What Is the ROI of CloudSQL Desktop for Oracle…

AP_INVOICES_ALL Table: Complete Guide for Fusion Finance SQL
Oracle Fusion Reporting

AP_INVOICES_ALL Table: Complete Guide for Fusion Finance SQL

HZ_CUST_ACCOUNTS Explained: Customer Accounts in Oracle Fusion
Oracle Fusion Reporting

HZ_CUST_ACCOUNTS Explained: Customer Accounts in Oracle Fusion

Image showing all the new features in CloudSQL Desktop

Join CloudSQL Community

Linkedin Youtube X-twitter Facebook

Stay Updated!

Manage Consent

To provide the best experiences, we use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us to process data such as browsing behaviour or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions.

Accept
Privacy Policy

DataFusing CloudSQL License Agreement

IMPORTANT: PLEASE READ THIS LICENSE AGREEMENT CAREFULLY BEFORE DOWNLOADING OR USING THE SOFTWARE. BY DOWNLOADING OR USING THE SOFTWARE, YOU AGREE TO BE BOUND BY THE TERMS OF THIS AGREEMENT.

1. Introduction
This License Agreement (“Agreement”) is made and entered into by and between JXB Software Limited, trading as DataFusing (“JXB”), and you, the end user (“You” or “User”). This Agreement governs your use of the DataFusing CloudSQL software (“Software”).

2. License Grant
Subject to the terms and conditions of this Agreement, JXB grants You a non-exclusive, non-transferable license to download and install the Software on a single personal computer for your own use. The license is per user per computer.

3. Trial Period
The Software is offered for a fixed trial period as specified on the DataFusing website. At the end of the trial period, you must either purchase a license or stop using the Software. You agree not to use any workaround, time manipulation, or software modification to extend the trial beyond its designated duration.

4. User Responsibilities
• You are responsible for backing up any data stored within the Software, including SQL history and connection details.
• You are solely responsible for ensuring your access to Oracle Fusion Cloud is authorized and compliant with Oracle’s terms of service. JXB will not be held responsible for any illegal access attempts using CloudSQL.
• You are liable for any damages caused by your misuse of the Software. JXB shall not be liable for damages resulting from misuse, including unauthorized access or data loss.

5. Third-Party Dependencies
CloudSQL relies on Oracle Fusion Cloud APIs. Changes to these APIs may disrupt Software functionality. While JXB will attempt to provide timely updates or alternatives, no refunds will be issued for such disruptions.

6. License Transfer
The license is not transferable to another user. Any attempt to sublicense, assign, or transfer the license shall be void.

7. Subscription and Payment
• The Software requires a monthly subscription fee.
• You are responsible for timely payment of the subscription fee.
• The subscription will automatically renew at the end of the term unless cancelled before the renewal date.Failure to receive payment on or before the subscription end date shall result in the automatic cancellation of the licence without the requirement of further notice to either party.
• All fees are non-refundable once paid, unless required by applicable law.

8. Software Updates
You agree to upgrade the Software as and when notified by JXB through emails or notifications within the software. JXB is not obligated to support older versions. Failure to install updates may limit functionality or cause the Software to stop working. JXB is not responsible for issues arising from outdated versions.

9. Data Collection and Use
JXB may connect to Datafusing.com to validate your license, collect anonymized error event data for software improvement, and collect anonymized usage data to understand user patterns and enhance the user experience. No personal data will be collected or shared with third parties. Both error and usage data will be stored for a maximum of 24 months before deletion.

10. Confidentiality.

10.1. Definition. As used herein, “Confidential Information” means all confidential information disclosed by a party (“Disclosing Party”) to the other party (“Receiving Party”), or otherwise accessed by the Receiving Party, whether orally or written, that is designated as confidential or that reasonably should be understood to be confidential given the nature of the information and the circumstances of disclosure. User Confidential Information shall include the User Data; JXB’s Confidential Information shall include the Service and JXB proprietary technology and software; and Confidential Information of each party shall include the terms and conditions of this Agreement and all Orders, as well as business and marketing plans, technology and technical information, product plans and designs, and business processes disclosed by such party.

10.2. Exclusions. Confidential Information shall not include any information that (i) is or becomes generally known to the public without breach of any obligation owed to the Disclosing Party, (ii) was known to the Receiving Party prior to its disclosure by the Disclosing Party without breach of any obligation owed to the Disclosing Party, (iii) is received from a third party without breach of any obligation owed to the Disclosing Party, or (iv) was independently developed by the Receiving Party.

10.3. Protection of Confidential Information. Except as otherwise permitted in writing by the Disclosing Party, (i) the Receiving Party shall protect the Disclosing Party’s Confidential Information by using the same degree of care that it uses to protect the confidentiality of its own confidential information of like kind (but in no event less than reasonable care), and shall not disclose or use any Confidential Information of the Disclosing Party for any purpose outside the scope of this agreement, and (ii) the Receiving Party shall limit access to Confidential Information of the Disclosing Party to those of its employees, contractors and agents who need such access for purposes consistent with this agreement and who are bound by confidentiality agreements with the Receiving Party containing protections no less stringent than those herein.

10.4. Permitted Disclosure. The Receiving Party may disclose Confidential Information of the Disclosing Party if it is required to do so in connection with any judicial, governmental or administrative proceedings (by oral questions, interrogatories, requests for information or documents, subpoena, civil investigation, demand or similar process) or pursuant to any applicable law (including, without limitation, any securities laws or stock exchange regulations), provided that, to the extent permitted under applicable law, the Receiving Party shall provide prompt notice of such court order or requirement to the Disclosing Party to enable the Disclosing Party to seek a protective order or otherwise prevent or restrict such disclosure. The Receiving Party shall limit such disclosure to the minimum disclosure as required and shall take appropriate measures to avoid or minimize the release of such information in connection with the proceedings for which the Confidential Information is sought.

11. AI-Powered SQL Assistance (Deepseek)
As part of an optional feature, the Software may offer AI-based assistance for SQL analysis using third-party large language models (LLMs), such as Deepseek. This feature may send SQL queries, including instructions and code snippets, to the Deepseek API for analysis or suggestions. No personal data or stored user data will be transmitted.

This AI feature is provided as a complementary and optional service. If you do not wish to share your SQL queries or instructions with Deepseek, you may disable or choose not to use this feature.

You acknowledge and agree that:

• It is your sole responsibility to understand and review the data handling, privacy practices, and terms of service of Deepseek and any associated third-party AI providers.

• JXB does not control how Deepseek processes the information sent to it and disclaims any liability arising from the use or misuse of data by such third-party services.

• By using this feature, you accept any risks associated with sharing your code snippets with third-party AI systems.

12. Reverse Engineering
You are prohibited from attempting to reverse engineer, decompile, or disassemble the Software.

13. Termination
JXB may terminate this Agreement and your access to the Software at any time for any reason, with or without notice. The service will be terminated without notice upon license expiry unless renewed. Upon termination, you must immediately cease all use of the Software and delete all copies in your possession.

14. Governing Law
This Agreement shall be governed by and construed in accordance with the laws of England and Wales, United Kingdom. Any disputes shall be subject to the exclusive jurisdiction of the courts in England and Wales.

15. Entire Agreement
This Agreement constitutes the entire agreement between JXB and You regarding the Software and supersedes all prior or contemporaneous communications or agreements.

16. Severability
If any provision of this Agreement is held to be invalid or unenforceable, such provision shall be struck and the remaining provisions shall remain in full force and effect.

17. Force Majeure
JXB shall not be liable for any delay or failure to perform its obligations under this Agreement due to causes beyond its reasonable control, including natural disasters, power outages, and other similar events.

18. Contact Us
If you have any questions about this Agreement, please contact JXB at cloudsql@datafusing.com.
BY CLICKING “I AGREE” BELOW, YOU ACKNOWLEDGE THAT YOU HAVE READ AND UNDERSTAND THE TERMS OF THIS AGREEMENT AND AGREE TO BE BOUND BY THEM.

Get Started with CloudSQL for Oracle Fusion