Skip to content
ERP Query Studio

Write real SQL against Oracle Cloud ERP

A desktop SQL worksheet for invoices, journals and suppliers — every query runs through your tenant’s BI Publisher, under your own Oracle login

Join the Launch ListSee How It Works

Launching soon · macOS and Windows

ERP Query Studio on a demo connection, running a worksheet condensed from the ERP Query Pack’s AP Open Invoice Aging by Due-Date Bucket query. With :supplier_name set to %, the grid shows 36 open invoices, each labeled with its aging bucket, and the results toolbar reads 36 rows, 1.2 s.

The problem

You know SQL. Oracle Cloud ERP won’t let you use it. There’s no database connection to point a tool at, so every question becomes a BI Publisher data model, an OTBI subject area, or a ticket and a wait.

One month-end question, start to finish

Pull July’s trial balance for the US ledger into Excel. Here is the whole job, in one worksheet.

  1. Step 1 of 4

    Find the table

    Type part of a name and the Object Explorer ranks matching tables and views as you type, across tens of thousands of objects.

    The Object Explorer search box holds gl_bal and the ranked list has narrowed to one table, GL_BALANCES.

  2. Step 2 of 4

    Write the query

    Type an alias and a dot, and autocomplete lists that table’s columns and their types, so there are no column names or module prefixes to memorize.

    The editor shows the trial balance query being written. After typing bal.period_net, autocomplete lists four GL_BALANCES columns, each a NUMBER.

  3. Step 3 of 4

    Run it for the period

    Bind variables are prompted when you run and remembered per tab, so next month you change one value and run it again.

    The Enter Bind Variables prompt holds JUL-26 for :period_name and Summit US Primary Ledger for :ledger_name, over a grid of 32 trial balance rows.

  4. Step 4 of 4

    Export to Excel

    Send the rows to Excel or CSV. A full export writes every row to disk, up to your export cap: 50,000 rows by default, adjustable to 1,000,000.

    The Export menu is open over the 32 trial balance rows, offering CSV, Excel and JSON.

ERP Query Pack

Start from 63 queries that already work

The ERP Query Pack installs with the app: 63 queries across 9 modules, from AP aging and invoice holds to period statuses, role audits and scheduled-process history. Each one was checked on a live tenant.

Your own queries sit beside them, in folders you can export as a bundle for the rest of the team.

The Query Library sidebar in the Query Packs scope. ERP Query Pack (63) is expanded to its nine module folders of seven queries each: General Ledger, Payables & Suppliers, Receivables & Customers, Procurement, Inventory & Items, Order Management, Assets & Cash Management, Users, Roles & HCM, and System & Metadata. Payables & Suppliers is open, listing AP Invoice Register by Date Range, AP Open Invoice Aging by Due-Date Bucket, Active AP Invoice Holds, AP Payment Register with Invoice Allocations (Invoice-to-Payment Trace), Supplier Master with Active Sites and Addresses, Supplier Bank Accounts by Supplier and Site, and Unaccounted AP Invoice Distributions. The pointer rests on AP Open Invoice Aging by Due-Date Bucket, showing its Insert in current tab, Open in new tab and Customize buttons.

Oracle errors, decoded

ORA-00942, in plain English

When Oracle rejects a query, you get a plain-English title, a hint and the likely causes, with a link to Oracle’s documentation, for 92 ORA codes. Every failure carries a short reference that matches its log line, so support can find it.

A worksheet has run the GL trial balance query, whose FROM clause on line 17 names gl_balances_x, a table that does not exist. In place of results, the app shows the decoded error: ORA-00942, Table or View Not Found, with Oracle’s message “table or view does not exist”. A hint says to verify the table name exists and is spelled correctly, noting that Fusion tables are usually uppercase and that the Object Explorer lists the available tables. Four common causes follow: a misspelled table name, a table in a schema you cannot access, an incorrect table suffix, and a missing SELECT privilege. Below them are a link to Oracle Documentation and the reference Ref: 436e3409. The status bar reads SQL error.

Reports Catalog

Run the BI Publisher reports you already have

Browse your BI Publisher catalog, read the SQL behind any data model, and run a report in BI Publisher after filling in its parameters. Results land in the grid, up to 100,000 rows, or download the report in its template’s own format.

