Search Results gl_cons_segment_map




Overview
Explore in AI Chat

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.

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.