Search Results gcs_hierarchies_b




Overview
Explore in AI Chat

Overview

The GCS_HIERARCHIES_B table is the central header table for consolidation hierarchies within Oracle E-Business Suite's Financial Consolidation Hub (GCS) module. It serves as the master definition table for every distinct consolidation hierarchy configured in the system. A hierarchy defines the organizational structure used for financial reporting and consolidation processes, such as legal entity roll-ups, intercompany eliminations, and currency translation. The table's role is foundational; it stores the core metadata that governs how financial data is aggregated, validated, and reported across the enterprise. Its integrity is critical, as evidenced by its numerous foreign key relationships with transactional and configuration tables throughout the GCS module.

Key Information Stored

While the provided metadata does not list specific columns beyond the primary and foreign keys, the table's description and relationships indicate it stores essential header-level attributes for each hierarchy. The primary key, HIERARCHY_ID, uniquely identifies each hierarchy definition. A critical foreign key, THRESHOLD_CURRENCY, references the FND_CURRENCIES table, establishing the base currency used for materiality thresholds within the consolidation process. Other typical columns in such a header table would include the hierarchy name, description, status (e.g., active, inactive), effective dates, consolidation method flags, and various control parameters that dictate the behavior of the consolidation engine for that specific hierarchy.

Common Use Cases and Queries

This table is primarily accessed for configuration management, data integrity validation, and reporting on the consolidation setup. Common operational scenarios include retrieving a list of all active hierarchies for a reporting process, validating the currency setup before running a consolidation, or identifying all configuration objects tied to a specific hierarchy during a migration or upgrade. A typical query would join GCS_HIERARCHIES_B with its translated description table, GCS_HIERARCHIES_TL, to retrieve user-friendly names. For troubleshooting, one might query the header to ensure it is active before investigating related transactional data. Sample SQL to list hierarchies with their base threshold currency would be:

  • SELECT h.HIERARCHY_ID, tl.NAME, h.THRESHOLD_CURRENCY, c.NAME
  • FROM GCS_HIERARCHIES_B h,
  • GCS_HIERARCHIES_TL tl,
  • FND_CURRENCIES c
  • WHERE h.HIERARCHY_ID = tl.HIERARCHY_ID
  • AND h.THRESHOLD_CURRENCY = c.CURRENCY_CODE
  • AND tl.LANGUAGE = USERENV('LANG');

Related Objects

The GCS_HIERARCHIES_B table has a pivotal relationship with numerous other GCS tables, acting as a parent record for a wide array of consolidation configuration and transaction data. It references the FND_CURRENCIES table via the THRESHOLD_CURRENCY column. Crucially, it is referenced by the following key tables via the HIERARCHY_ID foreign key:

This extensive network of relationships underscores the table's role as the cornerstone of the Financial Consolidation Hub's data model.