Search Results rg_dss_variables




Overview
Explore in AI Chat

Overview

The RG_DSS_VARIABLES table is a core data repository within the Oracle E-Business Suite Application Report Generator (RG) module. It serves as the master definition table for Financial Analyzer financial data items, which are the fundamental building blocks for creating complex financial reports and analyses. Each record in this table represents a unique variable—a specific piece of financial data, such as an account balance, budget amount, or encumbrance—that can be selected, calculated, and reported on. Its primary role is to provide a centralized, metadata-driven catalog of available financial data points that the Report Generator engine uses to construct and execute reports.

Key Information Stored

The table stores metadata that defines the characteristics and context of each financial variable. The primary identifier is the VARIABLE_ID. The NAME and OBJECT_NAME columns provide unique identifiers for the variable itself. Crucially, the table links the variable to its operational context through foreign key columns: LEDGER_ID (to GL_SETS_OF_BOOKS_11I), CURRENCY_CODE (to FND_CURRENCIES), BUDGET_VERSION_ID (to GL_BUDGET_VERSIONS), and ENCUMBRANCE_TYPE_ID (to GL_ENCUMBRANCE_TYPES). This structure ensures that each variable is precisely scoped to a specific ledger, currency, budget version, or encumbrance type as required.

Common Use Cases and Queries

The primary use case is the design and generation of financial reports within the Application Report Generator. Administrators and report designers query this table to understand available data items. A common query involves listing all variables for a specific ledger to populate report builder dropdowns. For example:

  • SELECT name, object_name, currency_code FROM rg.rg_dss_variables WHERE ledger_id = :ledger_id ORDER BY name;

Another critical use is troubleshooting report definitions by tracing a variable back to its source definitions. When a report execution fails or returns unexpected data, developers often join this table with its related child tables (like RG_DSS_VAR_DIMENSIONS) to validate the variable's configuration and dimensionality.

Related Objects

RG_DSS_VARIABLES is a central hub with numerous relationships. It is referenced by several child tables that store additional variable-specific configurations:

  • RG_DSS_SYSTEM_VARIABLES: Links via VARIABLE_ID to define system-level variables.
  • RG_DSS_VAR_DIMENSIONS: Links via VARIABLE_ID to define the dimensional constraints (e.g., specific accounts, periods) for the variable.
  • RG_DSS_VAR_SELECTIONS: Links via VARIABLE_ID to store user-defined selections for the variable.
  • RG_DSS_VAR_TEMPLATES: Links via VARIABLE_ID to associate variables with report templates.

Furthermore, it draws context from key General Ledger tables via foreign keys: GL_SETS_OF_BOOKS_11I (LEDGER_ID), FND_CURRENCIES (CURRENCY_CODE), GL_BUDGET_VERSIONS (BUDGET_VERSION_ID), and GL_ENCUMBRANCE_TYPES (ENCUMBRANCE_TYPE_ID).