Search Results rg_report_parameters




Overview
Explore in AI Chat

Overview

The RG_REPORT_PARAMETERS table is a core data object within the Oracle E-Business Suite Application Report Generator (RG) module. It serves as a central repository for storing the specific financial parameters assigned to reports generated by the system. Its primary role is to define the precise budgetary, encumbrance, and currency contexts under which a financial report is executed. By linking a report definition to specific budget versions, encumbrance types, and currency codes, this table ensures that report data is consistently filtered and presented according to the correct financial framework, which is critical for accurate management and statutory reporting.

Key Information Stored

The table's structure is designed to associate a set of parameters with a specific report instance. The primary key is a composite of PARAMETER_SET_ID, DATA_TYPE, and PARAMETER_NUM, which allows for multiple parameters of different types to be grouped. The most critical columns are PARAMETER_ID and UNIT_OF_MEASURE_ID_11I, which act as foreign keys to other master data tables. The PARAMETER_ID column typically stores identifiers that link to specific budget versions (in GL_BUDGET_VERSIONS) or encumbrance types (in GL_ENCUMBRANCE_TYPES). For currency assignments, the ENTERED_CURRENCY and LEDGER_CURRENCY columns hold currency codes referencing FND_CURRENCIES, defining the transaction and ledger currencies for the report, respectively. The UNIT_OF_MEASURE_ID_11I column is a legacy currency reference also pointing to FND_CURRENCIES.

Common Use Cases and Queries

A primary use case is auditing or troubleshooting the financial configuration of a specific report. An administrator may need to identify which budget version is being used. A common query involves joining to the relevant master tables:

  • To list all parameter sets with their associated budget: SELECT rp.parameter_set_id, bv.budget_name FROM rg_report_parameters rp, gl_budget_versions bv WHERE rp.parameter_id = bv.budget_version_id AND rp.data_type = 'BUDGET';
  • To find the currency configuration for a report set: SELECT parameter_set_id, entered_currency, ledger_currency FROM rg_report_parameters WHERE entered_currency IS NOT NULL;

Another key scenario is during report migration or cloning, where scripts may reference this table to duplicate parameter assignments from one report definition to another.

Related Objects

RG_REPORT_PARAMETERS has integral relationships with several key EBS master tables, as defined by its foreign key constraints. For budget data, it references GL_BUDGET_VERSIONS. For encumbrance data, it references GL_ENCUMBRANCE_TYPES. All currency information is linked to the FND_CURRENCIES table via three separate foreign keys (UNIT_OF_MEASURE_ID_11I, ENTERED_CURRENCY, and LEDGER_CURRENCY). The table is primarily governed by the RG_REPORT_PARAMETERS_PK primary key constraint. As a configuration table for the Report Generator, it is closely tied to the core report definition objects within the RG schema, though those specific table names are not detailed in the provided metadata.