Search ALL_OBJECTS in Oracle Fusion / ERP Cloud by object name pattern.

keyword: substring to match against object_name (case-insensitive) object_types: optional filter, e.g. ['TABLE','VIEW','PROCEDURE','FUNCTION','PACKAGE'] owner: optional schema owner filter (e.g. 'FUSION') limit: max results (capped at 200)

Returns: owner, object_name, object_type, status, last_ddl_time, table_comment

Find tables/views in Oracle Fusion whose name or comment contains the keyword.

Returns: owner, object_name, object_type, table_comment

Find Fusion tables/views by column name or column comment. Example: search_columns('INVOICE_ID') to find every table with an invoice-id column.

Returns: owner, table_name, column_name, data_type, column_comment, table_comment

Full-text search across ALL_SOURCE in Fusion to find procedures/packages/functions that reference a keyword in their source code.

type_filter: PROCEDURE | FUNCTION | PACKAGE | PACKAGE BODY | TRIGGER Returns distinct owner/name/type — call read_object_source to get the full source.

Note: scans can be slow on large schemas; constrain type_filter and owner where possible.

Full description of a Fusion table or view:

• columns (name, type, length/precision, nullable, default, comment)

• primary key columns

• indexes (name, type, uniqueness, columns)

• table-level comment

• estimated row count from optimizer stats

owner: schema owner, e.g. 'FUSION' table_name: exact table name, e.g. 'AP_INVOICES_ALL'

Read the full source code of a stored object from ALL_SOURCE in Fusion.

object_type: PROCEDURE | FUNCTION | PACKAGE | PACKAGE BODY | TRIGGER | VIEW (omit to return all types for this name) Returns: {owner, name, source: {type: full_source_text}}

Return the full argument list for a stored procedure or function (from ALL_ARGUMENTS). Returns: argument_name, data_type, in_out, position, defaulted, default_value

Note: Fusion MCP does not support dynamic procedure execution (BIP only runs SELECT data models). This tool is for discovery and understanding only.

package_name: required when the procedure lives inside a package.

List all public subprograms (procedures and functions) inside a Fusion Oracle package. Returns: procedure_name, overload index, object_type

Execute a read-only SELECT or WITH (CTE) query against the Oracle Fusion database via BI Publisher.

Only SELECT/WITH statements are accepted — DML, DDL, and PL/SQL are rejected. SQL is executed through the BIP SQL-runner report (deployed manually in the BIP catalog; see FUSION_REPORT_PATH).

sql: the full query text with literal values inlined (BIP does not support bind variables — include values directly, e.g. WHERE org_id = 101) max_rows: maximum rows to return (server cap also applies)

Returns: {columns: [...], rows: [{col: val, ...}, ...], count: N} Note: all values are returned as strings (CSV transport).