Search Results rg_dss_var_dimensions_u2

Overview

The table RG.RG_DSS_VAR_DIMENSIONS is an Oracle EBS application data object owned by the RG schema, classified as VALID, and registered in FND Design Data. It is a transactional data table (not a seed or interface table) whose purpose is to define the association between a decision-support variable and the organizational dimensions relevant to that variable. The name itself encodes the role of the object: it relates variables to dimensions within the RG (typically a regulatory, risk, or reporting) subsystem.

In Data Vault terms, the metadata's heuristic classification for this table is link. That is a modeling suggestion rather than a formal Oracle classification: the table's primary key is a composite of VARIABLE_ID plus SEQUENCE, and it carries two foreign keys — one to RG_DSS_VARIABLES and one to RG_DSS_DIMENSIONS — which is the classic link structure resolved between two hubs. The presence of standard WHO columns and a descriptive flexfield also means the object behaves as a satellite of attribute context on top of that relationship.

Key Information Stored

The most significant columns fall into three groups:

• Relationship key columns: VARIABLE_ID (Variable defining column, NUMBER(15), mandatory) and DIMENSION_ID (Dimension defining column, NUMBER(15), mandatory) — these are the two FK participants that tie the row to a variable and a dimension respectively.
• Ordering / surrogate key: SEQUENCE (NUMBER(15), mandatory) — the assignment sequence that, together with VARIABLE_ID, forms the primary key RG_DSS_VAR_DIMENSIONS_PK.
• Audit / WHO columns: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY — standard Oracle Applications audit trail.
• Descriptive flexfield columns: CONTEXT (VARCHAR2(30)) plus ATTRIBUTE1 through ATTRIBUTE15 (each VARCHAR2(150)) — extensible attribute segments for customer-specific configuration.

Two unique indexes are documented. RG_DSS_VAR_DIMENSIONS_U1 is unique on (VARIABLE_ID, SEQUENCE) and is effectively the primary-key surrogate. RG_DSS_VAR_DIMENSIONS_U2 is unique on (VARIABLE_ID, DIMENSION_ID) and acts as the business-key candidate: it enforces the rule that a given dimension may not be assigned twice to the same variable. The user's search term, rg_dss_var_dimensions_u2, refers precisely to this second unique index.

Storage is in tablespace APPS_TS_TX_DATA with PCTFREE 10; the unique indexes reside in APPS_TS_TX_IDX.

Common Use Cases and Queries

Because Oracle explicitly marks this object Oracle Internal Use Only and unsupported for direct access outside standard Applications programs, queries should be read-only and for reporting, reconciliation, or troubleshooting purposes only.

Typical patterns include retrieving all dimensions assigned to a variable in sequence order:

• SELECT variable_id, sequence, dimension_id FROM rg.rg_dss_var_dimensions WHERE variable_id = :p_variable_id ORDER BY sequence;
• Joining to the variable hub: ... FROM rg_dss_variables v, rg_dss_var_dimensions d WHERE v.variable_id = d.variable_id;
• Joining to the dimension hub: ... WHERE d.dimension_id = d2.dimension_id against RG_DSS_DIMENSIONS.
• Detecting duplicates or integrity issues by comparing the U2 business key against assigned rows: SELECT variable_id, dimension_id, COUNT(*) FROM rg.rg_dss_var_dimensions GROUP BY variable_id, dimension_id HAVING COUNT(*) > 1;
• Audit-style reporting filtering on last_update_date to identify records changed within a period.

Reporting use cases center on producing the variable-to-dimension mapping used by DSS calculations, validating that required dimensions are present for each variable, and confirming sequence ordering has not been corrupted.

Related Objects

The FK metadata identifies the two principal dependencies:

• RG.RG_DSS_VARIABLES — referenced through RG_DSS_VAR_DIMENSIONS.VARIABLE_ID → RG_DSS_VARIABLES; the parent hub of variables.
• RG.RG_DSS_DIMENSIONS — referenced through RG_DSS_VAR_DIMENSIONS.DIMENSION_ID → RG_DSS_DIMENSIONS; the parent hub of dimension definitions.
• RG_DSS_VAR_DIMENSIONS_U1 and RG_DSS_VAR_DIMENSIONS_U2 — the unique indexes that enforce the primary key and the variable/dimension business key.
• The standard WHO and Descriptive Flexfield framework (FND design data) that populates CONTEXT and ATTRIBUTE1–15.

Collectively these objects form the variable-to-dimension grain within the RG DSS model, with this table providing the link and its satellite attributes.