Search Results rg_dss_variables_u3

Overview

RG.RG_DSS_VARIABLES is a Financial Analyzer configuration table owned by the RG schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the definition of "financial data items" (DSS variables) that drive the Oracle Financial Analyzer/Enterprise Planning and Budgeting dimensional model. Each row defines a single analyzable variable — a General Ledger balance or amount concept — together with the ledger, currency handling, balance type, account structure, and dimensional segment typing required to materialize and aggregate financial data for analysis. The table is stored in the APPS_TS_TX_DATA tablespace with its unique indexes in APPS_TS_TX_IDX, and is flagged by Oracle as internal use only; it is intended to be accessed through standard Oracle Applications programs rather than direct DML.

From a Data Vault modeling perspective, the metadata classifies this object as satellite-leaning. This is a heuristic suggestion: RG_DSS_VARIABLES carries descriptive, versioned attributes (status, labels, balance type, currency type) about a defined business concept, so it behaves more like a satellite than an independent hub or a pure intersection link.

Key Information Stored

The table exposes 66 documented columns. The most significant are outlined below; surrogate and business keys are distinguished per the documented unique indexes.

• VARIABLE_ID — NUMBER(15), the surrogate primary key (RG_DSS_VARIABLES_PK) and the target of every child relationship.
• NAME — VARCHAR2(60), the human-readable financial data item name; enforced by unique index RG_DSS_VARIABLES_U2, making it a business-key candidate.
• OBJECT_NAME — VARCHAR2(16), the item name as surfaced in Financial Analyzer; enforced by unique index RG_DSS_VARIABLES_U3, a second business-key candidate.
• LEDGER_ID — NUMBER(15), the ledger (set of books) the variable is sourced from; foreign key to GL_SETS_OF_BOOKS_11I.
• BALANCE_TYPE / CURRENCY_TYPE / LEVEL_CODE — control attributes defining how the item is aggregated, which currency treatment applies (Foreign Entered, Foreign Translated, Functional Only, Statistical Only, Functional and Statistical), and whether the item is Summary or Detail.
• STATUS_CODE — lifecycle status of the variable.
• CURRENCY_CODE / BUDGET_VERSION_ID / ENCUMBRANCE_TYPE_ID — optional scoping to a specific currency, GL budget version, or encumbrance type.
• ID_FLEX_CODE / ID_FLEX_NUM — the key flexfield and structure number, identifying the accounting flexfield the item maps to.
• SEGMENT1_TYPE through SEGMENT30_TYPE — per-segment typing that controls how each accounting flexfield segment is treated as a dimension.
• COLUMN_LABEL / DESCRIPTION — presentation metadata (Financial Analyzer labels and descriptive text).
• Standard Who columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN.
• CONTEXT and ATTRIBUTE1–ATTRIBUTE15 — the descriptive flexfield structure and its attribute columns.

Common Use Cases and Queries

Typical activity centers on validating variable definitions before a Financial Analyzer build, tracing which ledger and currency treatment an item uses, and confirming that segment typing matches the accounting flexfield structure. A common diagnostic is locating the record behind a duplicate NAME or OBJECT_NAME, since both are uniquely enforced:

SELECT variable_id, name, object_name, ledger_id, balance_type, status_code FROM rg.rg_dss_variables WHERE UPPER(name) = UPPER(:p_name);

Reporting queries join to GL to resolve the ledger and to child tables to inspect dimensions and selections:

SELECT v.variable_id, v.name, g.name ledger, v.currency_type, v.level_code FROM rg.rg_dss_variables v, gl_sets_of_books_11i g WHERE v.ledger_id = g.set_of_books_id AND v.status_code = 'ACTIVE';

Queries resolving the unique index behind the search term "rg_dss_variables_u2" confirm it covers NAME, which is the correct index for name-based lookups. A build-readiness check enumerates defined variables and their child dimension counts to detect incomplete setups.

Related Objects

RG_DSS_VARIABLES is heavily referenced, confirming its role as a configuration parent. The most significant related objects are:

• GL_SETS_OF_BOOKS_11I — joined via RG_DSS_VARIABLES.LEDGER_ID.
• FND_CURRENCIES — joined via RG_DSS_VARIABLES.CURRENCY_CODE.
• GL_BUDGET_VERSIONS — joined via RG_DSS_VARIABLES.BUDGET_VERSION_ID.
• GL_ENCUMBRANCE_TYPES — joined via RG_DSS_VARIABLES.ENCUMBRANCE_TYPE_ID.
• RG_DSS_SYSTEM_VARIABLES — child, VARIABLE_ID → RG_DSS_VARIABLES.
• RG_DSS_VAR_DIMENSIONS — child, VARIABLE_ID → RG_DSS_VARIABLES.
• RG_DSS_VAR_SELECTIONS — child, VARIABLE_ID → RG_DSS_VARIABLES.
• RG_DSS_VAR_TEMPLATES — child, VARIABLE_ID → RG_DSS_VARIABLES.
• BSC_TMP_BIG_IN_COND — child staging reference, VARIABLE_ID → RG_DSS_VARIABLES.

These relationships establish RG_DSS_VARIABLES as the central definition table for Financial Analyzer variables, with all dimensional and selection detail hanging off the VARIABLE_ID key, and all GL scoping resolved through the four foreign-key columns listed above.