fusion_run_report
Execute a registered BI Publisher report using chosen bind values; unknown parameters are rejected before calling to avoid running on defaults. Returns data with row counts and a truncation flag.
Instructions
Run one registered BI Publisher report with bind values.
The statement lives in the report's data model, written once by an administrator; you choose only the values for the binds it declares. That is the same trust boundary the Fusion UI enforces, and on a pod that refuses lexical substitution it is the only path that reaches the database at all.
Discover names and parameters with fusion_list_reports. An unknown report
name, or a parameter the report does not declare, is rejected here -- before
any round trip -- with a message listing what IS accepted; correct the call
from that list rather than guessing, because a dropped parameter would run the
report on its stored defaults and return a plausible wrong answer.
The report applies no row cap of its own, so max_rows is applied after the
rows arrive: row_count is what you are given, rows_returned_by_report is
what came back, and truncated is true when those differ.
Args:
report: Registered report name, as listed by fusion_list_reports.
params: Bind values, e.g. {"p_pattern": "%INVOICE%"}. Omitted parameters
take the report's registered default.
max_rows: Rows to return, clamped to the server's hard maximum.
timeout_s: Per-call timeout in seconds.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| params | No | ||
| report | Yes | ||
| max_rows | No | ||
| timeout_s | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||