Search Results rg_dss_var_selections




Overview
Explore in AI Chat

Overview

The RG_DSS_VAR_SELECTIONS table resides in the RG schema (Application Report Generator product) within Oracle EBS 12.1.1 and 12.2.2. It stores Financial Analyzer financial data item selections — the configuration records that define which financial data items (columns) and which segment range sets a given report variable draws upon when a Financial Analyzer report is executed. In practice, this table acts as the bridge between a report variable definition and the set of general ledger key flexfield segments (ranges) that constrain the data returned.

Under a heuristic Data Vault classification mined from its foreign key structure, RG_DSS_VAR_SELECTIONS models as a link entity. That classification is a modeling suggestion derived from the fact that it carries two distinct foreign keys pointing at other dimension/hub-like parents (RG_DSS_VARIABLES and RG_DSS_SEG_RANGE_SETS), plus its own surrogate primary key. The table does not hold descriptive master data on its own; it records associations and selection criteria.

Key Information Stored

The table is documented with 27 columns and two unique indexes. The most significant are:

  • SELECTION_ID — Surrogate primary key, enforced by RG_DSS_VAR_SELECTIONS_PK and duplicated as unique index RG_DSS_VAR_SELECTIONS_U1. This is the technical row identifier.
  • VARIABLE_ID — Foreign key to RG_DSS_VARIABLES; identifies the Financial Analyzer report variable to which this selection belongs. Part of the business-key candidate RG_DSS_VAR_SELECTIONS_UK1.
  • APPLICATION_COLUMN_NAME — The second component of RG_DSS_VAR_SELECTIONS_UK1; names the application column (financial data item) selected for the variable.
  • RANGE_SET_ID — Foreign key to RG_DSS_SEG_RANGE_SETS; the segment range set that filters which ledger values qualify.
  • ID_FLEX_CODE — Identifies the key flexfield (for example, the GL accounting flexfield) associated with the selection.
  • ID_FLEX_NUM — The specific flexfield structure number the selection applies to.
  • CONTEXT — Descriptive flexfield context column, allowing extension of the selection record.
  • ATTRIBUTE1 through ATTRIBUTE15 — Standard EBS descriptive flexfield attribute segments for user-defined extension.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard EBS audit columns tracking who created and last modified each selection and when.

The distinction between the surrogate key and the business key matters for de-duplication and integration: SELECTION_ID is meaningless outside the system, whereas the (VARIABLE_ID, APPLICATION_COLUMN_NAME) pair is the meaningful identifier for the selected data item.

Common Use Cases and Queries

Typical scenarios include auditing which financial data items a report variable exposes, troubleshooting reports that return unexpected balances due to a mis-scoped range set, and migrating report definitions between environments. A representative query joining the variable and the selected column is:

  • SELECT s.selection_id, s.variable_id, s.application_column_name, s.range_set_id, s.id_flex_code, s.id_flex_num FROM rg.rg_dss_var_selections s WHERE s.variable_id = :p_variable_id;
  • Range-set diagnostics: SELECT s.variable_id, s.application_column_name, r.range_set_id FROM rg.rg_dss_var_selections s JOIN rg.rg_dss_seg_range_sets r ON r.range_set_id = s.range_set_id WHERE s.id_flex_code = 'GL#';
  • Change auditing using the audit columns: SELECT selection_id, last_updated_by, last_update_date FROM rg.rg_dss_var_selections WHERE last_update_date > :p_since;

Related Objects

The following objects are the most significant for joins and dependency analysis:

  • RG_DSS_VARIABLES — Parent of the selection via RG_DSS_VAR_SELECTIONS.VARIABLE_ID.
  • RG_DSS_SEG_RANGE_SETS — Parent range-set definition via RG_DSS_VAR_SELECTIONS.RANGE_SET_ID.
  • RG_DSS_VAR_SELECTIONS_PK and RG_DSS_VAR_SELECTIONS_UK1 / _U1 — Primary and unique indexes enforcing row and business-key uniqueness.
  • General Ledger key flexfield definition tables referenced indirectly through ID_FLEX_CODE and ID_FLEX_NUM to resolve segment meanings.

Because of its two foreign keys, RG_DSS_VAR_SELECTIONS is a link-style junction record; any join that resolves report configuration should traverse both RG_DSS_VARIABLES and RG_DSS_SEG_RANGE_SETS to obtain complete context.