FUSE
Menu
Get FUSE

Oracle Fusion · BI Publisher

Write SQL forOracle Fusion.

Look up tables, write SQL through BI Publisher, and filter, compare, or export your results.

Download FUSE RC28 See the workbench

Free · RC28 · Windows x64 · ZIP, EXE and MSI

View full size
FUSE RC28 in light theme, showing the SQL editor, query library and sample results
Actual RC28 workspace. Sample data.
Explore FUSE
Oracle-aware editorSchema explorerReviewed relationshipsRead-only guardQuery libraryCSV · XLSX · JSON

SCHEMA REFERENCE

Explore Fusion tables
as you write SQL.

Look up columns without leaving the editor.

Browse table descriptions, inspect relationships, and open the Oracle documentation to check a column or join.

Sculptural forms moving from a precise graphite ribbon through a terracotta bridge into an ordered ivory grid

SQL and schema reference Look up tables alongside your query.

FROM QUERY TO RESULTS

Illustrated workflow · sample data

  1. SQL EDITOR

    Write a query.

    Open a draft, type a table alias, and see its column suggestions beside your query.

    SQL editor · table and column suggestions

  2. SCHEMA EXPLORER

    Find the columns you need.

    Search Fusion tables, read column descriptions, and open the matching Oracle documentation.

    HCM · Financials · Common · Procurement · Supply Chain

  3. RELATIONSHIP REVIEW

    Check a table relationship.

    Trace table relationships and check their sources or review notes before using them in your query.

    Documented links · review notes

  4. RESULTS

    Review and export results.

    See how many rows were returned and displayed. Review the grid, then export the displayed rows.

    CSV · XLSX · JSON

THE WORKBENCH

Edit and save
Fusion queries.

The editor, query library, and results are available in the same window.

Column suggestions

Find columns as you type. Format your SQL and run the current statement with Ctrl+Enter.

SQL files and query folders

Keep queries in folders, save SQL files where you choose, and import existing work without changing the originals.

Results and exports

Filter and compare results, resize columns, and export to CSV, Excel, or JSON. Oracle date and timestamp values stay unchanged.

WRITEDISCOVERREVIEWRUNEXPORT

RELATIONSHIPS

Inspect the links
between tables.

Follow the links between people, assignments, jobs, and organizations. Check the source or review notes before using a join in your SQL.

DocumentedOracle sourceReviewedReview notesCandidateUnverified match

Unverified matches stay separate. They are not automatically used to connect other tables.

Terracotta relationship routes connecting charcoal nodes across translucent panels Table relationships · illustration
A graphite slate held within a precise terracotta frame in a softly lit architectural alcove
LOCAL
CONTROL

PRINCIPLES

How FUSE uses
your Oracle access.

FUSE works through BI Publisher, using the Oracle Fusion permissions you already have.

  • Checked SELECT and WITH statements

    FUSE blocks direct data-changing SQL. Custom functions can still have side effects. Use least-privileged access in an authorised non-production environment.

  • Local password storage

    Windows protects saved passwords for your account. Other workspace data and SQL files are not encrypted by FUSE.

  • No direct database connection

    FUSE sends queries through Oracle Fusion BI Publisher. It does not give you access beyond your existing permissions.

  • No usage tracking in the app

    FUSE does not send usage analytics. It contacts your tenant only when you choose to prepare, test, or run.

Read the privacy notice

WORKSPACE SETTINGS

Arrange your
workspace.

Resize panels, adjust display settings, and use keyboard shortcuts.

⌘

Keyboard shortcuts

Run the cursor statement with Ctrl+Enter, save queries, search, navigate results, and open commands from the keyboard.

↔

Resizable panels

Resize panels and result columns. Collapse local history by day, week or month when you need more space.

◫

Result details

Distinguish null values from empty cells, see when results are limited, and read errors beside your query.

A

Focus and motion

Use visible keyboard focus and reduce animation to suit your preferences.

FUSE FOR WINDOWS

Bring your SQL
to FUSE.

Get FUSE from the Microsoft Store, or use the portable ZIP. Standalone installers and older versions are also available.

Download RC28 Release details

Free · RC28 · Windows x64 · ZIP, EXE and MSI

FAQ

Questions
about FUSE.

Does FUSE connect directly to an Oracle database?＋

No. FUSE works through Oracle Fusion BI Publisher services and the access already granted to your user.

Can FUSE change Oracle data?

FUSE accepts one SELECT or WITH statement and blocks direct data-changing SQL. Custom functions can still have side effects under your Oracle permissions. Use least-privileged access in an authorised non-production environment.

Connection setup can create missing BI Publisher report objects. Get your environment owner's permission first.

Which Fusion areas can I work with?

The schema catalog covers HCM, Financials, Common, Procurement, and Supply Chain. Connection presets are available for HCM and Financials / SCM. Your Oracle permissions determine which data you can access.

Check the linked Oracle documentation before using a column or join. Catalog coverage varies, and missing information is marked in the app.

Can I download FUSE now?

Yes. FUSE is free for Windows. Get it from the Microsoft Store or download the portable ZIP. Standalone installers and older versions are also available.

How do I use large SQL?

Add your Fusion connection and choose Save & test. New HCM and Financials / SCM connections use the included V3 model. Existing models are not overwritten.

FUSE accepts up to 1 MiB of SQL text; your Oracle environment may allow less. See connection setup.

Does the portable version keep my work?

Yes. Your workspace is stored in your Windows user profile. Save also writes a SQL file to your chosen folder.

Before closing, wait for Workspace saved, close the app window, then the console. To update, extract into a new folder and keep your existing workspace and SQL files. Run one portable version at a time.

Can I use my own coding assistant?

Yes. Connect Codex or Claude through Settings > Coding tools. The companion provides schema context, and you approve each query request inside FUSE.

Result sharing is off by default. Optional samples require your permission and may reach your coding tool's provider without automatic redaction. Your coding tool's separate file permissions still apply. Read the privacy notice.

Created by

AnandVegaraju

Design and development