Search Results fa_rx_attrsets_tl




Overview
Explore in AI Chat

Overview

The FA_RX_ATTRSETS_TL table is a core data object within the Oracle E-Business Suite (EBS) Fixed Assets (OFA) module, specifically for versions 12.1.1 and 12.2.2. It functions as a translated, multi-language support (MLS) table that stores user-facing descriptive text for Attribute Sets used in RX reports. RX reports are the standard financial and regulatory reports within the Assets module. The table's primary role is to enable the internationalization of report configuration by holding language-specific names and descriptions for predefined groupings of asset attributes (Attribute Sets) that can be selected when generating reports. It works in conjunction with its base table, FA_RX_ATTRSETS_B, which holds the non-translated, seed data.

Key Information Stored

The table stores the translated textual information for each Attribute Set. Its structure is defined by a composite primary key and language-specific content columns. The critical columns include the primary key components: REPORT_ID, which links to the specific RX report; ATTRIBUTE_SET, which identifies the attribute grouping; and LANGUAGE, which holds the language code (e.g., 'US', 'F') for the translation. The core content columns are ATTRIBUTE_SET_NAME and DESCRIPTION, which hold the translated name and descriptive text for the attribute set in the specified language. Standard MLS columns like CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN are also present for auditing.

Common Use Cases and Queries

This table is primarily accessed by the EBS application to display localized Attribute Set options in the report parameter windows. Common technical use cases involve querying the available translations for reporting or data validation purposes. A typical query would join the table to its base table to retrieve all translations for a specific report or attribute set.

  • Retrieve all translations for a specific Attribute Set:
    SELECT tl.language, tl.attribute_set_name, tl.description
    FROM fa_rx_attrsets_tl tl, fa_rx_attrsets_b b
    WHERE tl.report_id = b.report_id
    AND tl.attribute_set = b.attribute_set
    AND b.attribute_set = '<SET_NAME>';
  • Find the user-visible name for an Attribute Set in a session's language:
    SELECT attribute_set_name
    FROM fa_rx_attrsets_tl
    WHERE report_id = <report_id>
    AND attribute_set = '<attribute_set>'
    AND language = userenv('LANG');

Related Objects

FA_RX_ATTRSETS_TL has a direct and essential relationship with its base table, as documented in the provided metadata. The table does not have independent foreign keys referencing other objects; instead, it is a child table that extends the functionality of its parent.

  • FA_RX_ATTRSETS_B (Base Table): This is the primary related object. FA_RX_ATTRSETS_TL references FA_RX_ATTRSETS_B via a foreign key on the composite columns (REPORT_ID, ATTRIBUTE_SET). The base table holds the seed data, while the TL table provides the translations. Any query for a complete definition must join these two tables on these key columns.
  • Table: FA_RX_ATTRSETS_TL 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_RX_ATTRSETS_TL,  object_name:FA_RX_ATTRSETS_TL,  status:VALID,  product: OFA - Assets ,  description: Stores Attribute Set information for RX reports (translated MLS table) ,  implementation_dba_data: FA.FA_RX_ATTRSETS_TL , 

  • Table: FA_RX_ATTRSETS_TL 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_RX_ATTRSETS_TL,  object_name:FA_RX_ATTRSETS_TL,  status:VALID,  product: OFA - Assets ,  description: Stores Attribute Set information for RX reports (translated MLS table) ,  implementation_dba_data: FA.FA_RX_ATTRSETS_TL , 

  • Table: FA_RX_ATTRSETS_B 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_RX_ATTRSETS_B,  object_name:FA_RX_ATTRSETS_B,  status:VALID,  product: OFA - Assets ,  description: Stores attribute set information for RX reports (base MLS table) ,  implementation_dba_data: FA.FA_RX_ATTRSETS_B , 

  • Table: FA_RX_ATTRSETS_B 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_RX_ATTRSETS_B,  object_name:FA_RX_ATTRSETS_B,  status:VALID,  product: OFA - Assets ,  description: Stores attribute set information for RX reports (base MLS table) ,  implementation_dba_data: FA.FA_RX_ATTRSETS_B , 

  • View: FA_RX_ATTRSETS_VL 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:OFA.FA_RX_ATTRSETS_VL,  object_name:FA_RX_ATTRSETS_VL,  status:VALID,  product: OFA - Assets ,  description: Stores attribute set information for RX reports (translated MLS view) ,  implementation_dba_data: APPS.FA_RX_ATTRSETS_VL , 

  • View: FA_RX_ATTRSETS_VL 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:OFA.FA_RX_ATTRSETS_VL,  object_name:FA_RX_ATTRSETS_VL,  status:VALID,  product: OFA - Assets ,  description: Stores attribute set information for RX reports (translated MLS view) ,  implementation_dba_data: APPS.FA_RX_ATTRSETS_VL ,