Search Results fa_rx_attrsets_b




Overview
Explore in AI Chat

Overview

The FA_RX_ATTRSETS_B table is a core data structure within the Oracle E-Business Suite (EBS) Fixed Assets (OFA) module, specifically for versions 12.1.1 and 12.2.2. It functions as the base table in a Multi-Language Support (MLS) architecture, storing the fundamental, non-translatable data for attribute sets used in the generation of RX reports. These reports are critical for asset accounting and regulatory compliance. The table's primary role is to define and manage the relationship between specific RX reports and the attribute sets that determine the data groupings and presentation logic within those reports, serving as a master definition table for report configuration.

Key Information Stored

The table's structure is defined by its primary key columns, which uniquely identify each attribute set configuration for a report. The REPORT_ID column is a foreign key that links the attribute set to its parent report definition in the FA_RX_REPORTS table. The ATTRIBUTE_SET column stores the identifier for the specific set of attributes (e.g., asset category, location, cost center) that will be used to organize data within the linked report. As a base MLS table, FA_RX_ATTRSETS_B holds the seed data, while user-facing translated names and descriptions are stored in its corresponding translation table, FA_RX_ATTRSETS_TL.

Common Use Cases and Queries

This table is primarily accessed during the setup and execution of asset reports. Common use cases include auditing the configuration of all attribute sets assigned to reports, troubleshooting missing report data due to incorrect attribute set assignments, and developing custom report extensions. A typical query would join this table to its translation table to retrieve a readable list of attribute sets for a specific report.

  • Sample Query: SELECT b.report_id, b.attribute_set, tl.meaning FROM fa_rx_attrsets_b b, fa_rx_attrsets_tl tl WHERE b.report_id = tl.report_id AND b.attribute_set = tl.attribute_set AND tl.language = USERENV('LANG');
  • Reporting Use Case: Identifying all reports configured to use a specific attribute set, such as 'COST_CENTER', for segregation of financial data.

Related Objects

FA_RX_ATTRSETS_B is central to the RX reporting subsystem, with documented foreign key relationships to several key tables.

  • FA_RX_REPORTS: The parent table. FA_RX_ATTRSETS_B.REPORT_ID references FA_RX_REPORTS to define the owning report.
  • FA_RX_ATTRSETS_TL: The translation table. It references both REPORT_ID and ATTRIBUTE_SET from FA_RX_ATTRSETS_B to provide language-specific names.
  • FA_RX_REP_COLUMNS_B: References the table to define which report columns are associated with a specific attribute set for a given report.
  • FA_RX_SECURITY: References the table to manage security rules and access controls tied to specific report and attribute set combinations.