FEATURES

Every tool you need to
query Oracle Fusion data.

FusionLens SQL is a browser-based SQL IDE that connects directly to Oracle Fusion Cloud — with AI Text-to-SQL, a schema browser, and one-click Excel/CSV export.

SQL Editor AI-Powered Works in Browser Oracle Fusion Native

Built for Oracle Fusion. One Platform.

Thirteen features in four categories — all running on your live Oracle Fusion connection.

SQL Development
Oracle Fusion SQL Workspace

Write, execute, and validate SQL from your browser — no BI Publisher setup, JDBC clients, or local tools required.

Full SQL Support

Use JOINs, CTEs, subqueries, analytic functions, and bind variables without OTBI restrictions.

Results in Seconds

Execute SQL directly against Oracle Fusion Cloud and get results in seconds instead of waiting for reports to be generated.

Bind Variable Support

Use bind variables with any supported data type to create parameterized queries without rewriting SQL.

AI-Powered Development
AI SQL Generation & Chat

Generate SQL from natural language using AI that understands Oracle Fusion metadata. Refine queries, explain tables, and send SQL directly to the editor.

Fusion Metadata Explorer

Search Oracle Fusion tables, views, columns, keys, and business objects from a searchable metadata catalog.

Context-Aware Autocomplete

Get intelligent suggestions for tables, columns, aliases, and SQL syntax while you type using your Oracle Fusion schema.

Security & Governance
Granular Security

Define exactly which users can query specific tables and columns with application-level security, independent of Oracle Cloud roles.

Table-Level Query Blocking

Restrict query execution on selected Oracle Fusion tables without modifying your Oracle Cloud security model.

Column-Level Masking

Mask salary, personal information, or any sensitive column based on user permissions while keeping your Oracle Fusion environment unchanged.

Productivity
One-Click Export

Download query results to Excel or CSV with a single click — no row limits or additional reporting tools required.

SQL History

Search, organize, and reuse previous SQL statements with a complete query history.

Native Oracle Fusion Connectivity

Connect directly to Oracle Fusion using your existing credentials — no data replication, middleware, or synchronization required.

SQL Editor

A real SQL editor — not a text box.

FusionLens SQL Editor is built around the Oracle Fusion data model — snippet library, autocomplete that knows Fusion tables and columns, inline validation, and metadata inspection all connected to your live Oracle Fusion instance.

  • Snippet library — save reusable SQL blocks, insert with a single keystroke
  • Autocomplete for Oracle Fusion tables, columns, and functions
  • Inline validation — unknown tables and columns flagged before you run
  • F4 / Ctrl+Click — inspect column names, data types, and BI Publisher XML
  • Bind variable support — parameterized SQL with any data type
  • Multi-tab editor — run multiple queries side by side
FusionLens SQL Editor snippet library and saved queries
AI FeaturesBETA

SQL from plain language - in seconds.

FusionLens AI knows Oracle Fusion's table structure. Describe what data you need and get a working SQL query — with correct joins and date logic.

AI Text-to-SQL

Describe what you need. FusionLens generates the SQL — with correct Oracle Fusion tables, joins, and date logic. Review it, then run it directly.

  • Generates SELECT, JOIN, WHERE — automatically
  • Send to editor with one click
  • Refine with follow-up prompts
AI Chat Assistant

Ask anything about Oracle Fusion data, tables, or business logic. The AI keeps full conversation context — follow-up questions, schema exploration, query debugging. Continuously trained on Oracle Fusion, module by module.

  • Persistent conversation history
  • Answers "which table holds X?" questions
  • Claude, Gemini and Llama — your choice of model
Learn more about AI features
Fusion Metadata Explorer

Browse Oracle Fusion's schema without knowing it.

Oracle Fusion has thousands of tables. Fusion Metadata Explorer organizes them by module — so you can find what you need by clicking, not by memorizing.

  • Browse by module: HCM, Financials, SCM, Procurement and more
  • See column names, data types, and constraints at a glance
  • Full-text search across all Oracle Fusion objects
  • Inspect any view's underlying SQL directly
FusionLens Database Browser showing Oracle Fusion view SQL definition
FusionLens Query History last 15 queries quick access panel
Query History

