Fusion Query
Live appAd-hoc SQL on Oracle Fusion, with an AI that writes the query
A web tool that runs ad-hoc SQL against Oracle Fusion through BI Publisher. Type SQL directly, or ask in plain English and an AI assistant generates the query, runs it, and feeds any Oracle error back to itself to self-correct. Includes a browsable catalog of Fusion tables, email-verified access, and per-user query history.
React · Vercel · BI Publisher SOAP · multi-provider AI
Open the app ↗The problem it solves
Getting ad-hoc data out of Oracle Fusion usually means filing a report request or waiting on someone with BI Publisher access. A business user who knows exactly what they want still cannot just ask the system for it.
How it works
- 1
Access is gated. Users register and confirm a one-time email code before they can reach the tool.
- 2
Ask in plain English. Here: “List the top 10 suppliers with their supplier number and creation date.”
- 3
The AI writes the SQL, runs it, and self-corrects. Its first attempt hit an Oracle error; it fixed the query and succeeded on the second.
- 4
Real rows from the live Fusion instance, ready to export to CSV.
Why it's useful
- →Ask in plain English, or write SQL directly — no BI Publisher know-how required.
- →The AI runs its own query, reads any Oracle error, and rewrites until it works, so a near-miss still lands.
- →A browsable catalog of Fusion tables, per-user query history, and one-click CSV export.
- →An email-verified access gate keeps the tool limited to people you invite.