Search Results rg_dss_system_variables_u2

Overview

RG.RG_DSS_SYSTEM_VARIABLES is a transaction-level table in the Oracle E-Business Suite Release 12.1.1 / 12.2.2 schema owned by the RG (Oracle Regulatory/Financial Data Set) application. It functions as an intersection or assignment entity that links financial data systems to the variables (financial data items) they consume. Each row records the assignment of one variable to one system, forming the operational bridge between the RG_DSS_SYSTEMS and RG_DSS_VARIABLES master entities. This table is designated "Oracle Internal Use Only" and is not supported for direct customer access except through standard Oracle Applications programs.

Under the heuristic Data Vault classification derived from its foreign key structure, this object is best modeled as a link table. It carries two foreign keys to parent hubs (SYSTEM_ID referencing RG_DSS_SYSTEMS and VARIABLE_ID referencing RG_DSS_VARIABLES) plus a surrogate primary key and a full set of Standard Who and Descriptive Flexfield columns. This is the classic link pattern: a many-to-many resolution entity between two reference dimensions, with no descriptive grain of its own beyond the assignment itself.

Key Information Stored

The physical schema defines 24 columns. The most significant are:

• SYSTEM_VARIABLE_ID (NUMBER, 15) — Surrogate primary key, uniquely enforced by index RG_DSS_SYSTEM_VARIABLES_U1. Commented as the "Assignment defining column."
• SYSTEM_ID (NUMBER, 15, mandatory) — Foreign key to RG_DSS_SYSTEMS; the "Financial data set defining column."
• VARIABLE_ID (NUMBER, 15, mandatory) — Foreign key to RG_DSS_VARIABLES; the "Financial data item defining column."
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY — Standard Who audit columns capturing row lifecycle and user accountability.
• CONTEXT (VARCHAR2, 30) — Descriptive Flexfield context discriminator.
• ATTRIBUTE1 through ATTRIBUTE15 (VARCHAR2, 150 each) — Descriptive Flexfield segments available for customer-defined extension of the assignment record.

The composite unique index RG_DSS_SYSTEM_VARIABLES_U2 on (SYSTEM_ID, VARIABLE_ID) is the true business-key candidate. It guarantees that any given variable is assigned at most once to any given system, preventing duplicate membership rows. The user searching for "rg_dss_system_variables_u2" is therefore looking for the index that enforces this business rule, not the table itself.

Common Use Cases and Queries

Typical reporting resolves which variables belong to a given system, and conversely which systems use a given variable. A common pattern joins the table to both parents:

• Variables per system: SELECT v.VARIABLE_ID, v.VARIABLE_NAME FROM RG_DSS_SYSTEM_VARIABLES sv, RG_DSS_VARIABLES v WHERE sv.VARIABLE_ID = v.VARIABLE_ID AND sv.SYSTEM_ID = :system_id.
• Systems per variable: invert the same join, filtering on sv.VARIABLE_ID.
• Orphan / assignment auditing: LEFT JOIN either parent to detect dangling references or variables never assigned.
• Index verification: query ALL_INDEXES and ALL_IND_COLUMNS for RG_DSS_SYSTEM_VARIABLES_U2 to confirm the (SYSTEM_ID, VARIABLE_ID) uniqueness constraint is present and valid in a given instance.
• Flexfield reporting: filter or group by CONTEXT and the applicable ATTRIBUTEn segments where the DFF has been configured.

Because the object is internal-use only, these queries should be treated as read-only diagnostics rather than as integration points.

Related Objects

The most significant related objects are the two foreign-key parents and the standard EBS metadata views used to introspect the table:

• RG.RG_DSS_SYSTEMS — parent of SYSTEM_ID; supplies the financial data set definition.
• RG.RG_DSS_VARIABLES — parent of VARIABLE_ID; supplies the financial data item definition.
• RG_DSS_SYSTEM_VARIABLES_PK — primary key constraint on SYSTEM_VARIABLE_ID.
• RG_DSS_SYSTEM_VARIABLES_U1 — unique index on SYSTEM_VARIABLE_ID.
• RG_DSS_SYSTEM_VARIABLES_U2 — unique index on (SYSTEM_ID, VARIABLE_ID), the business key.
• FND_DESCR_FLEX_COL_USAGE / FND_DESCR_FLEX_CONTEXTS — define the Descriptive Flexfield applied through CONTEXT and ATTRIBUTE1–15.
• DBA_TABLES / DBA_INDEXES / ALL_IND_COLUMNS — data dictionary views for validating structure and index status.