Search Results fa_rx_attrsets_vl




Overview
Explore in AI Chat

Overview

FA_RX_ATTRSETS_VL is a translated (MLS) view owned by the APPS schema in Oracle E-Business Suite, belonging to the OFA (Oracle Assets) product family. It exposes attribute set definitions used by RX reports — the configurable, attribute-driven reporting framework used within Oracle Assets. Attribute sets control presentation and formatting behavior for generated reports, including page dimensions, header and footer printing, group display behavior, and locale-sensitive formatting such as date, date-time, and numeric character conventions.

The view is a "_VL" view, meaning it joins a "_B" (base) table with a "_TL" (translation) table and filters on the session language via USERENV('LANG'). This pattern is standard throughout Oracle EBS for exposing translated descriptive columns alongside installation-level base data. The view is documented as VALID in ETRM 12.2.2 and is compatible with the 12.1.1 and 12.2.2 releases. Because attribute sets govern how RX reports render output, this view plays a supporting role in reporting configuration and in any integration that needs to read report formatting metadata.

Underlying Base Objects

The view is defined over two objects, both exposed in APPS as synonyms: FA_RX_ATTRSETS_B (the base table holding language-independent attribute set attributes) and FA_RX_ATTRSETS_TL (the translation table holding language-dependent descriptive text). The join condition links the two on REPORT_ID and ATTRIBUTE_SET, and the translation row is restricted to T.LANGUAGE = USERENV('LANG'), so each query returns exactly one row per attribute set per report in the caller's language.

From FA_RX_ATTRSETS_B the view selects all functional columns plus the standard EBS WHO columns (LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN) and the pseudo-column ROWID aliased as ROW_ID. From FA_RX_ATTRSETS_TL it selects REPORT_TITLE and USER_ATTRIBUTE_SET. No aggregation or filtering beyond the language restriction is applied.

Key Columns

Common Use Cases and Queries

Typical usage includes reviewing the formatting defaults configured for RX reports, auditing date and numeric masks across attribute sets, and confirming which sets are seeded versus user-defined. Because the view resolves the language automatically, it is the preferred source over querying the "_B" and "_TL" tables directly.

To retrieve all attribute sets for a specific report:

  • SELECT report_id, attribute_set, report_title, default_date_format, default_date_time_format FROM fa_rx_attributes_vl WHERE report_id = :report_id;

To locate sets using a particular date mask:

  • SELECT report_id, attribute_set, default_date_format, default_date_time_format FROM fa_rx_attr_sets_vl WHERE default_date_format = :date_format;

To list seeded system attribute sets for a report:

  • SELECT attribute_set, report_title, default_numeric_characters FROM fa_rx_attr_sets_vl WHERE report_id = :report_id AND system_flag = 'Y';

In all cases, the view returns the translation matching USERENV('LANG'), so results reflect the language of the querying session.