Search Results gl_segment_map_cons_v




Overview
Explore in AI Chat

Overview

GL_SEGMENT_MAP_CONS_V is a consolidated General Ledger view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It exposes segment-level mapping definitions used by the General Ledger Consolidation process, presenting one row per segment mapping rule together with the chart of accounts context inherited from its parent chart of accounts mapping. The view denormalizes the relationship between GL_CONS_SEGMENT_MAP and GL_COA_MAPPINGS so that consumers can read segment map attributes alongside the source and target chart of accounts identifiers in a single query.

Its principal role is reporting and integration. Consolidation setups frequently require verification that each segment-level mapping rule is bound to the correct source and target chart of accounts. Because the base table GL_CONS_SEGMENT_MAP stores only COA_MAPPING_ID, joining to GL_COA_MAPPINGS is mandatory to resolve chart of accounts identity. This view performs that join internally and, critically, aliases the columns as FROM_CHART_OF_ACCOUNTS_ID and TO_CHART_OF_ACCOUNTS_ID. The to_chart_of_accounts_id column exposed by this view is therefore the resolved target chart of accounts for consolidation segment mapping — the value users most often search for when tracing consolidation output back to its target ledger configuration.

Underlying Base Objects

The view is defined over two documented base objects, both referenced through APPS synonyms:

  • GL_CONS_SEGMENT_MAP (aliased GLSM) — the driving table containing individual segment mapping rows, including segment map type, mapping identifiers, from/to application column names, from/to value set identifiers, single value flags, descriptive flexfield attributes, context, and parent rollup value.
  • GL_COA_MAPPINGS (aliased MAP) — the chart of accounts mapping header, supplying FROM_COA_ID and TO_COA_ID.

The join condition is MAP.COA_MAPPING_ID = GLSM.COA_MAPPING_ID, an inner join that returns only segment maps whose parent chart of accounts mapping exists. In the documented 12.2.2 metadata both referenced objects are exposed as synonyms under APPS. Because the underlying tables are date-tracked and audited, the view surfaces LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN directly from GL_CONS_SEGMENT_MAP.

Key Columns

  • SEGMENT_MAP_ID — primary identifier of the segment mapping row.
  • SEGMENT_MAP_TYPE — classifies the mapping rule within the consolidation definition.
  • COA_MAPPING_ID — foreign key linking the segment map to its chart of accounts mapping header.
  • FROM_CHART_OF_ACCOUNTS_ID / TO_CHART_OF_ACCOUNTS_ID — the source and target chart of accounts resolved from GL_COA_MAPPINGS; to_chart_of_accounts_id is the frequently queried target identifier.
  • FROM_VALUE_SET_ID / TO_VALUE_SET_ID — value sets governing source and target segment values.
  • FROM_APPLICATION_COLUMN_NAME / TO_APPLICATION_COLUMN_NAME — the application columns being mapped.
  • SINGLE_VALUE — indicates whether the mapping resolves to a single target value.
  • PARENT_ROLLUP_VALUE — rollup value applied to the parent segment relationship.
  • ATTRIBUTE1–ATTRIBUTE5, CONTEXT — descriptive flexfield segments.
  • ROW_ID — the ROWID of the underlying segment map row, supporting updatable or row-identified access.

Common Use Cases and Queries

Typical scenarios include validating consolidation mappings before a period close, auditing which target chart of accounts a segment map feeds, and comparing source and target value sets across a mapping set.

  • List all segment maps for a given target chart of accounts: 
    SELECT segment_map_id, coa_mapping_id, to_chart_of_accounts_id
FROM   gl_segment_map_cons_v
WHERE  to_chart_of_accounts_id = :p_coa_id;
  • Retrieve full mapping detail joined to value sets and rollup values: 
    SELECT segment_map_id, segment_map_type,
       from_chart_of_accounts_id, to_chart_of_accounts_id,
       from_value_set_id, to_value_set_id,
       single_value, parent_rollup_value
FROM   gl_segment_map_cons_v
WHERE  coa_mapping_id = :p_mapping_id;
  • Audit recently modified segment maps: 
    SELECT segment_map_id, last_update_date, last_updated_by
FROM   gl_segment_map_cons_v
WHERE  last_update_date >= :p_since_date
ORDER  BY last_update_date DESC;

Because the view is read-only and consolidates the mandatory join, it is suitable for both ad hoc diagnosis and embedded use in consolidation reconciliation reports.