The Ultimate CLI Toolkit
for Oracle Cloud ERP

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

Get Started Free
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 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.

Read more about Oracle Cloud SQL Studio

Use the Complete Toolkit Free for 30 Days

Create your account, activate your email address, and sign in to your dashboard to download the complete toolkit and receive your signed 30-day trial licence. No card, payment, automatic renewal, or commitment.

Create Your Free Account
Scroll to Top