Search Results fa_rx_attrsets

Overview

The APPS.FA_RX_PUBLISH package body is a core component of the Oracle E-Business Suite Fixed Assets reporting framework, commonly referred to as the FA RX (Report eXtension) architecture. Its principal business function is to publish the metadata and structural definitions of Fixed Assets reports to consuming clients. Rather than generating formatted output directly, FA_RX_PUBLISH exposes the definitions, formats, columns, parameters, and summary aggregations that make up a given report so that external publishing agents, concurrent programs, and interactive tools can render report content consistently. It acts as the metadata broker between the Fixed Assets repository tables and the presentation layer.

The package is classified as OTHER within the ETRM 12.2.2 metadata, indicating that it is an internal supporting package rather than a public, customer-callable API. It depends on companion packages such as FA_RX_SHARED_PKG, FA_RX_UTIL_PKG, and FA_CACHE_PKG, and it leverages DBMS_SQL for dynamic statement construction. In Oracle EBS 12.1.1 and 12.2.2 the package resides in the APPS schema with status VALID and, per the dependency documentation, is not referenced by any other database object, confirming its role as a leaf-level publishing utility.

Key Procedures and Functions

The package exposes 26 documented procedures. The initialization group — INIT_REQUEST, INIT_REPORT, and START_FORMAT / END_FORMAT — establishes the working context for a given report, format, and concurrent request, while FORMAT_AVAILABLE validates whether the requested format is defined.

Metadata retrieval is handled by GET_REPORT_NAME, GET_REPORT_INFO, and GET_FORMAT_INFO, which return descriptive attributes for the report and its formats. Parameter enumeration is performed by GET_PARAM_COUNT and GET_PARAMETER, allowing the caller to iterate over report parameters. Column structure is exposed through GET_COLUMN_COUNT, GET_COLUMN_INFO, GET_DISP_COLUMN_COUNT, GET_ALL_COLUMN_COUNT, and GET_FORMAT_COL_INFO. Summary aggregations are surfaced via GET_SUMMARY_COLUMN_COUNT, GET_SUMMARY_COLUMN_INFO, and GET_ALL_SUMMARY_COUNT. Break hierarchy is returned by GET_BREAK_LEVEL_COUNT, and the dynamic query text itself is produced by GET_SELECT_STMT.

Tables Accessed

The package reads from the core Fixed Assets RX repository tables. FA_RX_REPORTS and FA_RX_REPORTS_V supply report-level definitions; FA_RX_REP_COLUMNS supplies the column metadata that underpins the column and display column routines; FA_RX_MULTIFORMAT_REPS defines the format variants; FA_RX_ATTRSETS provides attribute set definitions; and FA_RX_SUMMARY holds the summary column definitions. Supporting lookups draw on FND_APPLICATION, FND_CONCURRENT_PROGRAMS, FND_CONCURRENT_REQUESTS, FND_FLEX_VALUE_SETS, and FND_DESCR_FLEX_COLUMN_USAGES, which supply application, concurrent program, request, and key flexfield information.

Usage Notes

FA_RX_PUBLISH is typically invoked indirectly rather than directly by end users. Its routines are called by Fixed Assets report publishing programs and concurrent processes that need to enumerate a report's structure before rendering output, and by diagnostic or customization code that must inspect report metadata at runtime. Because the package relies on the current session's request and report context, callers must invoke INIT_REQUEST and INIT_REPORT before requesting column, parameter, or summary information. Customizations should treat the package as an internal helper: rely on the documented getters for read-only metadata inspection, and avoid direct dependency where a supported public API exists.