The Reports Catalog on the Summit — DEV1 (Demo) connection. Under Custom, Summit Outdoor Supply, Payables, the report AP Invoice Aging is selected, and its details list three parameters — Business Unit, text, required, default Summit US Operations; As of Date, a required date; Minimum Days Past Due, a number, default 0 — with its data model path and the Open in Editor and Run on Server buttons. Beside it, the Run on Server dialog for AP Invoice Aging holds Summit US Operations, 2026-08-15 and 0, with Apply enabled.

Works on username-and-password connections, not SSO.

Results grid

Work the result before you export it

Sort, filter any column the way Excel does, search every cell, pin and hide columns, read any one record top to bottom, and select numbers to see their count, sum and average. Count Total Rows gets the total from Oracle without loading every row.

The Supplier Audit worksheet in ERP Query Studio. Its query returned 36 supplier sites; the SUPPLIER column is sorted A to Z and filtered to names containing “Co”, so the grid shows 12 of 36 rows. The Single Row View is open on row 3 of 12, listing each column beside its value: SUPPLIER Copper Kettle Catering, SUPPLIER_NUMBER SUP-1094, SUPPLIER_TYPE SERVICES, SUPPLIER_ACTIVE Yes, PROCUREMENT_BU Summit US Operations, SITE_CODE SEATTLE-HQ, PAY_SITE Yes, SITE_PAYMENT_TERMS Immediate, CITY Seattle, STATE WA. First, previous, next and last buttons page through the filtered rows.

  • Values arrive intact

    Account codes like 0042 keep their leading zeros.

  • Copy it how you need it

    Copy as delimited text, distinct values or an HTML table.

  • Filtered rows export as shown

    With a filter on, export just the loaded rows that match.

  • Formulas stay text

    In CSV exports, a cell that would open in Excel as a live formula gets a leading apostrophe, so it opens as text.

What it replaces

The ways people get data out of Oracle Cloud ERP today, and what changes.

  • A BI Publisher data model

    Today
    Build a data model and a report before you see a single row.
    With ERP Query Studio
    Write the SQL and run it. BI Publisher still runs it; there’s nothing to model first.

  • OTBI subject areas

    Today
    Pre-modeled, drag-and-drop subject areas with limited joins.
    With ERP Query Studio
    Real SQL, with real joins across tables and views.

  • An IT ticket

    Today
    File a request and wait for someone else to run it.
    With ERP Query Studio
    Self-serve, on your own machine, with your own Oracle login.

  • SQL Developer or Toad

    Today
    Oracle Cloud ERP gives customers no database connection, so these tools have nothing to connect to.
    With ERP Query Studio
    A familiar worksheet, object explorer, results grid and bind-variable prompt, through BI Publisher.

Straight from your tenant to your desktop

Queries go over HTTPS from the app to your Oracle Cloud ERP tenant’s BI Publisher, and the results come straight back. There is no ERP Query Studio server in the path. Your SQL, results and Oracle credentials are never sent to us.

  • What you need from IT

    An Oracle login with BI Publisher access, such as the BI Consumer role. If your account can’t write to /Custom, or you sign in with SSO, an administrator installs the DataTools package once.

  • What it adds to your tenant

    One small DataTools package — a BI Publisher data model and a report that run your queries — in the catalog under /Custom/DataTools or your own My Folders. It holds no data and no credentials.

  • Who can run it

    ERP Query Studio can only do what your BI Publisher access allows; administrators control who can run it.

  • Your password

    If you choose to save a password, it’s encrypted with your operating system’s secure storage — a Keychain-held key on macOS, DPAPI on Windows. With SSO you sign in on your identity provider’s own page, so the app never sees that password.

  • What else leaves your machine

    License checks go to Keygen, our licensing provider, and update checks go to GitHub. Crash reports go to Sentry: they’re on by default, you can turn them off, and they’re scrubbed of SQL, results and credentials.

  • Signed installers

    Developer ID-signed and notarized on macOS, and signed with Azure Trusted Signing on Windows.

Stop waiting on the report queue

Leave your work email and we’ll let you know when it’s ready to download.

One email at launch. No spam.

$249 per seat per year

$219 per seat for teams of 3 or more

Launching soon · macOS and Windows

  • macOSAvailable at Launch
  • WindowsAvailable at Launch