Search Results gl_cons_flexfield_map_u1

Overview

GL.GL_CONS_FLEXFIELD_MAP is a General Ledger consolidation mapping table in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the account rules defined when a consolidation mapping is created, capturing ranges of child (subsidiary) accounts and the corresponding parent account to which they consolidate. Each row corresponds to an entry in the Account Rules window of the Consolidation Mappings form, making the table the persisted form of user-defined rollup logic used during consolidation and translation processing.

The table resides in the APPS_TS_TX_DATA tablespace with PCTFREE 10 and is owned by the GL schema under FND Design Data SQLGL.GL_CONS_FLEXFIELD_MAP. It is classified as VALID. From a Data Vault modeling perspective, the metadata suggests a link classification: the table connects consolidation definitions and parent accounts to ranges of child account combinations, expressing relationships rather than serving as a standalone hub or descriptive satellite.

Key Information Stored

The primary surrogate key is FLEXFIELD_MAP_ID, enforced by the unique index GL_CONS_FLEXFIELD_MAP_U1. This column is the documented business-key candidate and is also the table's primary key (GL_CONS_FLEXFIELD_MAP_PK). The most significant columns include:

• FLEXFIELD_MAP_ID — surrogate primary key and unique identifier for each mapping rule row.
• COA_MAPPING_ID — foreign key to GL_COA_MAPPINGS, linking the rule to its parent consolidation mapping definition; indexed non-uniquely via GL_CONS_FLEXFIELD_MAP_N1.
• TO_CODE_COMBINATION_ID — foreign key to GL_CODE_COMBINATIONS, identifying the parent key flexfield account that the child range maps to.
• CONSOLIDATION_ID_11I — legacy consolidation identifier referenced in prior releases; documented as no longer used in R12.
• SEGMENT1_LOW through SEGMENT30_HIGH — low/high range columns for each key flexfield segment, defining the child account range captured by the rule. Only segments actively used in the chart of accounts are typically populated.
• ATTRIBUTE1 through ATTRIBUTE5 and CONTEXT — descriptive flexfield (DFF) columns enabling extensible rule attributes.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard Who columns for audit and concurrency tracking.

The documented physical schema contains 75 columns, reflecting the wide segment-range design that supports charts of accounts with up to 30 segments.

Common Use Cases and Queries

Typical scenarios include auditing consolidation mapping rules, validating that child account ranges roll up to the correct parent account, and extracting rules for reconciliation or migration. A representative query joins the map to its parent mapping and parent account:

• Retrieve all rules for a mapping: SELECT f.FLEXFIELD_MAP_ID, f.COA_MAPPING_ID, f.TO_CODE_COMBINATION_ID FROM GL_CONS_FLEXFIELD_MAP f WHERE f.COA_MAPPING_ID = :mapping_id;
• Resolve the parent account description: join TO_CODE_COMBINATION_ID to GL_CODE_COMBINATIONS to display the target account.
• Audit segment ranges: select the SEGMENTn_LOW and SEGMENTn_HIGH pairs to verify the range boundaries defined for each child account segment.
• Reporting: extract all mappings and their parent accounts for consolidation documentation or SOX control evidence.

Because the table is keyed by FLEXFIELD_MAP_ID and indexed on COA_MAPPING_ID, queries filtered by mapping perform efficiently, while range-based analysis scans the segment low/high columns.

Related Objects

The following objects have the most significant documented relationships with GL_CONS_FLEXFIELD_MAP:

• GL.GL_COA_MAPPINGS — referenced via COA_MAPPING_ID; the parent consolidation mapping definition that owns each rule set.
• GL.GL_CODE_COMBINATIONS — referenced via TO_CODE_COMBINATION_ID; supplies the parent account that child ranges map to.
• GL.GL_CONSOLIDATION — referenced via the legacy CONSOLIDATION_ID_11I column, retained for backward compatibility though unused in R12.
• Consolidation Mappings form and consolidation programs — read and maintain rows in this table when defining and executing consolidation rollups.
• GL_CONS_FLEXFIELD_MAP_PK, GL_CONS_FLEXFIELD_MAP_U1, GL_CONS_FLEXFIELD_MAP_N1 — the primary key constraint and supporting unique/non-unique indexes that govern access paths.

Together these relationships position the table as the rule-level detail underlying Oracle General Ledger consolidation mappings.