Search Results gl_cons_flexfield_map_pk

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:

• FLEXFIELD_MAP_ID — the surrogate primary key, enforced by GL_CONS_FLEXFIELD_MAP_PK and also by the unique index GL_CONS_FLEXFIELD_MAP_U1.
• CONSOLIDATION_ID_11I — foreign key to GL_CONSOLIDATION, identifying the consolidation definition to which the mapping rule belongs.
• TO_CODE_COMBINATION_ID — foreign key to GL_CODE_COMBINATIONS, identifying the target account combination that balances are mapped into.
• COA_MAPPING_ID — foreign key to GL_COA_MAPPINGS, linking the rule to the chart of accounts mapping that governs the transfer between ledgers.
• SEGMENT1_LOW through SEGMENT30_HIGH — sixty columns that capture the low and high range value for each accounting flexfield segment, defining the source account range the rule applies to.
• ATTRIBUTE1 through ATTRIBUTE5 and CONTEXT — descriptive flexfield columns supporting user-defined attributes on the mapping rule.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — the standard Oracle EBS auditing columns.

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.