Search Results fa_rx_summary_tl




Overview
Explore in AI Chat

Overview

The FA_RX_SUMMARY_TL table is a core repository within Oracle E-Business Suite (EBS) Release 12.1.1 and 12.2.2, specifically for the Oracle Assets (OFA) module. It functions as the base table for the Multi-Language Support (MLS) architecture, storing translated summary definitions for Report eXchange (RX) report attributes. Report eXchange is a framework that facilitates the generation of financial reports from the Asset module. This table's primary role is to define how data for specific report columns should be aggregated—such as sum, average, count, minimum, or maximum—based on various grouping and reset levels. This enables the creation of complex, multi-level summary reports directly from the transactional asset data.

Key Information Stored

The table stores the logical rules for summarizing report data. Its key columns, as defined by its primary key (FA_RX_SUMMARY_TL_PK), are REPORT_ID, ATTRIBUTE_SET, COLUMN_NAME, SUMMARY_FUNCTION, and LANGUAGE. The REPORT_ID links to the specific Report eXchange report definition. The COLUMN_NAME and ATTRIBUTE_SET identify the exact data element to be summarized. The SUMMARY_FUNCTION column holds the aggregation operation (e.g., SUM, AVG). Critical control columns include PRINT_LEVEL, RESET_LEVEL, and COMPUTE_LEVEL, which dictate the hierarchical structure and grouping behavior of the summary calculations within the report. The LANGUAGE column supports the MLS functionality, allowing the storage of language-specific labels or definitions for these summary rules.

Common Use Cases and Queries

This table is central to generating summarized asset reports, such as depreciation summaries, net book value reports, or asset cost summaries by category or location. A common use case is troubleshooting or verifying the summary logic for a specific report column. A typical query would join this table to its base table (FA_RX_REP_COLUMNS_B) to retrieve the full context of the summarized column. For example, to list all summary definitions for a particular report in American English, one might use:

  • SELECT r.report_id, r.column_name, r.summary_function, r.print_level FROM fa_rx_summary_tl r WHERE r.report_id = :p_report_id AND r.language = 'US' ORDER BY r.print_level, r.column_name;

Developers and functional consultants reference this table when customizing or creating new Report eXchange reports to ensure summary calculations are defined correctly according to business requirements.

Related Objects

FA_RX_SUMMARY_TL has a direct and critical foreign key relationship with the FA_RX_REP_COLUMNS_B table, which stores the base definitions of report columns. The relationship is established on three key columns:

  • FA_RX_SUMMARY_TL.REPORT_ID references FA_RX_REP_COLUMNS_B.REPORT_ID
  • FA_RX_SUMMARY_TL.COLUMN_NAME references FA_RX_REP_COLUMNS_B.COLUMN_NAME
  • FA_RX_SUMMARY_TL.ATTRIBUTE_SET references FA_RX_REP_COLUMNS_B.ATTRIBUTE_SET

This ensures that every summary definition is anchored to a valid report column. The table is also related to other Report eXchange objects like FA_RX_REPORTS_B (report headers) and FA_RX_SET_ASSIGNMENTS_B, though these relationships are typically traversed through the FA_RX_REP_COLUMNS_B table. The "_TL" suffix indicates it is part of the standard EBS translation architecture, implying a corresponding base table (likely FA_RX_SUMMARY_B) exists, though it is not explicitly listed in the provided metadata.

  • Table: FA_RX_SUMMARY_TL 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_RX_SUMMARY_TL,  object_name:FA_RX_SUMMARY_TL,  status:VALID,  product: OFA - Assets ,  description: Stores summary definitions for Report eXchange report attributes (base MLS table) ,  implementation_dba_data: FA.FA_RX_SUMMARY_TL , 

  • Table: FA_RX_SUMMARY_TL 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_RX_SUMMARY_TL,  object_name:FA_RX_SUMMARY_TL,  status:VALID,  product: OFA - Assets ,  description: Stores summary definitions for Report eXchange report attributes (base MLS table) ,  implementation_dba_data: FA.FA_RX_SUMMARY_TL , 

  • Table: FA_RX_REP_COLUMNS_B 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_RX_REP_COLUMNS_B,  object_name:FA_RX_REP_COLUMNS_B,  status:VALID,  product: OFA - Assets ,  description: Stores attribute definitions for Report eXchange report attributes (base MLS table) ,  implementation_dba_data: FA.FA_RX_REP_COLUMNS_B , 

  • Table: FA_RX_REP_COLUMNS_B 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_RX_REP_COLUMNS_B,  object_name:FA_RX_REP_COLUMNS_B,  status:VALID,  product: OFA - Assets ,  description: Stores attribute definitions for Report eXchange report attributes (base MLS table) ,  implementation_dba_data: FA.FA_RX_REP_COLUMNS_B , 

  • View: FA_RX_SUMMARY_VL 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:OFA.FA_RX_SUMMARY_VL,  object_name:FA_RX_SUMMARY_VL,  status:VALID,  product: OFA - Assets ,  description: Stores summary definitions for Report eXchange report attributes (translated MLS view) ,  implementation_dba_data: APPS.FA_RX_SUMMARY_VL , 

  • View: FA_RX_SUMMARY_VL 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:OFA.FA_RX_SUMMARY_VL,  object_name:FA_RX_SUMMARY_VL,  status:VALID,  product: OFA - Assets ,  description: Stores summary definitions for Report eXchange report attributes (translated MLS view) ,  implementation_dba_data: APPS.FA_RX_SUMMARY_VL ,