Search Results gl_cons_segment_map_pk

Overview

GL_CONS_SEGMENT_MAP is a General Ledger consolidation configuration table that stores the segment mapping rules used during the consolidation of multiple ledgers into a single consolidation ledger. In Oracle EBS, consolidation allows a parent organization to combine the balances of one or more subsidiary ledgers into a single ledger so that enterprise-wide reporting can be produced. Because subsidiary ledgers frequently use different charts of accounts, balancing segments, or value sets than the parent, GL_CONS_SEGMENT_MAP defines how individual source (from) segments are translated to target (to) segments during the consolidation process. Each row represents one consolidation segment rule tied to a specific consolidation definition.

The table is owned by the GL schema and is classified as VALID in the ETRM documentation. It forms part of the technical foundation behind the Consolidation Workbench, which reads these rules when it maps and transfers subsidiary balances to the parent ledger. From a heuristic Data Vault modeling perspective, the metadata classifies GL_CONS_SEGMENT_MAP as satellite-leaning. This suggests it is best modeled as a satellite attached to a consolidation hub (GL_CONSOLIDATION), since it carries descriptive rule attributes that describe how a consolidation is configured rather than acting as an independent business entity.

Key Information Stored

The table contains 21 documented columns. The most significant are summarized below.

• SEGMENT_MAP_ID — The surrogate primary key, enforced by GL_CONS_SEGMENT_MAP_PK and the unique index GL_CONS_SEGMENT_MAP_U1. It uniquely identifies each segment mapping rule and is the column referenced by dependent child tables.
• CONSOLIDATION_ID_11I — Foreign key to GL_CONSOLIDATION, tying the rule to its parent consolidation definition.
• SEGMENT_MAP_TYPE — Indicates the mapping category, controlling whether the rule applies to a single value, a parent rollup, or a hierarchy mapping.
• FROM_VALUE_SET_ID / TO_VALUE_SET_ID — Foreign keys to FND_FLEX_VALUE_SETS identifying the source and target value sets for the mapping.
• FROM_APPLICATION_COLUMN_NAME / TO_APPLICATION_COLUMN_NAME — Identify the source and destination segment columns participating in the mapping.
• PARENT_ROLLUP_VALUE — Defines the parent or rollup value used when consolidating a hierarchical segment.
• SINGLE_VALUE — The specific segment value applied when the rule maps a single value rather than a range.
• COA_MAPPING_ID — Foreign key to GL_COA_MAPPINGS, linking the rule to a chart-of-accounts mapping definition.
• ATTRIBUTE1 through ATTRIBUTE5 and CONTEXT — Descriptive flexfield columns for extensible configuration.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns.

Common Use Cases and Queries

Consolidation administrators and technical analysts query this table to verify and troubleshoot how subsidiary balances are mapped to the parent ledger. A typical query lists all mapping rules for a given consolidation, joining to GL_CONSOLIDATION for validation:

• SELECT m.segment_map_id, m.segment_map_type, m.from_value_set_id, m.to_value_set_id FROM gl_cons_segment_map m WHERE m.consolidation_id_11i = :consolidation_id;
• Reporting on which value sets or chart-of-accounts mappings are reused across consolidations, helpful when diagnosing mapping gaps or duplicate rules.
• Detecting consolidation rules that reference the same SINGLE_VALUE or PARENT_ROLLUP_VALUE to confirm consistency between subsidiary and parent charts of accounts.

Related Objects

• GL_CONSOLIDATION — Parent consolidation definition; joined via CONSOLIDATION_ID_11I.
• GL_CONS_FLEX_HIERARCHIES — Child hierarchy table referencing SEGMENT_MAP_ID.
• FND_FLEX_VALUE_SETS — Referenced twice via FROM_VALUE_SET_ID and TO_VALUE_SET_ID.
• GL_COA_MAPPINGS — Chart-of-accounts mapping referenced via COA_MAPPING_ID.
• FND_FLEX_VALUES — Provides the individual values resolved through the value sets.