Search Results fa_rx_security




Overview
Explore in AI Chat

Overview

The FA_RX_SECURITY 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 serves as the security and authorization repository for the Report eXchange (RX) framework. This framework manages attribute sets, which are reusable collections of parameters and filters for asset reports. The table's primary role is to define and enforce which EBS responsibilities have access to specific attribute sets for a given report, thereby controlling data visibility and report customization capabilities based on a user's assigned responsibility.

Key Information Stored

The table stores a composite key that uniquely identifies a security assignment. The critical columns are REPORT_ID, which identifies the specific Fixed Assets report; ATTRIBUTE_SET, which names the predefined set of report parameters; and RESPONSIBILITY_ID, which is the identifier for the EBS responsibility granted access. Together, these columns form the primary key (FA_RX_SECURITY_PK), ensuring that a given responsibility can only have one defined access rule per report and attribute set combination. The table does not store the attribute set definitions themselves but acts as a junction controlling access to them.

Common Use Cases and Queries

The primary use case is administering secure, responsibility-based access to customized report configurations. A system administrator might query current assignments or insert new ones when deploying a new responsibility. Common reporting queries involve joining with responsibility and report metadata tables to produce user-friendly access lists. For example, to audit all security assignments, one might use:

  • SELECT frs.report_id, frs.attribute_set, frs.responsibility_id, fvt.user_report_name FROM fa_rx_security frs, fa_rx_reports_vl fvt WHERE frs.report_id = fvt.report_id;

To troubleshoot a user's inability to see a specific attribute set, a support query would filter on the user's specific RESPONSIBILITY_ID and the relevant REPORT_ID.

Related Objects

FA_RX_SECURITY has a direct foreign key relationship with the FA_RX_ATTRSETS_B table, which is the base table storing the definition of the attribute sets. The relationship is enforced on the composite key of (REPORT_ID, ATTRIBUTE_SET). This ensures that a security record in FA_RX_SECURITY cannot exist for a report and attribute set combination that is not defined in FA_RX_ATTRSETS_B. While not listed in the provided metadata, this table is also logically related to the FND_RESPONSIBILITY table (via RESPONSIBILITY_ID) and various FA_RX_REPORTS views (via REPORT_ID) to resolve descriptive names for reporting and application logic.

  • Table: FA_RX_SECURITY 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_RX_SECURITY,  object_name:FA_RX_SECURITY,  status:VALID,  product: OFA - Assets ,  description: Stores security assignments for Report eXchange Attribute sets ,  implementation_dba_data: FA.FA_RX_SECURITY , 

  • Table: FA_RX_SECURITY 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_RX_SECURITY,  object_name:FA_RX_SECURITY,  status:VALID,  product: OFA - Assets ,  description: Stores security assignments for Report eXchange Attribute sets ,  implementation_dba_data: FA.FA_RX_SECURITY , 

  • 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 ,