Nothing gets lost.

Every query you run is automatically saved and searchable. Find any past query by text, date, or environment — and send it back to the editor in one click.

  • Full query history — search by SQL text, date, or environment
  • Re-run or send any past query back to the editor instantly
  • Row count, execution time, and status for every query
Background Execution

Submit and come back. Nothing blocks you.

Long-running Oracle Fusion queries don't have to freeze your browser. Submit them to the background, continue working, and come back when they're done.

  • Run up to 5 queries concurrently in the background
  • Results persist across page refresh
  • Export to Excel or CSV directly from background results
FusionLens Background Execution browser storage mode with persistent results
FusionLens Catalog Manager data model detail with SQL datasets and field definitions
Catalog Manager

Browse your BI Publisher catalog — from inside FusionLens.

Navigate every shared and custom folder in your Oracle Fusion catalog. Download report definitions, inspect data model SQL, and send it to the editor.

  • Full catalog tree — shared and custom folders
  • Download or upload report definitions
  • View datasets, SQL queries and field definitions
  • Send data model SQL to editor with one click
Multi-Environment

DEV, TEST, PROD — in one session.

Connect to multiple Oracle Fusion environments and assign a different connection to each editor tab. Switch environments mid-query — without losing your SQL or closing anything.

  • Separate connection per editor tab
  • Switch environment without reloading or losing SQL
  • Visual indicator shows which environment each tab is connected to
  • Run the same query across DEV and PROD side by side
FusionLens connection switching between Oracle Fusion environments
Export

Results ready to share — one click.

Export any query result to Excel or CSV instantly. Formatted headers, correct encoding, no row cap — exactly what you'd spend 5 minutes doing by hand.

.xlsx with formatted headers CSV with locale-safe delimiter No row cap
FusionLens Desktop AppBETA

Beyond Oracle Fusion's own Setup and Maintenance.

FusionLens Desktop lets you read, trace, and correct Oracle Fusion configuration objects like Fast Formulas and Value Sets - without navigating Setup and Maintenance screens.

Included with Premium and Enterprise plans — not sold separately
Fast Formula Editor

Search formulas, read and correct their text. Ctrl+Click any Value Set or Database Item, run live SQL, and hover a variable to see what it resolves to through IF/ELSE branches.

  • Shows the formula's full text right in the editor
  • Save, Submit, Compile, Refresh - all in place
  • Simulate to see the RETURN result with your own inputs
FusionLens Desktop Fast Formula editor describing a Value Set with its underlying query and live result
Learn more about Fast Formula
Flex Value Sets

Search Value Sets, see the real values for Independent-type sets, and for Table-type sets, view and run the SQL behind their definition.

  • Not a generic message - the real Module/FROM Clause/Value Column
  • Keeps your place when switching between Value Sets
FusionLens Desktop Flex Value Set detail showing Module, FROM Clause, Value Column, and underlying query
Learn more about Flex Value Sets
Restore a Previous Session

Every SQL Editor session is saved automatically. Reopen the app and browse your session history by date, search by tab name or SQL text, and bring back an entire set of tabs - full SQL text, tab names and all - as new tabs.

  • Search past sessions by tab name or SQL text
  • Restoring opens new tabs - your currently open tabs are left completely untouched
  • A guided, one-by-one flow reconnects every environment the restored session needs
FusionLens Desktop Restore Session dialog listing previous multi-tab SQL Editor sessions, searchable by tab name or SQL text
FusionLens Desktop reconnect environments prompt after restoring a session, walking through each needed connection one by one
Plan Availability

Which features on which plan?

All plans include the core SQL editor. Premium features unlock progressively.

Feature
Basic
Premium
Enterprise
Web App Access
Desktop App Access
SQL Editor
Export Excel / CSV
Unlimited Editor Tabs
Unlimited Query History
Fusion Metadata Explorer
Background Execution
Catalog Manager
AI Text-to-SQL
AI Chat Assistant
Table-Level Query Blocking
See full feature comparison on the Pricing page

Ready to query Oracle Fusion data?

Start free — no credit card required. Upgrade when you need more.

Get Started Free View Pricing