Search Results gl_consolidation_u2

Overview

GL.GL_CONSOLIDATION is the consolidation definition table in the Oracle General Ledger (GL) module of Oracle E-Business Suite 12.1.1 and 12.2.2. It stores one row for each consolidation mapping defined within a ledger set, defining the relationship between a subsidiary (source) ledger and a parent (target) ledger, and capturing the method and currency in which consolidation is performed. The table corresponds to the first window of the Consolidation Mappings form in the GL application, and rows created here drive all downstream consolidation processing, including account and segment mappings, batch execution, and audit trails.

From a heuristic Data Vault perspective, GL_CONSOLIDATION classifies as a hub. Its primary key, CONSOLIDATION_ID, acts as the durable business identifier, while foreign keys to ledger tables and FND_CURRENCIES anchor it to other reference hubs. This classification suggests the table is best understood as a central entity around which consolidation-related satellites and links (accounts, batches, history, and audit rows) accumulate.

Key Information Stored

The table contains 29 documented columns; the most operationally significant are listed below.

• CONSOLIDATION_ID — Surrogate primary key (GL_CONSOLIDATION_PK) and consolidation defining column.
• NAME — Consolidation mapping name; unique index GL_CONSOLIDATION_U2 enforces a business-key uniqueness constraint.
• FROM_LEDGER_ID — Subsidiary (source) ledger defining column.
• TO_LEDGER_ID — Parent (target) ledger defining column; indexed non-uniquely via GL_CONSOLIDATION_N1.
• METHOD — Lookup indicating 'B' (Balances) or 'T' (Transactions).
• USAGE_CODE — Consolidation usage: Standard, Average, or Standard & Average.
• FROM_CURRENCY_CODE — Subsidiary currency (ledger currency or STAT); FK to FND_CURRENCIES.
• DESCRIPTION — Free-text consolidation description (240 characters).
• RUN_JOURNAL_IMPORT_FLAG — Controls whether journal import runs during consolidation.
• SUMMARIZE_LINES_FLAG — Indicates summary-mode journal import.
• AUDIT_MODE_FLAG — Indicates audit-mode journal import.
• RUN_POSTING_FLAG — Controls posting behavior during consolidation.
• COA_MAPPING_ID — FK to GL_COA_MAPPINGS, linking the consolidation to its chart-of-accounts mapping.
• SECURITY_FLAG — Governs row-level security behavior.
• LAST_UPDATE_DATE / LAST_UPDATED_BY — Standard Who audit columns.

The columns START_DATE_ACTIVE_11I, END_DATE_ACTIVE_11I, FROM_LOCATION, and FROM_ORACLE_ID are retained for historical compatibility but are documented as no longer used in Release 12.

Common Use Cases and Queries

Typical reporting activity centers on identifying the source and target ledgers for each mapping and validating method, currency, and mapping configuration before executing a consolidation batch.

• List all consolidation mappings and their ledger pairs:

  SELECT c.consolidation_id, c.name, c.method, c.usage_code,
         c.from_ledger_id, c.to_ledger_id, c.from_currency_code
  FROM   gl_consolidation c
  ORDER  BY c.name;

• Find mappings targeting a specific parent ledger:

  SELECT consolidation_id, name, from_ledger_id, method
  FROM   gl_consolidation
  WHERE  to_ledger_id = :p_parent_ledger_id;

• Validate a mapping by business key (uses GL_CONSOLIDATION_U2):

  SELECT * FROM gl_consolidation WHERE name = :p_name;

• Inspect journal import and posting behavior flags:

  SELECT name, run_journal_import_flag, summarize_lines_flag,
         audit_mode_flag, run_posting_flag
  FROM   gl_consolidation;

These queries are commonly embedded in consolidation runbooks, CEMLI extensions, and reconciliation reports that trace source-ledger balances through to parent-ledger results.

Related Objects

GL_CONSOLIDATION is referenced by numerous downstream tables through the CONSOLIDATION_ID column, and it references several reference entities.

• GL_CONSOLIDATION_ACCOUNTS.CONSOLIDATION_ID — Account-level mapping rules for each consolidation.
• GL_CONS_BATCHES.CONSOLIDATION_ID — Batch execution records created when a consolidation is run.
• GL_CONSOLIDATION_HISTORY.CONSOLIDATION_ID — Historical consolidation results.
• GL_CONSOLIDATION_AUDIT.CONSOLIDATION_ID — Audit records per consolidation run.
• GL_CONS_SET_ASSIGNMENTS.CONSOLIDATION_ID — Ledger set assignments driving the scope of consolidation.
• GL_CONS_FLEXFIELD_MAP.CONSOLIDATION_ID_11I — Flexfield mapping entries (legacy 11i linkage).
• GL_CONS_SEGMENT_MAP.CONSOLIDATION_ID_11I — Segment-level mapping entries (legacy 11i linkage).
• GL_COA_MAPPINGS — Referenced via COA_MAPPING_ID for the chart-of-accounts mapping.
• FND_CURRENCIES — Referenced via FROM_CURRENCY_CODE.

Together these relationships establish GL_CONSOLIDATION as the hub through which every consolidation run, mapping rule, and audit record is anchored.