Search Results gcs_cons_relationships_u1

Overview

The GCS_CONS_RELATIONSHIPS table is a core data repository within the Oracle General Ledger Consolidation System (GCS) for Oracle E-Business Suite releases 12.1.1 and 12.2.2. It serves as the master table for defining and storing the structural and financial relationships between entities within a specified consolidation hierarchy. Each record represents a specific parent-child link, detailing the consolidation treatment, ownership percentage, and the effective period of that relationship. This table is fundamental to the consolidation engine's ability to correctly roll up financial data, calculate ownership interests, and apply the appropriate consolidation treatments (e.g., full, proportional, or equity consolidation) during the financial close process.

Key Information Stored

The table's columns capture the essential attributes of each consolidation relationship. The primary identifier, CONS_RELATIONSHIP_ID, uniquely defines each relationship record. The structural context is provided by HIERARCHY_ID, PARENT_ENTITY_ID, and CHILD_ENTITY_ID. The financial and procedural rules are defined by OWNERSHIP_PERCENT, TREATMENT_ID (consolidation method), and CURR_TREATMENT_ID (currency translation method). Temporal validity is managed via START_DATE and END_DATE. Flags such as DOMINANT_PARENT_FLAG and ACTUAL_OWNERSHIP_FLAG provide additional control over relationship behavior. Standard Oracle Applications "Who" columns (CREATED_BY, LAST_UPDATE_DATE, etc.) and an OBJECT_VERSION_NUMBER for optimistic locking are also maintained.

Common Use Cases and Queries

This table is central to consolidation setup, reporting, and impact analysis. A common use case is validating or reporting the complete relationship structure for a specific hierarchy. The following query pattern retrieves active relationships for analysis:

• SELECT cons_relationship_id, parent_entity_id, child_entity_id, ownership_percent, treatment_id FROM gcs.gcs_cons_relationships WHERE hierarchy_id = :p_hierarchy_id AND (end_date IS NULL OR end_date > SYSDATE) ORDER BY parent_entity_id, child_entity_id;

Another critical scenario involves calculating effective ownership percentages, which may require traversing multiple relationship levels and considering the DELTA_OWNED column for indirect ownership. Data in this table is also directly referenced by the consolidation impact analysis functionality to assess the effects of proposed hierarchy changes.

Related Objects

The GCS_CONS_RELATIONSHIPS table is integral to the GCS schema's data model, with defined foreign key relationships ensuring referential integrity. It references master definition tables: HIERARCHY_ID links to GCS_HIERARCHIES_B, TREATMENT_ID to GCS_TREATMENTS_B, and CURR_TREATMENT_ID to GCS_CURR_TREATMENTS_B. Crucially, this table is referenced as a parent by the GCS_CONS_IMPACT_ANALYSES table via the foreign key on PRE_RELATIONSHIP_ID, which stores historical relationship data for comparison during change analysis. The primary key constraint GCS_CONS_RELATIONSHIPS_PK on CONS_RELATIONSHIP_ID enforces uniqueness and is indexed by GCS_CONS_RELATIONSHIPS_U1.