Results for “gcs_entity_cons_attrs”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

GCS_ENTITY_CONS_ATTRS is a consolidation configuration table owned by the GCS schema and delivered as part of the Financial Consolidation Hub (GCS) module in Oracle E-Business Suite 12.1.1 and 12.2.2. The table stores node-level attribute information for entities that participate in a consolidation hierarchy. In the Financial Consolidation Hub model, a hierarchy defines the consolidation structure, and each member (entity) of that hierarchy can carry its own consolidation-related attributes—most notably a currency designation. This table captures those per-entity, per-hierarchy attributes, allowing the same entity to behave differently depending on which consolidation hierarchy it belongs to.

Based on the foreign key topology mined from the ETRM metadata, GCS_ENTITY_CONS_ATTRS resolves to a link in heuristic Data Vault terms. It sits between the consolidation hierarchy (GCS_HIERARCHIES_B) and a currency reference (FND_CURRENCIES), recording the association of a hierarchy to an entity along with the attributes that qualify that association. This classification should be treated as a modeling suggestion rather than an architectural definition; the physical table remains a standard EBS transactional configuration table with WHO-style audit columns.

Key Information Stored

The table contains nine documented columns. The most significant are:

• HIERARCHY_ID — Identifies the consolidation hierarchy to which the entity node belongs. Part of the composite primary key and a foreign key to GCS_HIERARCHIES_B.
• ENTITY_ID — Identifies the consolidation entity (the hierarchy node) whose attributes are being stored. Part of the composite primary key.
• CURRENCY_CODE — The functional or consolidation currency assigned to the entity within the context of the hierarchy. Foreign key to FND_CURRENCIES.
• OBJECT_VERSION_NUMBER — Optimistic locking column used by the EBS framework to detect concurrent updates.
• CREATION_DATE — Date the attribute row was created.
• CREATED_BY — User identifier of the creating session.
• LAST_UPDATE_DATE — Date of the most recent modification.
• LAST_UPDATED_BY — User identifier of the last modifying session.
• LAST_UPDATE_LOGIN — Login/session identifier associated with the last update.

The surrogate-style primary key is GCS_ENTITY_CONS_ATTRS_PK, defined on the column pair (HIERARCHY_ID, ENTITY_ID). A unique index, GCS_ENTITY_CONS_ATTRS_U1, is documented on the same two columns, making that pair the business-key candidate as well. Consequently, only one attribute row may exist per entity per hierarchy.

Common Use Cases and Queries

This table is typically accessed when validating or reporting the currency configuration of consolidation hierarchy members. A common pattern joins the attributes to the hierarchy definition and the currency table:

• Retrieving all entities and their assigned currencies for a given hierarchy:
  SELECT a.HIERARCHY_ID, a.ENTITY_ID, a.CURRENCY_CODE FROM GCS.GCS_ENTITY_CONS_ATTRS a WHERE a.HIERARCHY_ID = :p_hierarchy_id;
• Resolving the currency description for reporting by joining CURRENCY_CODE to FND_CURRENCIES.
• Confirming that each entity in a hierarchy has exactly one attribute row (using the PK/U1 uniqueness guarantee) as part of a consolidation setup validation.
• Auditing configuration changes over time using CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, and LAST_UPDATED_BY.
• Detecting entities whose assigned currency does not match the parent hierarchy's expected consolidation currency.

Related Objects

The following objects are most significant in relation to GCS_ENTITY_CONS_ATTRS, based on documented dependencies:

• GCS_HIERARCHIES_B — Referenced via HIERARCHY_ID; the parent hierarchy definition.
• FND_CURRENCIES — Referenced via CURRENCY_CODE; provides currency validation and descriptions.
• GCS_ENTITY_CONS_ATTRS_PK — Primary key constraint on (HIERARCHY_ID, ENTITY_ID).
• GCS_ENTITY_CONS_ATTRS_U1 — Unique index on (HIERARCHY_ID, ENTITY_ID).
• Financial Consolidation Hub entity and hierarchy maintenance pages, which read and write these attribute rows during consolidation setup.
• GCS consolidation reporting and processing logic that consumes entity currency attributes when translating and aggregating balances.