Search Results fa_rx_rep_parameters




Overview
Explore in AI Chat

Overview

The FA_RX_REP_PARAMETERS table is a core data object within the Oracle E-Business Suite (EBS) Fixed Assets (OFA) module. It functions as the repository for parameter definitions used by the Report eXchange (RX) framework. This framework facilitates the generation and distribution of asset-related reports. The table's primary role is to store the metadata that defines the configurable parameters available to users when running specific reports, enabling dynamic filtering and customization of report output. Its existence is integral to the flexible reporting architecture in both EBS 12.1.1 and 12.2.2.

Key Information Stored

The table stores the definitional attributes for each report parameter. As per the provided metadata, the table's structure is anchored by a composite primary key consisting of REPORT_ID and NAME. The REPORT_ID column links the parameter to its parent report definition in the FA_RX_REPORTS table. The NAME column stores the unique identifier for the parameter within that specific report. While the full column list is not detailed in the excerpt, typical columns in such a parameter definition table would include data types (e.g., VARCHAR2, DATE, NUMBER), display prompts, default values, validation rules (such as LOV definitions), and sequence numbers to control the order of parameter prompts presented to the user.

Common Use Cases and Queries

The primary use case is the administrative setup and runtime execution of Fixed Assets reports. During report submission, the application queries this table to determine which parameters to prompt the user for. Common queries involve listing all parameters for a given report or identifying reports that use a specific type of parameter. For instance, a developer might use a query to understand the parameter interface for a custom report or to troubleshoot a missing parameter prompt. A sample SQL pattern to retrieve parameter details for a specific report would be:

  • SELECT name, prompt, data_type, default_value FROM fa_rx_rep_parameters WHERE report_id = (SELECT report_id FROM fa_rx_reports WHERE report_name = 'REPORT_X') ORDER BY sequence_num;

This data is crucial for generating accurate audit trails of report execution, as the parameter values supplied by the user are typically logged alongside the report request.

Related Objects

FA_RX_REP_PARAMETERS has a direct and documented foreign key relationship with the FA_RX_REPORTS table, which is the master table for Report eXchange report definitions. The relationship is defined as follows:

  • Foreign Key From: FA_RX_REP_PARAMETERS.REPORT_ID
  • References (Foreign Table): FA_RX_REPORTS
  • Join Column: FA_RX_REP_PARAMETERS.REPORT_ID = FA_RX_REPORTS.REPORT_ID

This relationship enforces referential integrity, ensuring that every parameter definition is associated with a valid parent report. The table is also inherently related to runtime tables that store user-submitted parameter values for report requests, though those specific table names are not listed in the provided metadata.