Product

Everything you need to work with Oracle Fusion data.

One place to query, understand, check and govern data across all of your Fusion pods.

Querical Studio

SQL workbench

Write, run and share SQL - safely.

Autocomplete knows Fusion tables, columns and joins. Results page through any size; extracts run in the background.

  • Bind variables with typed parameter forms
  • Saved queries, starter packs and team collections
  • Offline explain and tuning hints; optional AI assistant
  • Excel export with formatting, CSV and share links
Querical Studio

Catalog & 360 views

Start from a curated catalog.

Curated queries and 360 views for Subscriptions, Sales, Service, TCA, Financials, Procurement, Order Management, Inventory and HCM.

  • Find any number across every object at once
  • Related records grouped into sections
  • Open any related row as a form
Querical Studio

Query builder

No SQL? No problem.

Pick a starting table, tick the columns, add related tables using known joins, filter and sort - then open the generated SQL and run it.

Querical Studio

Check & compare

See exactly what is wrong - and what changed.

Run validation packs with history, compare a query or the setup between two pods, and keep snapshots to compare before and after a change.

  • Go-live and data-quality checks per area
  • Lookups, profiles, price books, queues, business units
  • Cell-level differences with Excel export
Querical Studio

Operate

Keep an eye on scheduled processes.

Errors, warnings, running and long-running ESS jobs, with duration trends by job - for hypercare and day-to-day support.

Querical Studio

Collaborate

Investigate together.

Notebooks keep notes and several SQL steps together. Comment, mention, share expiring links with masking enforced, request four-eyes approval and schedule reports by email.

See it on the demo pod.