Search Results fa_rx_summary

Overview

APPS.FA_RX_SUMMARY_VL is a reporting view in the Oracle E-Business Suite Fixed Assets (OFA) module. It exposes the summary line definitions used by the FA RX (reporting/extract) framework, which governs how asset reporting columns are configured, grouped, and totalled within the Oracle Assets reporting engine. The view is registered under the FND Design Data identifier OFA.FA_RX_SUMMARY_VL and is documented with a VALID status in both Oracle EBS 12.1.1 and 12.2.2. Its owner is the APPS schema, and it is a translation ("_VL" pattern) style view layered over a translation base object, meaning it presents the user-facing language-specific content for a defined language context.

In practice, this view does not store transactional asset data. It is a metadata/configuration view that returns the column-level summary attributes associated with a given RX report, enabling administrators and integrators to query how reporting summary levels and functions are defined without accessing the underlying translation table directly.

Underlying Base Objects

The documented base object referenced by APPS.FA_RX_SUMMARY_VL is FA_RX_SUMMARY_TL, which is exposed to the APPS schema as a synonym. The "_VL" suffix indicates that FA_RX_SUMMARY_VL is a language view, resolving the base translation table (FA_RX_SUMMARY_TL) with an implicit language predicate against the session's language environment. The "_TL" table holds language-specific text, notably the SUMMARY_PROMPT value, while language-independent attributes such as levels and functions are typically carried from the corresponding base table (FA_RX_SUMMARY_B in the standard OFA design).

• FA_RX_SUMMARY_TL — the translation table holding language-specific summary prompt text; referenced through the APPS synonym.
• FA_RX_SUMMARY_VL — the language view exposed to clients and concurrent programs, resolving the appropriate language row set.
• Report-definition linkage is maintained through REPORT_ID and ATTRIBUTE_SET, tying each summary row to a specific RX report and attribute set.

Key Columns

• ROW_ID (ROWID) — the physical row identifier for the row returned by the view.
• REPORT_ID (NUMBER) — identifies the RX report to which the summary definition belongs.
• ATTRIBUTE_SET (VARCHAR2, 30) — the attribute set grouping the columns for the report.
• COLUMN_NAME (VARCHAR2, 80) — the reporting column whose summary behaviour is being defined.
• PRINT_LEVEL (NUMBER) — the control-break level at which the column is printed.
• RESET_LEVEL (NUMBER) — the level at which accumulated values are reset.
• COMPUTE_LEVEL (NUMBER) — the level at which the summary computation is performed.
• SUMMARY_FUNCTION (VARCHAR2, 30) — the aggregation function applied (for example SUM, COUNT).
• DISPLAY_STATUS (VARCHAR2) — controls whether the summary is displayed.
• SUMMARY_PROMPT (VARCHAR2, 80) — the language-specific label presented for the summary; sourced from the translation table.
• Audit columns — LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, LAST_UPDATED_BY, CREATED_BY, and CREATION_DATE follow standard EBS WHO column conventions.

Common Use Cases and Queries

Typical uses include validating Fixed Assets RX report configurations during implementations, troubleshooting summary totals, and supporting reporting/integration extracts that need the summary metadata for a report. A basic query retrieves all summary definitions for a report:

SELECT report_id, attribute_set, column_name, print_level, reset_level, compute_level, summary_function, display_status, summary_prompt FROM apps.fa_rx_summary_vl WHERE report_id = :p_report_id;

Administrators can also filter to active summaries only, or join summary definitions with base RX report definitions to reconcile column sets. Because the view is language-aware, the SUMMARY_PROMPT values returned reflect the language of the current session, making it suitable for user-facing prompt generation. When resolving the underlying base data for maintenance purposes, the FA_RX_SUMMARY_TL translation table is referenced directly; for read-only reporting and integration, FA_RX_SUMMARY_VL is the recommended access path.