# Querical Studio

> Querical Studio is a web-based, governed SQL workbench for Oracle Fusion Cloud Applications (ERP, SCM, HCM and CX). It runs read-only SQL on any Fusion pod through a BI Publisher report, without database access, and adds a curated query catalog, 360-degree record views, validation packs and enterprise governance.

## What it does
- Read-only SQL on Oracle Fusion Cloud via BI Publisher (ExternalReportWSSService), with paging and background extracts to Excel/CSV.
- A curated catalog of 300+ queries and tables, and 360 views for 19 business objects across Subscription Management, Sales, Service, TCA, Financials, Procurement, Order Management, Inventory and HCM.
- SQL with autocomplete: Write SQL against the Fusion data model, run it, decode codes and profile the result.
- 360 view of any record: Paste a subscription, order or invoice number and see every related record, linked.
- Record view: Open any row as a form: grouped fields, search, and next / previous through the result.
- Build a query without SQL: Pick a table and columns, add joins and filters - the SQL is written for you.
- Validation packs: Ready-made data-quality checks that list exactly which records break a rule.
- Scheduled processes monitor: ESS errors, warnings, long runners and trends per job, at a glance.
- Compare a query or the setup between two pods; snapshots; notebooks; comments and share links; scheduled reports; optional AI SQL assistant; REST API.
- Governance: roles per pod, business justification, four-eyes approval, column masking, row rules, PII discovery, audit trail, SIEM streaming, SSO, MFA and passkeys.

## Reference
- [Oracle Fusion Cloud data reference](https://quericalstudio.com/reference/)
- [Subscription tables in Oracle Fusion Cloud](https://quericalstudio.com/reference/subscriptions/): OSS_ subscription headers, product lines, covered levels, renewals and customer names.

## Who it is for
Oracle Fusion implementation consultants, partners, and customer IT / support teams who need to query and validate Fusion data quickly and safely.

## Pricing
- Pro: $39 per user / month
- Team: $149 per month, up to 5 users
- Enterprise: Contact us tailored to your organization
- Every plan starts with a 14-day free trial; no payment details are needed.

## Key facts
- 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.

## Links
- [Product](https://quericalstudio.com/product/)
- [Pricing](https://quericalstudio.com/pricing/)
- [Security](https://quericalstudio.com/security/)
- [Setup guide](https://quericalstudio.com/docs/setup/)
- [Sign in](https://app.quericalstudio.com/)
- Contact: engage@quericalstudio.com