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

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.