Search Results rg_dss_dim_segments




Overview
Explore in AI Chat

Overview

The RG_DSS_DIM_SEGMENTS table is a core configuration object within the Oracle E-Business Suite Application Report Generator (RG) product module. It stores Financial Analyzer dimension segment mappings, defining how individual key flexfield segments are associated with analytical dimensions and their underlying segment range sets. In practice, this table acts as the bridge between Oracle General Ledger's Accounting Flexfield structure and the dimensional model used by Oracle Financial Analyzer for reporting and analysis.

From a Data Vault modeling perspective, the heuristic classification derived from the foreign key structure suggests that RG_DSS_DIM_SEGMENTS functions as a link table. It resolves relationships between parent entities — specifically RG_DSS_DIMENSIONS and RG_DSS_SEG_RANGE_SETS — while also carrying descriptive mapping attributes. Its composite primary key and dual unique constraints reinforce its role as an associative structure connecting dimension definitions to concrete flexfield segment configurations.

Key Information Stored

The table contains 29 documented columns. The most significant are:

  • DIMENSION_ID — Foreign key to RG_DSS_DIMENSIONS; identifies the Financial Analyzer dimension to which the segment mapping belongs. Part of both the primary key and the first unique key.
  • SEQUENCE — Ordinal position of the segment within the dimension. Combined with DIMENSION_ID, forms the primary key RG_DSS_DIM_SEGMENTS_PK and unique index U1.
  • APPLICATION_COLUMN_NAME — The application-level column name for the segment. Combined with DIMENSION_ID, forms unique index U2, enforcing one mapping per dimension per column name.
  • RANGE_SET_ID — Foreign key to RG_DSS_SEG_RANGE_SETS; identifies the segment range set supplying allowable values.
  • ID_FLEX_CODE / ID_FLEX_NUM — Identify the key flexfield definition (and its version) from which the segment originates.
  • MAX_DESC_SIZE — Maximum description size permitted for the segment value.
  • ACCOUNT_TYPE — Classifies the segment's account type context.
  • CONTEXT — Descriptive flexfield context reference.
  • ATTRIBUTE1 through ATTRIBUTE15 — Descriptive flexfield attribute columns for extensibility.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard EBS audit columns.

The surrogate primary key is RG_DSS_DIM_SEGMENTS_PK (DIMENSION_ID, SEQUENCE). The business-key candidates surfaced by the unique indexes are U1 (DIMENSION_ID, SEQUENCE) and U2 (DIMENSION_ID, APPLICATION_COLUMN_NAME).

Common Use Cases and Queries

Typical usage centers on diagnosing Financial Analyzer dimension configuration, validating segment mappings before data loads, and auditing which flexfield segments feed which dimensions. A common reporting query joins the mapping to its parent dimension and range set:

  • List the segment ordering for a dimension: SELECT sequence, application_column_name, range_set_id FROM rg_dss_dim_segments WHERE dimension_id = :p_dim ORDER BY sequence;
  • Trace a segment back to its flexfield: SELECT s.dimension_id, s.application_column_name, s.id_flex_code, s.id_flex_num FROM rg_dss_dim_segments s WHERE s.id_flex_code = :flex_code;
  • Reconcile range set usage: SELECT s.dimension_id, s.sequence, r.range_set_name FROM rg_dss_dim_segments s, rg_dss_seg_range_sets r WHERE s.range_set_id = r.range_set_id;
  • Audit recent configuration changes: SELECT dimension_id, sequence, last_updated_by, last_update_date FROM rg_dss_dim_segments ORDER BY last_update_date DESC;

These patterns support implementation validation, migration verification, and ongoing configuration governance.

Related Objects

  • RG_DSS_DIMENSIONS — Parent dimension definition; joined on DIMENSION_ID.
  • RG_DSS_SEG_RANGE_SETS — Supplies range set definitions; joined on RANGE_SET_ID.
  • RG_DSS_DIM_SEGMENTS_PK — Primary key constraint on (DIMENSION_ID, SEQUENCE).
  • RG_DSS_DIM_SEGMENTS_UK1 / U1 — Unique constraint on (DIMENSION_ID, SEQUENCE).
  • RG_DSS_DIM_SEGMENTS_UK1 / U2 — Unique constraint on (DIMENSION_ID, APPLICATION_COLUMN_NAME).
  • FND_ID_FLEX_STRUCTURES / FND_ID_FLEX_SEGMENTS — Reference the flexfield identified by ID_FLEX_CODE and ID_FLEX_NUM.