fusion_bootstrap
Bootstraps missing BI Publisher reports that table/column inspection tools require, so metadata queries work on a fresh Oracle Fusion pod. Bundled SQL only; existing reports are skipped.
Instructions
Create the exploration reports this pod is missing, from shipped SQL.
Call this when fusion_list_tables / fusion_describe_table / fusion_search_columns / fusion_describe_flexfields fail on a pod that is otherwise healthy: each of them runs a BI Publisher report that has to exist in the catalog first, and a fresh pod has none of them. A passing fusion_health_check does NOT cover this -- the connection can be perfect while the catalog is empty.
No SQL is accepted from you. The four statements are files inside this
package, held to their declared columns and binds by offline tests; this
tool only chooses whether to send them. It is therefore much narrower than
fusion_author_report, and gated separately (fusion.allow_bootstrap).
Safe to call twice: an object already in the catalog is reported as
skipped, never replaced and never deleted. Replacing one is a human
decision, made with fusion-query-bootstrap --force in a shell.
Each new report is run once with pillar-neutral probe binds and its parameter echo checked. A report whose echo fails is left in the catalog but NOT registered, and reported as failed -- it would otherwise answer the same thing whatever it was asked.
Args:
only: Bootstrap just these reports, e.g. ["list_tables"]. Default: all four.
folder: Catalog folder to create them in.
data_source: BI Publisher data source. Default ApplicationDB_FSCM;
an HCM-only pod needs its own, e.g. ApplicationDB_HCM.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| only | No | ||
| folder | No | /Custom/MCP | |
| data_source | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||