Search Results get_select_stmt

Overview

The APPS.FA_RX_PUBLISH package is a public PL/SQL package in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 that serves as the metadata access layer for the Oracle Assets (FA) reporting and publishing engine, commonly known as RXi. The package does not produce formatted report output itself. Instead, it exposes the structural definitions, parameters, column layouts, break levels, and summary definitions that belong to a report, so that a generic publishing engine can iterate over those definitions and drive rendering. The package is declared AUTHID CURRENT_USER and carries the original header identifier FARXPBSS.pls 120.5.

Its central design role is the encapsulation of the call sequence documented in the package body. Consumers invoke Init_Report or Init_Request, retrieve report-level information through Get_Report_Info, and then loop through formats, parameters, break levels, columns, and summary columns before emitting data and ending the format. This orchestration makes FA_RX_PUBLISH the contract between stored report definitions and the runtime report renderer.

Key Procedures and Functions

The documented API surface comprises 26 procedures and functions, several of which are specifically relevant to the search term get_report_info:

• GET_REPORT_INFO — Returns descriptive information about the report being processed. It is called immediately after initialization and before any format iteration, serving as the primary metadata entry point for the publishing engine.
• GET_REPORT_NAME — Given a report identifier, returns the application short name and concurrent program name of the associated concurrent program.
• INIT_REPORT / INIT_REQUEST — Initialize the package state for a report definition or an individual concurrent request.
• GET_FORMAT_INFO / START_FORMAT / END_FORMAT / FORMAT_AVAILABLE — Enumerate and manage the formats defined for the report.
• GET_PARAM_COUNT / GET_PARAMETER — Identify and iterate the report parameters.
• GET_BREAK_LEVEL_COUNT — Returns the number of break levels defined for the report.
• GET_COLUMN_COUNT / GET_COLUMN_INFO and GET_SUMMARY_COLUMN_COUNT / GET_SUMMARY_COLUMN_INFO — Expose detail column and summary column definitions per break level.
• GET_SELECT_STMT, GET_ALL_COLUMN_COUNT, GET_DISP_COLUMN_COUNT, GET_FORMAT_COL_INFO, GET_ALL_SUMMARY_COUNT — Supplementary routines providing SQL statement text and column/summary counting metadata.

Package globals include page_break_level (−1), page_carry_forward_level (−2), and report_break_level (−3), along with the MOAC message constants used for multi-org report headings.

Tables Accessed

The package reads from Oracle Assets reporting definition tables and supporting EBS foundation tables, including FA_RX_REPORTS, FA_RX_REP_COLUMNS, FA_RX_SUMMARY, FA_RX_ATTRSETS, and FA_RX_MULTIFORMAT_REPS. It also references FND_APPLICATION, FND_CONCURRENT_PROGRAMS, FND_CONCURRENT_REQUESTS, FND_DESCR_FLEX_COLUMN_USAGES, and FND_FLEX_VALUE_SETS for name resolution and flexfield metadata. Dynamic SQL is executed via DBMS_SQL, with PLITBLM used for string/table manipulation.

Usage Notes

FA_RX_PUBLISH is not designed for direct end-user invocation. It is called programmatically by the RXi publishing engine, typically from a concurrent program that renders Oracle Assets financial reports. Custom code should respect the documented call sequence—initialize, obtain report info, loop formats, parameters, break levels, columns, and summaries, then output data—and must not reorder or skip steps, as internal state is sequenced. Because no other documented package references it, FA_RX_PUBLISH functions as a leaf metadata provider. The bug references (8402286, 4394814) indicate MOAC behavior is conditionally applied when the concurrent program's multi_org_category matches the flag value 'M'.