Search Results rg_dss_system_variables_uk1

Overview

The RG_DSS_SYSTEM_VARIABLES table is a core data structure within the Application Report Generator (RG) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It functions as a junction or assignment table, establishing and managing the critical relationships between financial data items and the financial data sets to which they belong. This table is fundamental to the Report Generator's architecture, which is used for creating and running complex financial reports. By defining which variables (financial data items) are available within a specific system (financial data set), it enables the structured definition and accurate population of financial statements and regulatory reports.

Key Information Stored

The table's primary purpose is to store assignment records, with its key columns being foreign keys that link to master definitions. The SYSTEM_VARIABLE_ID column serves as the unique primary key for each assignment record. The SYSTEM_ID column references a specific financial data set defined in the RG_DSS_SYSTEMS table. The VARIABLE_ID column references a specific financial data item or variable defined in the RG_DSS_VARIABLES table. Together, the SYSTEM_ID and VARIABLE_ID form a unique constraint (RG_DSS_SYSTEM_VARIABLES_UK1), ensuring a variable cannot be assigned to the same data set more than once.

Common Use Cases and Queries

This table is primarily accessed during the setup and execution of financial reports. A common administrative task is to query all variables assigned to a particular reporting data set to verify configuration. For example: SELECT v.variable_name FROM rg_dss_variables v, rg_dss_system_variables sv WHERE sv.system_id = :p_system_id AND sv.variable_id = v.variable_id ORDER BY v.variable_name;. Conversely, to identify all data sets where a specific financial item is used, one would query: SELECT s.system_name FROM rg_dss_systems s, rg_dss_system_variables sv WHERE sv.variable_id = :p_variable_id AND sv.system_id = s.system_id;. During report runtime, the engine uses these assignments to determine the pool of valid variables for data fetching and calculation within the context of the selected data set.

Related Objects

RG_DSS_SYSTEM_VARIABLES sits at the intersection of two key master tables, as defined by its documented foreign key relationships:

• RG_DSS_SYSTEMS: The table is linked via the SYSTEM_ID column. This references the master list of defined financial data sets or systems.
• RG_DSS_VARIABLES: The table is linked via the VARIABLE_ID column. This references the master list of defined financial data items, such as account balances, statistical amounts, or calculated line items.

These relationships enforce referential integrity, ensuring that assignments are only made to valid, existing systems and variables. The table's primary key, RG_DSS_SYSTEM_VARIABLES_PK, is based on the SYSTEM_VARIABLE_ID column.