Search Results gcs_entity_cons_attrs

Overview

The GCS_ENTITY_CONS_ATTRS table is a core data object within Oracle E-Business Suite's Financial Consolidation Hub (GCS) module. It serves as the primary repository for storing consolidation-specific attributes assigned to individual entities (nodes) within a defined consolidation hierarchy. This table is fundamental to the consolidation engine, as it holds the critical metadata that dictates how each legal entity or business unit is processed during financial consolidation runs, including its currency and hierarchical position. Its role is to link the structural definition of a hierarchy with the operational rules applied to each participating entity.

Key Information Stored

The table's structure is centered on the unique combination of a hierarchy and an entity. Its primary key, comprised of HIERARCHY_ID and ENTITY_ID, enforces that each entity can have only one set of consolidation attributes per hierarchy. While the full column list is not detailed in the provided metadata, the documented foreign keys reveal two critical attributes: the HIERARCHY_ID, which links to the GCS_HIERARCHIES_B table to identify the consolidation structure, and the CURRENCY_CODE, which links to the FND_CURRENCIES table. This currency attribute is typically the local or functional currency in which the entity's data is consolidated. Other columns likely present would store flags and settings controlling consolidation methods, elimination rules, intercompany processing, and ownership percentages.

Common Use Cases and Queries

This table is central to consolidation setup, reporting, and data validation. A common use case is generating a report of all entities within a specific consolidation hierarchy along with their key processing attributes. For example, to audit the currency setup for a hierarchy named 'Q1_CONSOLIDATION', a query would join to the hierarchy and currency tables. Another critical scenario involves troubleshooting consolidation results by verifying the attributes applied to a specific entity. Developers may also query this table programmatically within custom extensions or data migration scripts to validate or populate entity-level consolidation settings before initiating a consolidation process.

• Sample Query: SELECT hec.entity_id, hec.currency_code, fc.name FROM gcs_entity_cons_attrs hec JOIN gcs_hierarchies_b ghb ON hec.hierarchy_id = ghb.hierarchy_id JOIN fnd_currencies fc ON hec.currency_code = fc.currency_code WHERE ghb.hierarchy_name = 'Q1_CONSOLIDATION';

Related Objects

The GCS_ENTITY_CONS_ATTRS table maintains defined relationships with other key EBS objects, as per the provided metadata. It is the child table in these relationships, deriving valid values from referenced master tables.

• GCS_HIERARCHIES_B: Linked via the HIERARCHY_ID column. This is the master table for consolidation hierarchy definitions. Every record in GCS_ENTITY_CONS_ATTRS must correspond to a valid, existing hierarchy.
• FND_CURRENCIES: Linked via the CURRENCY_CODE column. This ensures that the currency assigned to an entity for consolidation is a valid, active currency within the Oracle Applications instance.

As a cornerstone table, it is also likely referenced by various GCS process and reporting views, though those specific dependencies are not listed in the excerpt provided.