Search Results rg_dss_variables_pk

Overview

RG.RG_DSS_VARIABLES is a VALID base table in the Oracle E-Business Suite Release 12.1.1 and 12.2.2 database, owned by the RG schema and belonging to the Application Report Generator product family (RG). The table stores Financial Analyzer financial data items — that is, the definitions of the financial variables that drive Financial Analyzer and related General Ledger reporting structures. Each row represents a single named financial data item that can be referenced by reports, dimensions, selections, templates, and system variables within the RG reporting framework.

The documented physical schema comprises 66 columns. Three unique indexes are defined — RG_DSS_VARIABLES_U1 (VARIABLE_ID), RG_DSS_VARIABLES_U2 (NAME), and RG_DSS_VARIABLES_U3 (OBJECT_NAME) — alongside a primary key constraint, RG_DSS_VARIABLES_PK (VARIABLE_ID). From a Data Vault modeling perspective, the mined foreign-key structure classifies this table as satellite-leaning: it is a descriptive, attribute-heavy structure anchored on a single surrogate key, with subordinate tables hanging off VARIABLE_ID rather than participating in many-to-many link relationships. This classification is a heuristic suggestion rather than a formal EBS designation.

Key Information Stored

The surrogate primary key is VARIABLE_ID, which also serves as a business-key candidate via RG_DSS_VARIABLES_U1. Two further business-key candidates exist: NAME (unique index U2) and OBJECT_NAME (unique index U3). The remaining columns hold the descriptive and configuration attributes of the financial data item:

• LEDGER_ID — the set of books / ledger the variable is scoped to; foreign key to GL_SETS_OF_BOOKS_11I.
• CURRENCY_CODE — currency context for the item; foreign key to FND_CURRENCIES.
• BUDGET_VERSION_ID — associated budget version; foreign key to GL_BUDGET_VERSIONS.
• ENCUMBRANCE_TYPE_ID — encumbrance type applied to the item; foreign key to GL_ENCUMBRANCE_TYPES.
• BALANCE_TYPE and CURRENCY_TYPE — control how balances and currency amounts are resolved.
• LEVEL_CODE and STATUS_CODE — control flags governing the variable's scope and active state.
• COLUMN_LABEL — the display label used when the variable is rendered in reporting output.
• ID_FLEX_CODE and ID_FLEX_NUM — link the item to the key flexfield and structure it draws segments from.
• SEGMENT1_TYPE through SEGMENT30_TYPE — per-segment typing that governs how each accounting flexfield segment is interpreted for the variable.
• CONTEXT plus ATTRIBUTE1 through ATTRIBUTE15 — the standard EBS descriptive flexfield extension block.
• Standard audit columns: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

The table is primarily consumed to resolve variable definitions for Financial Analyzer content and to validate that report definitions point at valid, active financial data items. Typical queries join the variable to its ledger, currency, budget version, and encumbrance context to reproduce the filters a Financial Analyzer run would apply.

• Retrieve all active variables with their ledger and currency context:
  SELECT v.variable_id, v.name, v.object_name, v.column_label, b.name ledger_name, v.currency_code FROM rg_dss_variables v, gl_sets_of_books_11i b WHERE v.ledger_id = b.set_of_books_id AND v.status_code = 'A';
• Look up a variable by its unique name or object name (both are enforced by unique indexes): SELECT * FROM rg_dss_variables WHERE name = :name;
• Inspect segment typing configuration for a given variable: SELECT variable_id, segment1_type, segment2_type, ... segment30_type FROM rg_dss_variables WHERE variable_id = :id;
• Find variables bound to a specific budget version or encumbrance type for reconciliation reporting: join on budget_version_id or encumbrance_type_id.
• Discover which system variables, dimensions, selections, or templates reference a definition by driving from those child tables back to rg_dss_variables on variable_id.

Related Objects

The table participates in a network of dependent RG objects and GL reference objects. The most significant relationships, per the documented FK structure, are:

• GL_SETS_OF_BOOKS_11I — referenced via RG_DSS_VARIABLES.LEDGER_ID, supplying the ledger context.
• FND_CURRENCIES — referenced via RG_DSS_VARIABLES.CURRENCY_CODE, supplying currency validation.
• GL_BUDGET_VERSIONS — referenced via RG_DSS_VARIABLES.BUDGET_VERSION_ID.
• GL_ENCUMBRANCE_TYPES — referenced via RG_DSS_VARIABLES.ENCUMBRANCE_TYPE_ID.
• RG_DSS_SYSTEM_VARIABLES — child table joined on VARIABLE_ID.
• RG_DSS_VAR_DIMENSIONS — child table joined on VARIABLE_ID, holding dimension assignments.
• RG_DSS_VAR_SELECTIONS — child table joined on VARIABLE_ID, holding selection criteria.
• RG_DSS_VAR_TEMPLATES — child table joined on VARIABLE_ID, holding template associations.
• BSC_TMP_BIG_IN_COND — a temporary/staging table that references VARIABLE_ID.