Search Results reset_level




Overview
Explore in AI Chat

Overview

The FA_RX_SUMMARY_TL table is a core repository for translated metadata that defines summary calculations within Oracle E-Business Suite (EBS) Fixed Assets reports. It functions as a configuration table, storing language-specific definitions for summary columns that appear in asset register and other financial reports. Its primary role is to support the multi-language capabilities of the Fixed Assets reporting engine, ensuring that summary column prompts and functional definitions are presented in the user's session language. The table is integral to the report generation process, where the PRINT_LEVEL, RESET_LEVEL, and COMPUTE_LEVEL columns control the hierarchical formatting and calculation behavior of financial summaries.

Key Information Stored

The table stores metadata that maps physical database columns to report-level summary logic. Key columns include REPORT_ID, which identifies the specific report template; COLUMN_NAME, the physical column being summarized; and SUMMARY_FUNCTION, which defines the aggregation operation (e.g., SUM, COUNT). The LANGUAGE and SOURCE_LANG columns manage the translation layer, while SUMMARY_PROMPT holds the translated text for the summary line. The critical columns for controlling report output are PRINT_LEVEL (determines at which grouping level the summary prints), RESET_LEVEL (specifies the grouping level at which the summary calculation resets to zero), and COMPUTE_LEVEL (defines the grouping level at which the summary is calculated). These three columns work in concert to create subtotals, grand totals, and running totals within complex asset registers.

Common Use Cases and Queries

The primary use case is the generation of multi-language Fixed Assets reports, such as the Asset Register or Depreciation Projection reports, where financial data must be summarized by categories, cost centers, or asset books. A developer or analyst might query this table to understand or debug the summary logic of a specific report. For example, to examine all summary definitions for a particular report in a given language, one would use:

  • SELECT column_name, summary_prompt, print_level, reset_level, compute_level, summary_function FROM fa.fa_rx_summary_tl WHERE report_id = &report_id AND language = userenv('LANG');

Another common scenario involves analyzing the summary hierarchy. Rows where RESET_LEVEL is set to a value like 1 or 2 indicate where running totals restart, which is crucial for generating correct subtotals by major asset grouping.

Related Objects

Based on the provided dependency information, FA_RX_SUMMARY_TL is a standalone translation table. It is referenced by a synonym, APPS.FA_RX_SUMMARY_TL, which is the standard access point for all EBS application code. The table's unique index, FA_RX_SUMMARY_TL_U1, enforces integrity on the combination of REPORT_ID, ATTRIBUTE_SET, COLUMN_NAME, SUMMARY_FUNCTION, LANGUAGE, PRINT_LEVEL, RESET_LEVEL, and COMPUTE_LEVEL. While not listed in the provided excerpt, this table is typically a child of a base table (such as FA_RX_SUMMARY_B) that holds the non-translated, language-independent definition of the summary rules. The REPORT_ID column would logically join to a report definition table within the FA schema to link summary rules to a specific report template.