fusion_list_tables
Search Oracle Fusion Cloud tables by SQL LIKE pattern and owner, sorted by approximate row count, to identify the real transactional table among similarly named objects.
Instructions
List Fusion tables matching a SQL LIKE pattern, most-populated first.
Runs the registered list_tables report with p_pattern / p_owner as bind
values. The report applies no row cap of its own, so limit is applied here
after the rows arrive and truncated says honestly whether more came back.
approx_rows comes from all_tables.num_rows, an optimiser statistic that
can be stale or NULL -- treat it as a hint about which of several similarly
named objects is the real transactional one, never as a count. It is also the
quickest way to spot the same-name-different-case pairs this pod carries: the
populated one is the real table.
The owner and pattern echoed back are the values that were actually
bound, which is not always what you passed: omitting one applies the
report's registered default, and the full set is in params_used.
Args:
pattern: SQL LIKE pattern, e.g. %INVOICE%. % matches any run of
characters. Matching is case-insensitive inside the data model.
owner: Schema owner; FUSION for application data. The data model
compares it with LIKE, not =, so % searches every schema the
service account can see. Omit (null) to bind the report's registered
default instead (FUSION in the shipped registry).
limit: Maximum rows to return from those the report produced.
include_views: Not backed by any report -- see the error it returns.
datasource: Legacy composed-SQL fallback only; ignored on the report path.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | ||
| owner | No | FUSION | |
| pattern | No | % | |
| datasource | No | ||
| include_views | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||