Search Results fa_rx_summary_vl

Overview

FA_RX_SUMMARY_VL is a translated Multi-Lingual Support (MLS) view owned by the APPS schema within the Oracle Assets (OFA) product module. It presents the language-specific subset of Report eXchange (RX) summary definitions used to control how summary or breakdown lines are generated and displayed in Oracle Assets reports. In Oracle EBS 12.1.1 and 12.2.2, Report eXchange is the reporting framework used for asset inquiry and reporting features such as the Asset Inventory and other FA reports, where each report attribute may be summarized at a defined level. FA_RX_SUMMARY_VL exposes the translated summary prompt and summary function metadata that drives this behavior.

The view is not a transactional object; it is a definitional metadata layer. It is consumed by the Report eXchange runtime and by form-based setup when the end user's session language is applied. Because it is a _VL view, it filters the underlying translation table by USERENV('LANG'), so only the rows in the current session language are returned, providing a single-language projection of the two-table MLS base.

Underlying Base Objects

FA_RX_SUMMARY_VL is defined directly over FA_RX_SUMMARY_TL, the translated (TL) table for RX summary definitions. In the documented EBS 12.2.2 metadata, the referenced base object is listed as FA_RX_SUMMARY_TL (SYNONYM), with the owner succeeding to APPS at runtime. The view text is a straightforward projection with a language filter:

• SELECT B.ROWID ROW_ID, B.REPORT_ID, B.ATTRIBUTE_SET, B.COLUMN_NAME, B.PRINT_LEVEL, B.RESET_LEVEL, B.COMPUTE_LEVEL, B.SUMMARY_FUNCTION, B.DISPLAY_STATUS, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.LAST_UPDATED_BY, B.CREATED_BY, B.CREATION_DATE, B.SUMMARY_PROMPT FROM FA_RX_SUMMARY_TL B WHERE B.LANGUAGE = USERENV('LANG').

Note that the view selects the ROWID of the TL row and aliases it as ROW_ID; there is no join to a _B base table in the documented definition, meaning the TL table itself carries the full set of definition columns alongside the translatable SUMMARY_PROMPT. The relationship is therefore one of direct filtered inheritance rather than a B/TL join.

Key Columns

• ROW_ID — The ROWID of the underlying TL row, exposed for row identification in Forms and APIs.
• REPORT_ID — Identifier of the Report eXchange report to which the summary definition belongs.
• ATTRIBUTE_SET / COLUMN_NAME — The attribute set and column being summarized, tying the definition to a specific report attribute.
• PRINT_LEVEL — The level at which the summarized value is printed.
• RESET_LEVEL — The level at which accumulated summary values are reset.
• COMPUTE_LEVEL — The level at which the summary computation occurs.
• SUMMARY_FUNCTION — The aggregation function applied (for example sum, count, or average).
• DISPLAY_STATUS — Indicates whether the summarized attribute is displayed.
• SUMMARY_PROMPT — The translated label/prompt shown for the summary, sourced from the TL table and the reason this is a _VL view.
• Audit columns — LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE.

Common Use Cases and Queries

Typical usage includes troubleshooting report summary behavior, verifying prompt translations, and auditing how an attribute is aggregated across levels. A session-language filtered query follows:

• SELECT report_id, attribute_set, column_name, summary_function, summary_prompt FROM fa_rx_summary_vl WHERE report_id = :p_report_id;
• SELECT column_name, compute_level, reset_level, print_level FROM fa_rx_summary_vl WHERE attribute_set = :p_attribute_set;
• SELECT DISTINCT summary_function FROM fa_rx_summary_vl;

Because the view applies USERENV('LANG') automatically, ensure the session language is set correctly to retrieve the intended translation. For multi-language extraction, query FA_RX_SUMMARY_TL directly. The view is read-only and should not be used for DML.