Search Results rg_dss_hierarchies




Overview
Explore in AI Chat

Overview

The RG_DSS_HIERARCHIES table is a core data structure within the Oracle E-Business Suite (EBS) Application Report Generator (RG) module. It serves as the master repository for storing hierarchical definitions used by the Financial Analyzer component. A hierarchy, in this context, defines the parent-child relationships and roll-up structures for a specific dimension, such as Account, Cost Center, or Product. These hierarchies are essential for performing multidimensional analysis, consolidation, and generating complex financial reports. The table's existence underscores the integration of online analytical processing (OLAP) capabilities within the EBS financial reporting framework, enabling users to analyze data across various organizational levels.

Key Information Stored

The table stores metadata that defines each hierarchy. While the full column list is not detailed in the provided excerpt, the primary and foreign key relationships reveal the critical data points. The HIERARCHY_ID column is the unique primary key identifier for each hierarchy record. The NAME column stores the unique name of the hierarchy, enforced by a unique key constraint. The DIMENSION_ID is a foreign key that links the hierarchy to its corresponding dimension in the RG_DSS_DIMENSIONS table, specifying whether the hierarchy is for Accounts, Time, or another custom dimension. Other typical columns in such a table would include descriptive fields, creation dates, and status indicators to manage the hierarchy's lifecycle.

Common Use Cases and Queries

This table is primarily accessed during the setup and execution of Financial Analyzer reports and consolidations. Common operational scenarios include validating hierarchy definitions, listing all hierarchies for a specific dimension, and troubleshooting reporting issues by tracing hierarchy metadata. A typical query would join to the dimension table to retrieve a descriptive list:

  • SELECT h.name, h.hierarchy_id, d.dimension_name FROM rg_dss_hierarchies h, rg_dss_dimensions d WHERE h.dimension_id = d.dimension_id ORDER BY d.dimension_name, h.name;

Another critical use case is identifying which reporting requests (RG_DSS_REQUESTS) utilize a specific hierarchy, which is vital for impact analysis before modifying a hierarchy definition.

Related Objects

The RG_DSS_HIERARCHIES table sits at the center of a key relationship model within the Report Generator's DSS (Decision Support System) schema. Based on the documented foreign keys:

  • References (Parent): RG_DSS_DIMENSIONS table via the DIMENSION_ID column. A hierarchy must belong to a single dimension.
  • Referenced By (Children):
    • RG_DSS_HIERARCHY_DETAILS: Linked via HIERARCHY_ID. This child table stores the individual member nodes and their parentage that compose the hierarchical structure defined in the master record.
    • RG_DSS_REQUESTS: Linked via HIERARCHY_ID. This table stores report submission requests, indicating which specific hierarchy was selected for the report's analysis perspective.

Direct modification of data in this table is not standard practice; hierarchies are typically managed through the application's dedicated administrative interfaces.