Search Results gl_consolidation_sets




Overview
Explore in AI Chat

Overview

GL_CONSOLIDATION_SETS is a General Ledger (GL) table in the Oracle E-Business Suite (12.1.1 / 12.2.2) that stores consolidation set definitions. A consolidation set is a user-defined grouping that instructs the Consolidation program how to transfer balances from one or more subsidiary ledgers into a single target (parent) ledger. Each row in this table represents one consolidation set, together with the run-time options that control how the consolidation is performed. The table is therefore central to multi-company and multi-ledger reporting environments, where the balances of several operating ledgers must be combined into a reporting or statutory ledger.

The table carries the schema owner GL and is documented with a primary key, GL_CONSOLIDATION_SETS_PK, on the surrogate column CONSOLIDATION_SET_ID. Heuristic Data Vault classification mined from the foreign-key structure places this object as hub-leaning: it is a durable, non-transactional definition entity whose key is referenced by surrounding fact and assignment structures. In Data Vault terms it is best modeled as a hub, with descriptive attributes that could be split into a satellite if the model were normalized further.

Key Information Stored

Although 31 columns are documented, the following are the most significant for understanding and querying the object:

  • CONSOLIDATION_SET_ID — the surrogate primary key (GL_CONSOLIDATION_SETS_PK) that uniquely identifies each consolidation set; also the target of foreign keys from dependent tables.
  • NAME — the user-facing name of the consolidation set. Together with TO_LEDGER_ID, it forms the business-key candidate GL_CONSOLIDATION_SETS_U2 (NAME, TO_LEDGER_ID), meaning a set name must be unique within a target ledger. A second unique index, GL_CONSOLIDATION_SETS_U1, enforces the surrogate key.
  • TO_LEDGER_ID — the target (parent) ledger into which balances are consolidated. This is a foreign key to GL_SETS_OF_BOOKS_11I.
  • METHOD — the consolidation method applied when transferring balances (for example, balance-level or journal-level consolidation).
  • DESCRIPTION — free-text description of the consolidation set for administrators and report authors.
  • RUN_JOURNAL_IMPORT_FLAG — indicates whether the Journal Import process is executed as part of the consolidation run.
  • RUN_POSTING_FLAG — indicates whether the resulting journals are posted automatically.
  • SUMMARIZE_LINES_FLAG — controls whether consolidation journal lines are summarized before transfer.
  • AUDIT_MODE_FLAG — governs whether audit-level detail is retained during consolidation.
  • SECURITY_FLAG — indicates whether the consolidation set participates in the security/access model.
  • CONSOLIDATION_SET_ID, NAME, and the audit columns CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN provide standard Oracle EBS who/when tracking.
  • CONTEXT and ATTRIBUTE1 through ATTRIBUTE15 are the standard descriptive-flexfield columns available for client-specific extensions.

Common Use Cases and Queries

Typical usage centers on configuration reporting and dependency analysis. A common query lists all consolidation sets and their target ledgers:

SELECT cs.consolidation_set_id, cs.name, cs.method, cs.to_ledger_id, sob.name ledger_name
FROM gl_consolidation_sets cs, gl_sets_of_books_11i sob
WHERE cs.to_ledger_id = sob.ledger_id;
ORDER BY sob.name, cs.name;

Administrators frequently search by business key to confirm uniqueness before creating a new set:

SELECT consolidation_set_id, name, to_ledger_id
FROM gl_consolidation_sets
WHERE name = :p_name AND to_ledger_id = :p_ledger_id;

Because the table is referenced by both history and assignment tables, it is also common to audit which sets have been run or which child sets are mapped to a parent. Reporting use cases include generating a catalog of consolidation definitions for SOX/audit evidence, verifying that all subsidiary ledgers roll into an expected parent ledger, and reviewing the flag options (Journal Import, posting, summarize, audit) to ensure consistent run-time behavior across the enterprise.

Related Objects

The metadata identifies the following documented relationships, all joined on CONSOLIDATION_SET_ID unless noted:

  • GL_SETS_OF_BOOKS_11I — referenced through TO_LEDGER_ID; supplies the target ledger name for the consolidation set.
  • GL_CONSOLIDATION_HISTORY — references CONSOLIDATION_SET_ID; records each execution of a consolidation set, providing run-level audit history.
  • GL_CONS_SET_ASSIGNMENTS — references CONSOLIDATION_SET_ID and CHILD_CONSOLIDATION_SET_ID; defines the parent/child relationships between consolidation sets, allowing hierarchical or multi-level consolidation definitions.
  • Consolidation and journal import/posting concurrent programs — these consume the flag columns (RUN_JOURNAL_IMPORT_FLAG, RUN_POSTING_FLAG, SUMMARIZE_LINES_FLAG, AUDIT_MODE_FLAG) at run time to determine processing behavior.

Together, these objects form the definitional and historical footprint of the consolidation feature in Oracle General Ledger.