Results for “fa_rx_summary_tl”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

FA_RX_SUMMARY_TL is a translation (MLS) table in the Oracle Assets (OFA) module of Oracle E-Business Suite, validated in releases 12.1.1 and 12.2.2. It stores the language-specific summary definitions associated with Report eXchange report attributes. Report eXchange (RX) is the framework within Oracle Assets that drives the configuration, column selection, and summarization behaviour of the standard asset reports and listings, such as the Asset Additions, Asset Retirements, and Cost Summary reports. This table holds the translated prompt and summary descriptive text for each summarization rule applied to a report column, and it functions as the language-dependent companion to the base table FA_RX_SUMMARY_B.

From a data modelling perspective, the mined foreign key structure classifies this object as satellite-leaning. FA_RX_SUMMARY_TL does not define an independent business entity; it extends the parent report-column definition with descriptive and language-specific attributes. This classification is offered as a heuristic modelling suggestion rather than a documented Oracle designation.

Key Information Stored

The documented physical schema for 12.2.2 contains 17 columns. The most significant are summarized below.

• REPORT_ID — Identifier of the Report eXchange report definition to which the summary belongs; a component of both the primary key and the foreign key to FA_RX_REP_COLUMNS_B.
• ATTRIBUTE_SET — The attribute set identifier that scopes the report attribute; part of the composite business key.
• COLUMN_NAME — The report column for which the summary rule is defined; part of the composite key and the FK relationship.
• SUMMARY_FUNCTION — The aggregate or summary operation applied to the column (for example, sum, count, or average) when the report is summarized.
• PRINT_LEVEL, RESET_LEVEL, COMPUTE_LEVEL — Control the grouping hierarchy at which the summary is printed, reset, and computed.
• SUMMARY_PROMPT — The translated prompt text presented to the user for the summary attribute; this is the core MLS payload of the table.
• DISPLAY_STATUS — Indicates whether the summary definition is displayed in report output.
• LANGUAGE and SOURCE_LANG — Identify the language of the row and the source language from which it was derived, supporting multilingual installations.
• ZD_EDITION_NAME — Editioning column introduced for Online Patching (ADOP) in 12.2.x.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns.

The primary key, FA_RX_SUMMARY_TL_PK, is a composite surrogate over REPORT_ID, ATTRIBUTE_SET, COLUMN_NAME, SUMMARY_FUNCTION, LANGUAGE, PRINT_LEVEL, RESET_LEVEL, and COMPUTE_LEVEL. The unique index FA_RX_SUMMARY_TL_U1 adds ZD_EDITION_NAME to that list, making it the documented business-key candidate in an editioned environment.

Common Use Cases and Queries

Typical usage involves resolving the translated summary prompts for a given report and column, or auditing which aggregations are configured across attribute sets. A representative query joining the translation table to its base table follows:

• SELECT s.report_id, s.column_name, s.summary_function, s.summary_prompt, s.language FROM fa.fa_rx_summary_tl s WHERE s.language = USERENV('LANG') AND s.report_id = :report_id;
• Reporting on summarization behaviour: aggregate counts of SUMMARY_FUNCTION by REPORT_ID and PRINT_LEVEL to document which reports roll up at which levels.
• Multilingual verification: compare rows in fa_rx_summary_tl against fa_rx_summary_b to detect missing translations or stale prompts after an upgrade.
• Diagnostics: when a report displays an untranslated or blank summary prompt, query the TL row for the active LANGUAGE and confirm SUMMARY_PROMPT is populated.

Related Objects

• FA_RX_SUMMARY_B — The base (non-translated) summary definition table; the TL row is the language-specific counterpart keyed by the same composite columns.
• FA_RX_REP_COLUMNS_B — Referenced by the foreign key on REPORT_ID, COLUMN_NAME, and ATTRIBUTE_SET; defines the report columns that summaries operate against.
• FA_RX_REP_COLUMNS_TL — The translated column definitions that pair with the summary prompts.
• FA_RX_REPORTS_B and FA_RX_REPORTS_TL — The parent report definitions and their translations.
• FA_RX_ATTRIBUTE_SETS_B — Defines the attribute sets referenced by ATTRIBUTE_SET.