Search Results gl_consolidation




Overview
Explore in AI Chat

Overview

GL_CONSOLIDATION is a General Ledger (GL) table that stores consolidation definitions in Oracle E-Business Suite 12.1.1 and 12.2.2. Each row in this table represents a distinct consolidation configuration that determines how balances from one or more source (From) ledgers are transferred into a target (To) ledger. The table functions as the central definition repository for the GL Consolidation process, capturing the ledger pairing, the currency context, the consolidation method, account mapping rules, and the posting and audit behavior applied during the consolidation run.

From a data-modeling perspective, the metadata's heuristic Data Vault classification identifies GL_CONSOLIDATION as a hub. In that suggested model, CONSOLIDATION_ID serves as the hub key, with the From and To ledger identifiers as natural business keys within the consolidation domain. Because consolidation definitions are referenced by multiple dependent objects — accounts, batches, history, and mapping tables — the hub classification is a reasonable fit, though downstream implementers should note that the table also carries descriptive attributes such as NAME, DESCRIPTION, and METHOD that behave more like satellite content.

Key Information Stored

The table is owned by the GL schema and contains 29 documented columns. The most significant are summarized below.

  • CONSOLIDATION_ID — The surrogate primary key, enforced by GL_CONSOLIDATION_PK and reinforced by the unique index GL_CONSOLIDATION_U1. This is the column referenced by nearly every dependent object.
  • NAME — The consolidation definition name. It is a business-key candidate, enforced by the unique index GL_CONSOLIDATION_U2.
  • FROM_LEDGER_ID — Identifies the source ledger whose balances are consolidated. This is a foreign key referencing another ledger record.
  • TO_LEDGER_ID — Identifies the target ledger receiving the consolidated balances.
  • FROM_CURRENCY_CODE — The currency associated with the source side of the consolidation, with a foreign key to FND_CURRENCIES.
  • COA_MAPPING_ID — Foreign key to GL_COA_MAPPINGS, linking the definition to the chart-of-accounts mapping rules that govern how source accounts translate into target accounts.
  • METHOD — Indicates the consolidation method applied (for example, balance transfer or net income treatment).
  • RUN_JOURNAL_IMPORT_FLAG — Controls whether journal import is executed as part of the consolidation run.
  • RUN_POSTING_FLAG — Controls whether posting is performed automatically after consolidation.
  • SUMMARIZE_LINES_FLAG — Determines whether consolidated journal lines are summarized or retained at detail level.
  • AUDIT_MODE_FLAG — Governs whether audit records are captured during processing.
  • SECURITY_FLAG — Controls security-related behavior of the consolidation definition.
  • USAGE_CODE — Classifies the usage context of the definition.
  • START_DATE_ACTIVE_11I / END_DATE_ACTIVE_11I — Define the active date range for the definition.
  • LAST_UPDATE_DATE, CREATED_BY, LAST_UPDATED_BY, CREATION_DATE — Standard EBS audit columns maintained by the application.

Common Use Cases and Queries

Typical use cases include identifying all consolidation definitions associated with a given ledger pair, reporting on active versus expired definitions, and troubleshooting consolidation runs. A representative query lists definitions with their ledger and currency context:

  • SELECT c.consolidation_id, c.name, c.from_ledger_id, c.to_ledger_id, c.from_currency_code, c.method FROM gl_consolidation c WHERE c.to_ledger_id = :ledger_id;
  • SELECT c.name, c.method FROM gl_consolidation c WHERE c.start_date_active_11i <= SYSDATE AND NVL(c.end_date_active_11i, SYSDATE) >= SYSDATE;
  • SELECT c.name, a.consolidation_id FROM gl_consolidation c JOIN gl_consolidation_accounts a ON a.consolidation_id = c.consolidation_id WHERE c.name = :name;

Reporting scenarios commonly join GL_CONSOLIDATION to GL_CONSOLIDATION_HISTORY to review prior runs, and to GL_CONS_BATCHES to inspect the batches generated by each consolidation execution.

Related Objects

GL_CONSOLIDATION is referenced by several dependent tables through the CONSOLIDATION_ID foreign key. The most significant are:

  • GL_CONSOLIDATION_ACCOUNTS — Holds the account ranges or mappings tied to a consolidation definition (CONSOLIDATION_ID).
  • GL_CONSOLIDATION_HISTORY — Records execution history for each definition (CONSOLIDATION_ID).
  • GL_CONSOLIDATION_AUDIT — Stores audit records generated when the audit flag is set (CONSOLIDATION_ID).
  • GL_CONS_BATCHES — Tracks the consolidation batches created by a run (CONSOLIDATION_ID).
  • GL_CONS_FLEXFIELD_MAP / GL_CONS_SEGMENT_MAP — Provide legacy flexfield and segment mapping rules linked via CONSOLIDATION_ID_11I.
  • GL_CONS_SET_ASSIGNMENTS — Assigns consolidation sets to definitions (CONSOLIDATION_ID).
  • GL_COA_MAPPINGS — The referenced parent of COA_MAPPING_ID, supplying chart-of-accounts mapping rules.
  • FND_CURRENCIES — The referenced parent of FROM_CURRENCY_CODE, supplying currency code validation.

These relationships confirm that GL_CONSOLIDATION acts as the hub from which all consolidation execution, mapping, and audit data derives.