Search Results rg_dss_variables




Overview
Explore in AI Chat

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:

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.