Search Results rg_dss_hierarchy_details_pk

Overview

The RG_DSS_HIERARCHY_DETAILS table is a core data structure within the Application Report Generator (RG) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It serves as a mapping table that defines the relationship between Financial Analyzer (DSS) hierarchies and the specific segments of the General Ledger (GL) Accounting Flexfield. This table is essential for the integration and data transfer between the operational GL and the analytical Financial Analyzer environment, enabling the hierarchical roll-up and analysis of financial data according to custom-defined organizational structures.

Key Information Stored

The table stores the detailed segment-to-hierarchy mappings for each Financial Analyzer hierarchy definition. The primary columns, as defined by its constraints, are HIERARCHY_ID and SEQUENCE, which together form the primary key (RG_DSS_HIERARCHY_DETAILS_PK). The HIERARCHY_ID is a foreign key linking to the parent RG_DSS_HIERARCHIES table, identifying the specific hierarchy being detailed. The SEQUENCE column dictates the order in which the segment mapping is applied. A critical column is APPLICATION_COLUMN_NAME, which, in conjunction with HIERARCHY_ID, forms a unique key (RG_DSS_HIERARCHY_DETAILS_UK). This column typically stores the name of the GL Accounting Flexfield segment (e.g., SEGMENT1, SEGMENT2) that is mapped to a corresponding level within the Financial Analyzer hierarchy.

Common Use Cases and Queries

This table is primarily accessed during the configuration and execution of data transfers to Financial Analyzer. Common scenarios include validating hierarchy definitions, troubleshooting data mismatches during the population of Financial Analyzer, and generating metadata reports on active hierarchies. A typical query would join this table to its parent to list all segment mappings for a specific hierarchy, as shown below:

• SELECT h.hierarchy_name, d.sequence, d.application_column_name FROM rg_dss_hierarchies h, rg_dss_hierarchy_details d WHERE h.hierarchy_id = d.hierarchy_id ORDER BY h.hierarchy_name, d.sequence;

Another use case involves verifying the integrity of a hierarchy's definition by checking for missing or duplicate segment mappings based on the unique key constraint.

Related Objects

The RG_DSS_HIERARCHY_DETAILS table has a direct and critical dependency on the RG_DSS_HIERARCHIES table, which stores the master definition of each hierarchy. The documented foreign key relationship is:

• RG_DSS_HIERARCHIES: The RG_DSS_HIERARCHY_DETAILS.HIERARCHY_ID column references the HIERARCHY_ID in the RG_DSS_HIERARCHIES table. This relationship ensures that every detail mapping is associated with a valid, parent hierarchy definition.

This table is a foundational component for the RG_DSS_* set of tables that support the Financial Analyzer integration, and it is typically referenced by the internal programs and APIs responsible for generating and maintaining Financial Analyzer data sets.