The Ultimate CLI Toolkit
for Oracle Cloud ERP

Run SQL queries from your local machine, automate BI Publisher extracts, schedule ESS jobs, and more.

java -jar .\fusion-cli-toolkit.jar set-config \                                                      
        --username='YOUR_USERNAME' \ 
        --password="YOUR_USER_PASSWORD" \ 
        --hostname="https://YOUR_ORACLE_CLOUD_POD.fa.ocs.oraclecloud.com:443" \ 
        --licenseKey="YOUR_FUSIONCLITOOLKIT_LICENCE_KEY"

Configuration saved successfully.


java -jar .\fusion-cli-toolkit.jar submit-ess-job \ 
        --jobPackageName="/oracle/apps/ess/hcm/users/" \
        --jobDefinitionName="SyncRolesJob"

License is valid until 2026-02-08
Submitting ESS Job: SyncRolesJob
Connection status: 200 | Connection response: OK | Post data size: 773
ESS Job submitted successfully.


java -jar .\fusion-cli-toolkit.jar sql-query \
        --queryFile=".\Query.sql" \
        --outputFile=".\QueryResult.csv"

License is valid until 2026-02-08
Reading SQL query file: .\Query.sql
Executing query...
Connection status: 200 | Connection response: OK | Post data size: 1802
Query execution complete. Output saved to: .\QueryResult.csv

Why Fusion CLI Toolkit?

CLI-based solution that runs efficiently on your local machines, Linux servers, or Kubernetes cron jobs. Powerful automation for Oracle Cloud ERP—save time, reduce manual work, and enhance accuracy with our all-in-one toolkit.

Run SQL Queries – Skip BI Publisher’s tedious data model setup. Execute SQL queries directly on Oracle Cloud from your local machine.
Automate ESS Jobs – Avoid Oracle Cloud scheduling issues. Run ESS jobs reliably via cron, ensuring seamless execution without unnoticed failures.
BI Publisher Integration – Upload, download, migrate and manage BI reports seamlessly.
CLI & API Access – Automate tasks via CLI and API, securely calling any Oracle API locally. Unlock endless use cases beyond built-in features.
Secure Configuration & Licensing – Runs entirely on your infrastructure with encrypted storage—no data ever leaves your environment.
# Run a SQL Query locally
java -jar .\fusion-cli-toolkit.jar sql-query \
    --queryFile=".\Query.sql" \
    --outputFile=".\QueryResult.csv"      

# Schedule and Run ESS Jobs :
java -jar .\fusion-cli-toolkit.jar submit-ess-job \
      --jobPackageName="/oracle/apps/ess/financials/commonModules/shared/common/interfaceLoader/" \
      --jobDefinitionName="SyncBellNotifications"

# Run a BI Publisher Report :
java -jar .\fusion-cli-toolkit.jar bi-publisher-run-report \
    --reportPath="Custom/SQL/SQLTestReport.xdo" \
    --format="csv" \
    --outputFile="C:\FusionCliToolkit\SQLTestReport.csv"

# Discover all the other commands in the documentation

Screenshot of Oracle Cloud SQL Studio - SQL Developper alternative by Swiss Fusion Toolkit

Run SQL Queries on Oracle Cloud ERP
with a User-Friendly Windows App

Easily execute SQL queries on Oracle Cloud ERP from your Windows PC with our intuitive, portable SQL tool. just like SQL Developer for on-premise ERP. Save queries, export results, and streamline your workflow effortlessly.

See It in Action – Get a demo license key

Experience firsthand how our CLI toolkit automates Oracle Cloud ERP workflows—securely, efficiently, and with full control over your infrastructure.
Request a 1-month demo license key to test it in your own environment.

Scroll to Top