Search Results selection_id




Overview
Explore in AI Chat

Overview

The RG_DSS_VAR_SELECTIONS table is a core data repository within the Application Report Generator (RG) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It functions as a junction table that defines the specific financial data items selected for analysis within the Financial Analyzer component. The table's primary role is to map user-defined report variables to the underlying application columns and, optionally, to specific segment value ranges, thereby enabling the dynamic construction of complex financial reports. It acts as a critical link between the definition of a report variable and the granular transactional or summary data it is intended to represent.

Key Information Stored

The table stores the relationships that define a data selection for a report variable. Its key columns, as indicated by the primary and unique keys, are crucial for maintaining data integrity and enabling precise data retrieval. The SELECTION_ID column serves as the primary surrogate key for each unique selection record. The VARIABLE_ID is a foreign key linking back to the parent variable definition in the RG_DSS_VARIABLES table. The APPLICATION_COLUMN_NAME specifies the exact column from the EBS application tables (e.g., GL_CODE_COMBINATIONS) that holds the data for this selection. Additionally, the RANGE_SET_ID is a foreign key that can optionally link to a predefined set of segment value ranges in the RG_DSS_SEG_RANGE_SETS table, allowing the selection to be filtered to a specific account, cost center, or other segment range.

Common Use Cases and Queries

The primary use case is the generation and execution of Financial Analyzer reports. When a user runs a report, the system queries this table to determine which pieces of data (identified by APPLICATION_COLUMN_NAME) are associated with each report variable and what constraints (via RANGE_SET_ID) apply. A common technical query involves joining this table to its parent and child tables to debug or analyze a report definition. For example, to list all selections for a specific variable, a developer might use:

  • SELECT s.application_column_name, r.range_set_name
  • FROM rg_dss_var_selections s,
  • rg_dss_seg_range_sets r
  • WHERE s.variable_id = :p_variable_id
  • AND s.range_set_id = r.range_set_id(+);

This pattern is essential for understanding how a high-level report metric resolves to the underlying general ledger or subledger data.

Related Objects

The RG_DSS_VAR_SELECTIONS table has documented foreign key relationships with two key tables in the RG module, forming a central part of the report definition data model.

  • RG_DSS_VARIABLES: This table is the parent, containing the master definition of report variables. The relationship is defined by RG_DSS_VAR_SELECTIONS.VARIABLE_ID referencing RG_DSS_VARIABLES.
  • RG_DSS_SEG_RANGE_SETS: This table stores reusable sets of value ranges for financial segments (like accounts). The relationship is defined by RG_DSS_VAR_SELECTIONS.RANGE_SET_ID referencing RG_DSS_SEG_RANGE_SETS, allowing a selection to be scoped to a specific range of values.

These relationships ensure that every data selection is tied to a valid report variable and, if applicable, a valid filtering range set.