Search Results gl_cons_flexfield_map




Overview
Explore in AI Chat

Overview

GL_CONS_FLEXFIELD_MAP is a General Ledger consolidation table that stores the account mapping rules used to translate subsidiary account balances into the parent ledger's chart of accounts. It is owned by the GL schema and is classified as VALID within the Oracle E-Business Suite data model. The table plays a central role in the consolidation workflow, where balances from one or more subsidiary ledgers are remapped, converted, and merged into a consolidating (parent) ledger. Each row defines a mapping rule that associates a consolidation definition with a target code combination, along with the low and high ranges for each accounting flexfield segment.

From a heuristic Data Vault modeling perspective, mined from the foreign key structure, this object is best classified as a link. It resolves and enriches the relationship between a consolidation definition (GL_CONSOLIDATION) and a chart of accounts mapping (GL_COA_MAPPINGS), while targeting specific GL_CODE_COMBINATIONS rows. It is not a hub, because it carries no independent business concept of its own, and it is not purely a satellite, because it participates directly in the foreign key relationships that connect those entities.

Key Information Stored

The table is physically defined with 75 columns in the documented 12.2.2 schema. The most significant of these are:

The surrogate key FLEXFIELD_MAP_ID is the only documented unique business-key candidate; the segment range columns are descriptive qualifiers rather than a natural unique key.

Common Use Cases and Queries

Typical uses include auditing consolidation mappings, validating coverage of subsidiary account ranges, and reporting on unmapped balances. A representative query joins the table to its parent consolidation and target account:

  • List all mapping rules for a consolidation definition: SELECT FLEXFIELD_MAP_ID, TO_CODE_COMBINATION_ID, COA_MAPPING_ID FROM GL_CONS_FLEXFIELD_MAP WHERE CONSOLIDATION_ID_11I = :p_cons_id;
  • Resolve the target account name: join TO_CODE_COMBINATION_ID to GL_CODE_COMBINATIONS to retrieve CONCATENATED_SEGMENTS.
  • Detect overlapping or missing segment ranges by grouping on SEGMENTn_LOW and SEGMENTn_HIGH for a given consolidation.
  • Verify mapping integrity by left-joining GL_COA_MAPPINGS on COA_MAPPING_ID to find orphaned rules.

Reporting extracts commonly feed reconciliation dashboards and consolidation audit reports.

Related Objects

  • GL_CONSOLIDATION — joined on CONSOLIDATION_ID_11I; the parent consolidation definition.
  • GL_CODE_COMBINATIONS — joined on TO_CODE_COMBINATION_ID; the target account combination.
  • GL_COA_MAPPINGS — joined on COA_MAPPING_ID; the chart of accounts mapping rules.
  • GL_CONS_FLEXFIELD_MAP_PK / _U1 — primary key and unique index on FLEXFIELD_MAP_ID.
  • Consolidation programs and the GL Consolidation workbench, which read this table when transferring and merging balances.