Search Results rg_dss_dim_segments_pk

Overview

The RG_DSS_DIM_SEGMENTS table is a core data structure within the Application Report Generator (RG) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It functions as the mapping table for Financial Analyzer dimension segment definitions. Its primary role is to store the configuration that links a specific Financial Analyzer dimension to one or more segments of the EBS General Ledger Accounting Flexfield. This mapping is essential for the correct translation and transfer of financial data from the transactional GL into the multidimensional analysis environment of Financial Analyzer, enabling advanced reporting and consolidation processes.

Key Information Stored

The table's structure is designed to define the segment-by-segment composition of a Financial Analyzer dimension. The critical columns include DIMENSION_ID, which is a foreign key to the RG_DSS_DIMENSIONS table and identifies the specific dimension being defined. The SEQUENCE column determines the order in which the GL segment values are concatenated to form the dimension member code. The APPLICATION_COLUMN_NAME column specifies the exact segment of the Accounting Flexfield (e.g., SEGMENT1, SEGMENT2) that is mapped to this position in the dimension. The table's primary keys (RG_DSS_DIM_SEGMENTS_PK on DIMENSION_ID and SEQUENCE, and RG_DSS_DIM_SEGMENTS_UK1 on DIMENSION_ID and APPLICATION_COLUMN_NAME) enforce the integrity of these mappings, ensuring a dimension has a defined segment order and that a single GL segment is not mapped multiple times within the same dimension.

Common Use Cases and Queries

The primary use case is the setup and verification of Financial Analyzer dimension definitions during system configuration or troubleshooting. A system administrator or functional consultant would query this table to understand how a GL account string decomposes into various analytical dimensions like "Account," "Company," or "Product." A typical diagnostic query would join to the dimension master table:

SELECT dim.dimension_name, seg.sequence, seg.application_column_name
FROM rg.rg_dss_dim_segments seg,
     rg.rg_dss_dimensions dim
WHERE seg.dimension_id = dim.dimension_id
ORDER BY dim.dimension_name, seg.sequence;

This query reveals the segment structure for all configured dimensions. Another critical use is during data extraction or validation processes, where programs reference these mappings to correctly transform GL balances into the Financial Analyzer star schema format.

Related Objects

RG_DSS_DIM_SEGMENTS is centrally linked to other core tables in the RG DSS (Decision Support System) schema through documented foreign key relationships.

• RG_DSS_DIMENSIONS: This is the parent master table. The RG_DSS_DIM_SEGMENTS.DIMENSION_ID column is a foreign key to RG_DSS_DIMENSIONS, defining which dimension the segment mapping belongs to.
• RG_DSS_SEG_RANGE_SETS: The RG_DSS_DIM_SEGMENTS.RANGE_SET_ID column is a foreign key to this table. This relationship allows a dimension segment mapping to be associated with a predefined range set of segment values, enabling selective data population for the dimension based on value hierarchies or groupings.