Search Results gl_cons_segment_map_u1

Overview

GL.GL_CONS_SEGMENT_MAP is a General Ledger consolidation configuration table in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the segment-level mapping rules that users define in the Segment Rules window of the Consolidation Mappings form. These rules govern how subsidiary ledger segment values are translated, copied, or rolled up into parent ledger segment values during consolidation processing.

Each row represents a single mapping rule scoped to a chart of accounts mapping and a pair of source and target value sets. The SEGMENT_MAP_TYPE column determines the semantics of the rule: 'C' for copy value, 'S' for single value, 'R' for Detail Ranges rollup, 'U' for Parent Ranges rollup, 'P' for Detail Parent rollup, and 'V' for Summary Parent rollup. This design allows a single table to encode both direct value transfers and hierarchical aggregation logic.

Under a heuristic Data Vault classification, the table exhibits satellite-leaning characteristics. It is anchored by a surrogate primary key (SEGMENT_MAP_ID) and carries descriptive attributes such as SEGMENT_MAP_TYPE, SINGLE_VALUE, and PARENT_ROLLUP_VALUE, rather than acting as a pure hub or link. The foreign keys to GL_COA_MAPPINGS and FND_FLEX_VALUE_SETS suggest the table can be modeled as a satellite hanging off the COA mapping hub in a Data Vault representation.

Key Information Stored

The primary key is SEGMENT_MAP_ID, a NUMBER that uniquely identifies each consolidation segment map row. The documented unique index GL_CONS_SEGMENT_MAP_U1 enforces uniqueness on this single column, making it both the surrogate key and the only documented business-key candidate.

• SEGMENT_MAP_TYPE — Lookup code ('C', 'S', 'R', 'U', 'P', 'V') defining the rule category.
• COA_MAPPING_ID — Foreign key to GL_COA_MAPPINGS, tying the rule to a specific consolidation mapping definition.
• TO_VALUE_SET_ID / FROM_VALUE_SET_ID — Foreign keys to FND_FLEX_VALUE_SETS identifying the parent (target) and subsidiary (source) value sets.
• TO_APPLICATION_COLUMN_NAME / FROM_APPLICATION_COLUMN_NAME — VARCHAR2(30) column name of the parent and subsidiary segment, e.g. the balancing segment column.
• SINGLE_VALUE — VARCHAR2(25) parent ledger detail segment value used with the single value rule and rollup rules.
• PARENT_ROLLUP_VALUE — VARCHAR2(25) subsidiary ledger parent segment value used with Detail or Summary Parent rollup rules.
• CONSOLIDATION_ID_11I — Retained column no longer used in Release 12.
• Standard Who columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN support auditing and concurrent program tracking.
• ATTRIBUTE1–ATTRIBUTE5 and CONTEXT — Descriptive flexfield columns for client-specific extensions.

The non-unique index GL_CONS_SEGMENT_MAP_N1 covers COA_MAPPING_ID and TO_APPLICATION_COLUMN_NAME, optimizing lookups by mapping and target segment.

Common Use Cases and Queries

The most frequent access pattern is retrieving all rules attached to a given consolidation mapping, typically filtered by mapping identifier or by source/target column. A representative query:

SELECT m.segment_map_id, m.segment_map_type,
       m.from_application_column_name, m.to_application_column_name,
       m.single_value, m.parent_rollup_value
FROM   gl_cons_segment_map m
WHERE  m.coa_mapping_id = :p_mapping_id;

Consolidation administrators use this data to audit why a subsidiary segment value mapped to a particular parent value, especially when rollup rules produce unexpected aggregations. Reporting queries often join to FND_FLEX_VALUE_SETS to resolve the value set names and to GL_COA_MAPPINGS for mapping descriptions. Reconciliation extracts frequently pivot on SEGMENT_MAP_TYPE to separate copy rules from rollup rules. Because the table is low-volume and configuration-oriented, queries are rarely performance-sensitive; the N1 index supports mapping-scoped retrieval well.

Related Objects

GL_CONS_SEGMENT_MAP participates in several foreign key relationships that define its place in the consolidation schema:

• GL_COA_MAPPINGS — referenced via COA_MAPPING_ID; the parent mapping definition.
• FND_FLEX_VALUE_SETS — referenced twice, via TO_VALUE_SET_ID and FROM_VALUE_SET_ID, defining parent and subsidiary value sets.
• GL_CONSOLIDATION — referenced via the legacy CONSOLIDATION_ID_11I column.
• GL_CONS_FLEX_HIERARCHIES — references this table through SEGMENT_MAP_ID, capturing hierarchy detail associated with a segment map row.

Together these relationships anchor GL_CONS_SEGMENT_MAP as the rule-detail satellite of the consolidation mapping framework, linking chart-of-accounts mapping definitions to flex value sets and consolidation hierarchies.