Search Results assign_column

Overview

FA_RX_UTIL_PKG is a shared Oracle EBS utility package owned by APPS and classified as OTHER in the ETRM metadata. It provides the runtime foundation for the Oracle Assets (FA) "RX" report-generation framework, a metadata-driven engine used to produce fixed asset reports and extracts without hard-coding SQL into each individual report. The package defines the framework's global record types (Rep_Columns_Rec, Rep_Columns_Array, Report_Record, and Report_Array) that describe which columns a report selects and inserts, and which report sections are enabled along with the procedural hooks that fire before the report, on bind, after each fetch, and after the report completes.

Rather than containing business rules for depreciation, transfers, or asset inquiry, FA_RX_UTIL_PKG supplies the plumbing: it initializes a report request, manages debug and trace state, records column and section assignments, executes the generated report, and routes log and output messages. It acts as the common services layer on which individual FA_RX report definitions are built.

Key Procedures and Functions

• INIT_REQUEST — Initializes a report run, establishing the request context used by the remaining framework calls. This is the entry point most commonly sought by developers.
• INIT_DEBUG — Establishes the initial debug state for the session.
• ASSIGN_COLUMN — Registers a column definition (select name, insert name, placeholder, type, length) into the report's column array.
• ASSIGN_REPORT — Registers a report section and its enabled flag and event hooks.
• RUN_REPORT — Executes the assembled report, applying the configured columns, sections, and event logic.
• LOG — Writes diagnostic or informational messages to the framework's log destination.
• OUT — Emits report output through the framework's output channel.
• ENABLE_DEBUG / DISABLE_DEBUG / DEBUG_ENABLED / DEBUG — Manage and query debug state: turning debugging on and off, testing whether it is active, and emitting debug-level messages.
• ENABLE_TRACE / DISABLE_TRACE — Turn SQL trace on and off for the report session.

Tables Accessed

• FA_RX_REPORTS — Stores the report definitions that drive the framework, including report metadata consumed during initialization and execution.
• FND_CONCURRENT_REQUESTS — Provides the concurrent request context, linking a run to its request ID and status.
• DBMS_SQL — Not a table but the Oracle-supplied dynamic SQL package used to parse, bind, and execute the generated statements at runtime.

Usage Notes

FA_RX_UTIL_PKG is not normally called directly by end users. It is invoked from Oracle Assets report-generation code and from the RX plug-in bodies that define individual reports, which call INIT_REQUEST, ASSIGN_COLUMN, ASSIGN_REPORT, and RUN_REPORT in sequence. The debug, trace, log, and output procedures are support facilities used to diagnose report behavior in development and production troubleshooting. With 40 other packages referencing it, FA_RX_UTIL_PKG is a widely reused dependency, so customizations should treat its interfaces as stable and avoid modifying the package. The header timestamp (120.6, 2009) confirms the package is unchanged across the 12.1.1 and 12.2.2 releases, and its AUTHID CURRENT_USER declaration means it executes with the privileges of the calling schema. Any custom RX report should follow the same init-assign-run pattern and rely on the debug and trace procedures rather than ad hoc instrumentation.