Search Results fa_rx_reports




Overview
Explore in AI Chat

Overview

The FA_RX_REPORTS table is a core repository within the Oracle E-Business Suite (EBS) Fixed Assets module (OFA). It serves as the master definition table for the Report eXchange (RX) framework, a critical component for generating and managing asset-related reports. This table stores the metadata and configuration for every report definition registered within the system, acting as the central control point that links report logic, parameters, and output formats to the EBS concurrent processing engine. Its existence is fundamental to the operational reporting capabilities of the Fixed Assets application in both the 12.1.1 and 12.2.2 versions.

Key Information Stored

The table's primary purpose is to define report entities. Its key columns, as indicated by its primary and foreign key relationships, include the REPORT_ID, which uniquely identifies each report definition. The APPLICATION_ID and CONCURRENT_PROGRAM_ID columns are crucial, as they link the report definition to a specific executable program registered in the FND_CONCURRENT_PROGRAMS table, thereby integrating it with the standard EBS concurrent manager. While the provided metadata does not list all columns, the table's description and foreign keys imply it also stores other defining attributes for a report, such as its internal name, display label, and potentially status and versioning information to manage the report lifecycle within the Report eXchange architecture.

Common Use Cases and Queries

This table is primarily accessed for administrative and diagnostic purposes within the Fixed Assets module. Common scenarios include auditing the list of available Report eXchange reports, troubleshooting report submission failures by verifying backend definitions, and developing custom integrations that require programmatic access to report metadata. A typical query would join FA_RX_REPORTS with FND_CONCURRENT_PROGRAMS to retrieve a list of all active asset reports and their corresponding executable names.

SELECT frr.report_id,
       fcp.concurrent_program_name,
       fcp.user_concurrent_program_name
  FROM fa.fa_rx_reports frr,
       applsys.fnd_concurrent_programs fcp
 WHERE frr.application_id = fcp.application_id
   AND frr.concurrent_program_id = fcp.concurrent_program_id;

Another common use case involves investigating the parameters or attribute sets associated with a specific report by joining to the related FA_RX_REP_PARAMETERS or FA_RX_ATTRSETS_B tables using the REPORT_ID.

Related Objects

The FA_RX_REPORTS table sits at the center of the Report eXchange data model, with documented foreign key relationships to several key objects:

  • FND_APPLICATION & FND_CONCURRENT_PROGRAMS: These foundational EBS tables provide the application and executable program context. FA_RX_REPORTS.APPLICATION_ID and CONCURRENT_PROGRAM_ID link to these tables to register the report with the concurrent manager.
  • FA_RX_ATTRSETS_B: This table stores attribute sets (groupings of report parameters or output columns). It references FA_RX_REPORTS.REPORT_ID, indicating that multiple attribute sets can be defined for a single report.
  • FA_RX_REP_PARAMETERS: This table stores the individual parameters for each report definition. It references FA_RX_REPORTS.REPORT_ID, establishing a one-to-many relationship where a report can have multiple parameters.