How to find Oracle Fusion tables and work out their joins
The hardest part of Fusion SQL is rarely the SQL. It is knowing which table holds the data and how it joins to the next one. These are the practical ways to find out.
Start from what you know
- A table or view name from a report, a data model or a colleague.
- A value on a screen. Search for the table that holds it, then check its columns.
- An existing query. Trace its tables and joins, since the join conditions already work.
Browse tables and relationships
The free ERD Explorer on this site lets you browse more than 15,000 Fusion tables and views and see how they join on an interactive diagram. It can also generate the JOIN path between any two tables. Open the ERD Explorer.
Let the editor suggest the join
In FuiSQL, type an alias and a dot, and the editor resolves it from your FROM and JOIN clauses and lists that table's columns. It also suggests the join condition between the tables in your query and offers a short alias for each table. For tables that are not directly related, Suggest Join Path writes the whole join.
Drill down from a result
Right-click any result cell to jump to the tables it belongs to, or the tables that refer to it. A breadcrumb trail takes you back, so you can follow a value from one table to the next without losing your place.
Check before you trust a join
- Run the join with a small row limit first and look at the result.
- Watch for duplicated rows, which usually mean a missing condition.
- Remember that the data you can see depends on your BI role.
New to running SQL against Fusion? Start with how to run SQL against Oracle Fusion from VS Code.
Frequently asked questions
Is the ERD Explorer free?
Yes. It is a free web tool on this site.
Which areas of Fusion are covered?
The schema dictionary in FuiSQL merges Oracle's published definitions across Financials, HCM, PPM and Procurement.
Run SQL against Fusion from VS Code. FuiSQL has a free trial.
See FuiSQL Get it from the VS Code MarketplaceRelated guides
FuiSQL is an independent product by FuiSQL. Oracle and Fusion are trademarks of Oracle and/or its affiliates; FuiSQL is not affiliated with, endorsed by or sponsored by Oracle.