Search Results rg_dss_system_variables_pk

Overview

RG_DSS_SYSTEM_VARIABLES is a table in the RG (Application Report Generator) product schema of Oracle E-Business Suite, present and valid in both release 12.1.1 and 12.2.2. Functionally, the object stores the assignments of financial data items to financial data sets — that is, it maps individual report generator variables into the systems (data sets) that consume them. This makes it a configuration table rather than a transaction table: it holds the defined relationships that the Application Report Generator uses when resolving which variables belong to which reporting system at runtime.

From a modeling perspective, the mined metadata classifies this object heuristically as a link table. This is a suggested interpretation: the table's structure, with two foreign keys and a composite unique index on the pair of referenced keys, is characteristic of an associative entity that resolves a many-to-many relationship between RG_DSS_SYSTEMS and RG_DSS_VARIABLES.

Key Information Stored

The documented physical schema exposes 24 columns. The most important are:

• SYSTEM_VARIABLE_ID — the surrogate primary key, enforced by RG_DSS_SYSTEM_VARIABLES_PK and also covered by unique index U1.
• SYSTEM_ID — foreign key to RG_DSS_SYSTEMS, identifying the financial data set to which a variable is assigned.
• VARIABLE_ID — foreign key to RG_DSS_VARIABLES, identifying the financial data item being assigned.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard EBS auditing columns recording who last changed the assignment and when.
• CREATION_DATE, CREATED_BY — creation audit attributes for the assignment record.
• CONTEXT and ATTRIBUTE1 through ATTRIBUTE15 — the standard EBS extensibility (flexfield) columns, available for descriptive or qualifying information.

The business key is represented by unique index RG_DSS_SYSTEM_VARIABLES_U2 on (SYSTEM_ID, VARIABLE_ID), confirming that a given variable may be assigned to a given system only once. The surrogate SYSTEM_VARIABLE_ID (U1) is the technical primary key and should not be treated as business-meaningful.

Common Use Cases and Queries

Typical uses include auditing which variables are attached to each financial data set, comparing assignments across environments, and driving reports that enumerate a system's variable membership. Representative query patterns:

• List all variables for a given system: SELECT VARIABLE_ID FROM RG_DSS_SYSTEM_VARIABLES WHERE SYSTEM_ID = :system_id;
• Find systems using a specific variable: SELECT SYSTEM_ID FROM RG_DSS_SYSTEM_VARIABLES WHERE VARIABLE_ID = :variable_id;
• Join to both parents to render readable names for reporting, linking on SYSTEM_ID and VARIABLE_ID.
• Audit recently modified assignments using LAST_UPDATE_DATE and LAST_UPDATED_BY.

Related Objects

The FK metadata identifies the two principal parents that this link resolves:

• RG_DSS_SYSTEMS — joined on RG_DSS_SYSTEM_VARIABLES.SYSTEM_ID = RG_DSS_SYSTEMS.SYSTEM_ID; the financial data set side of the relationship.
• RG_DSS_VARIABLES — joined on RG_DSS_SYSTEM_VARIABLES.VARIABLE_ID = RG_DSS_VARIABLES.VARIABLE_ID; the financial data item side.

Together these three objects form the core RG reporting configuration model. Reporting and extraction routines should traverse the link table to obtain the complete system-to-variable mapping, since neither parent alone stores the association.