Ask Data Anything · SQL workbench for Oracle Fusion Cloud
The SQL workbench Oracle Fusion deserved.
Query any Fusion pod without database access, see any record in one 360° view and check data quality before go-live - with approvals, masking and an audit trail built in.
- ERP
- SCM
- HCM
- CX · Subscriptions
- Sales & Service
No database link, VPN or agent. Read-only by design.
See it in action
Real screens, recorded on the demo pod.
The same offline demo pod you can explore after signing up - pick a workflow and watch it run.
Query
Ask the pod anything.
A proper editor on top of BI Publisher: autocomplete that knows Fusion tables and joins, a curated query catalog, paged results of any size and background extracts to Excel.
- Lookup codes decoded to their meaning in one click
- Profile any result: nulls, distinct values, ranges
- Cost guard flags heavy queries before they hit the pod
Understand
Every record, in one view.
Paste a subscription, order, invoice, supplier or SR number. Related records are grouped into sections - products, charges, billing schedule, invoices, parties and more.
- 360 views for 19 objects across ERP, SCM, HCM and CX
- Find a number across every object at once
- Open any related row as a form
Inspect
Read a row like a form, not a spreadsheet.
Open any result row as a record: fields grouped into keys, status, dates, amounts and parties, with search, empty-field hiding and side-by-side compare.
- Step through records with the arrow keys
- Compare two records field by field
- Copy as JSON for tickets and handovers
Check & compare
The project checks you rebuild in spreadsheets - built in.
Govern
Safe on production by design.
Read-only enforcement, per-pod roles, business justification, four-eyes approval, column masking, row rules and a full audit trail - with SSO, MFA and passkeys.
- Masking applies to exports and share links too
- Every query logged with who, where and why
- Self-host in your own OCI tenancy if required
- Compare setup between pods to catch drift before go-live
What is Querical Studio?
Querical Studio is a web-based SQL workbench for Oracle Fusion Cloud (ERP, SCM, HCM and CX). It runs read-only SQL on any Fusion pod through a small BI Publisher report, with governance, a curated query catalog and 360 views.
How does it query Oracle Fusion without database access?
You install one BI Publisher data model and report in your pod (about 10 minutes, described in the setup guide). Querical Studio sends your SQL to that report through the standard ExternalReportWSSService web service and reads the result back. No database link, VPN or agent is needed.
Is it read-only?
Yes. Every statement is checked before it is sent and only SELECT / WITH queries are allowed. The BI Publisher report runs under the Fusion data source you choose, so Fusion data security still applies.
Does it remove the row limits of OTBI and BI Publisher?
Results are paged, so you can browse any size of result, and background extracts stream large results to Excel or CSV in chunks instead of one oversized report.
Which Oracle Fusion modules are covered?
The catalog and 360 views cover Subscription Management, Sales, Service, Customer Data (TCA), Financials, Procurement, Order Management, Inventory and HCM. Any table visible to BI Publisher can be queried.
Where is my data stored?
Query results are not stored unless you save a snapshot or extract. Pod credentials are encrypted at rest. You can also self-host Querical Studio in your own Oracle Cloud tenancy.
Get your first query running today.
14-day free trial, no payment details needed. An offline demo pod is ready to explore the moment you sign up.