Search Results gl_cons_flex_hierarchies_pk

Overview

GL_CONS_FLEX_HIERARCHIES is a General Ledger consolidation table in Oracle E-Business Suite (Release 12.1.1 and 12.2.2) that stores the subsidiary segment hierarchies used by the Global Consolidation System (GCS). It defines how the balancing segment values (or other key flexfield segment values) of subsidiary ledgers map to parent values in a consolidating parent ledger, allowing balances from many distinct subsidiaries to be aggregated into a single consolidated chart of accounts structure.

The table is owned by the GL schema and carries a VALID status. Its primary key, GL_CONS_FLEX_HIERARCHIES_PK, is composed of SEGMENT_MAP_ID, PARENT_FLEX_VALUE, CHILD_FLEX_VALUE_LOW, and CHILD_FLEX_VALUE_HIGH. The only documented foreign key links SEGMENT_MAP_ID to GL_CONS_SEGMENT_MAP. Based on the mined foreign key structure, the object is classified heuristically as satellite-leaning — it holds descriptive hierarchy attributes that extend the parent mapping entity rather than acting as an independent hub or a pure link. This classification is offered as a modeling suggestion for warehouse or data-vault style designs and should be validated against actual ETL requirements.

Key Information Stored

The documented physical schema contains 15 columns. The most significant are:

• SEGMENT_MAP_ID — The foreign key to GL_CONS_SEGMENT_MAP. It identifies the consolidation segment mapping (and therefore the consolidation definition and target segment) to which the hierarchy rows belong. It is part of the composite primary key.
• PARENT_FLEX_VALUE — The parent (consolidated) flexfield value, such as a parent company or parent cost center, into which child values are rolled up. It is part of the primary key.
• CHILD_FLEX_VALUE_LOW — The low end of the child flex value range that maps to the parent. It is part of the primary key.
• CHILD_FLEX_VALUE_HIGH — The high end of the child flex value range. Because the key stores both LOW and HIGH, a single row can represent a contiguous range of child values rather than one discrete value. It is part of the primary key.

The remaining documented columns are standard EBS audit and descriptive attributes: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, the generic ATTRIBUTE1 through ATTRIBUTE5, and CONTEXT. The composite primary key acts as the surrogate identifier for the row, while the combination of PARENT_FLEX_VALUE, CHILD_FLEX_VALUE_LOW, and CHILD_FLEX_VALUE_HIGH within a given SEGMENT_MAP_ID constitutes the business-key candidate — the uniqueness guarantee that prevents overlapping or duplicate hierarchy definitions for the same mapping.

Common Use Cases and Queries

The principal use case is determining, for any given subsidiary segment value, which parent value it consolidates into. Consolidation programs read this table when translating and aggregating subsidiary balances into the parent ledger. A typical query resolves a child value against its range:

• Resolve a single value: SELECT parent_flex_value FROM gl_cons_flex_hierarchies WHERE segment_map_id = :map_id AND :child_value BETWEEN child_flex_value_low AND child_flex_value_high;
• List the full hierarchy for one mapping: SELECT segment_map_id, parent_flex_value, child_flex_value_low, child_flex_value_high FROM gl_cons_flex_hierarchies WHERE segment_map_id = :map_id ORDER BY parent_flex_value, child_flex_value_low;
• Audit changes: filter on last_update_date and last_updated_by to review who maintained the hierarchy.

Reporting use cases include generating a consolidation mapping report, verifying that every subsidiary value is covered by exactly one range, and reconciling the hierarchy against GL_CONS_SEGMENT_MAP before running consolidation.

Related Objects

The most significant related objects, drawn from the documented foreign key relationship and standard consolidation dependencies, are:

• GL_CONS_SEGMENT_MAP — joined on GL_CONS_FLEX_HIERARCHIES.SEGMENT_MAP_ID = GL_CONS_SEGMENT_MAP.SEGMENT_MAP_ID. This is the mandatory parent of the hierarchy.
• GL_CONSOLIDATION — the consolidation definition that owns segment mappings.
• GL_CONSOLIDATION_SETS and GL_CONSOLIDATION_SET_LEDGERS — define which ledgers participate in the consolidation.
• GL_LEDGERS — supplies the ledger context for the mappings and hierarchies.
• FND_FLEX_VALUES_VL — provides descriptions and enabled status for the parent and child flex values referenced in the hierarchy.
• GL_BALANCES — the balances subsequently consolidated using these mappings.