Search Results gl_consolidation_sets_u2

Overview

GL.GL_CONSOLIDATION_SETS is the General Ledger consolidation mapping set definition table in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the metadata for each consolidation set defined in the Consolidation Mapping Sets form. Each row represents a single consolidation set that maps a parent ledger to one or more subsidiary ledgers for consolidation. The table records the name of the consolidation mapping set, the ID of the parent (target) ledger, the consolidation method (Balances or Transactions), and the journal-import and posting options that govern how consolidation data is processed. A single row in GL_CONSOLIDATION_SETS has a one-to-many relationship with rows in GL_CONS_SET_ASSIGNMENTS, which holds the detailed mapping of subsidiary ledgers to the parent ledger within each set.

From a Data Vault modeling perspective, the table is best classified as hub-leaning based on its foreign-key structure. The primary key CONSOLIDATION_SET_ID serves as a stable business key for the consolidation set entity, while the majority of remaining columns are descriptive attributes that would map to a satellite in a Data Vault design. This distinction is heuristic and intended as a modeling suggestion rather than a prescriptive rule.

Key Information Stored

The table contains 31 documented columns, including the standard Who columns, a descriptive flexfield (CONTEXT plus ATTRIBUTE1 through ATTRIBUTE15), and functional configuration flags. The most significant columns are described below.

• CONSOLIDATION_SET_ID — Surrogate primary key (GL_CONSOLIDATION_SETS_PK) and the defining column for the consolidation set. Referenced by GL_CONS_SET_ASSIGNMENTS.CONSOLIDATION_SET_ID and GL_CONSOLIDATION_HISTORY.CONSOLIDATION_SET_ID.
• TO_LEDGER_ID — Ledger defining column for the parent ledger being consolidated to; foreign key to GL_SETS_OF_BOOKS_11I. One of the two columns in the GL_CONSOLIDATION_SETS_U2 unique business-key index.
• NAME — Consolidation set name (VARCHAR2(30)); the other column in the GL_CONSOLIDATION_SETS_U2 business-key index, together with TO_LEDGER_ID.
• METHOD — Consolidation method indicating whether the set consolidates Balances or Transactions.
• RUN_JOURNAL_IMPORT_FLAG — Controls whether Journal Import is executed automatically for the consolidated data.
• SUMMARIZE_LINES_FLAG — Determines whether Journal Import runs in summary mode.
• AUDIT_MODE_FLAG — Determines whether Journal Import runs in audit mode.
• RUN_POSTING_FLAG — Controls whether consolidation data is posted after journal import.
• SECURITY_FLAG — Indicates whether security is enforced against the consolidation set.
• DESCRIPTION — Consolidation set description (VARCHAR2(240)).
• CONTEXT and ATTRIBUTE1–ATTRIBUTE15 — Descriptive flexfield context and segments supporting user-defined attributes.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard Who columns supporting audit and concurrency tracking.

The surrogate key CONSOLIDATION_SET_ID is enumerated in the GL_CONSOLIDATION_SETS_U1 unique index, while the natural business identifier for a consolidation set is the combination of NAME and TO_LEDGER_ID, enforced by the GL_CONSOLIDATION_SETS_U2 unique index. Applications should treat NAME plus TO_LEDGER_ID as the meaningful lookup key and CONSOLIDATION_SET_ID as the technical join key.

Common Use Cases and Queries

GL_CONSOLIDATION_SETS is queried most often to list the consolidation sets defined for a given parent ledger, to identify the consolidation method or processing flags in force, or to drive reporting on consolidation configuration. A typical pattern joins to GL_SETS_OF_BOOKS_11I to resolve the parent ledger name:

• Retrieving all consolidation sets for a parent ledger: SELECT cs.CONSOLIDATION_SET_ID, cs.NAME, cs.METHOD, cs.DESCRIPTION FROM GL.GL_CONSOLIDATION_SETS cs WHERE cs.TO_LEDGER_ID = :ledger_id;
• Resolving a set by business key: SELECT CONSOLIDATION_SET_ID, METHOD, RUN_JOURNAL_IMPORT_FLAG FROM GL.GL_CONSOLIDATION_SETS WHERE NAME = :name AND TO_LEDGER_ID = :ledger_id;
• Enumerating the subsidiary mappings within a set: SELECT a.* FROM GL.GL_CONS_SET_ASSIGNMENTS a WHERE a.CONSOLIDATION_SET_ID = :set_id;
• Reviewing processing options for auditing: SELECT NAME, RUN_JOURNAL_IMPORT_FLAG, SUMMARIZE_LINES_FLAG, AUDIT_MODE_FLAG, RUN_POSTING_FLAG FROM GL.GL_CONSOLIDATION_SETS;

Reporting scenarios include configuration audits of consolidation mapping sets, verifying that the correct method (Balances versus Transactions) is applied to each parent ledger, and tracing consolidation history back to the set definition. Because the table is hub-leaning with a small, stable row count relative to transaction tables, it is well suited to direct joins rather than aggregation.

Related Objects

The following objects are the most significant dependencies and dependents of GL_CONSOLIDATION_SETS, based on documented foreign-key relationships.

• GL.GL_CONS_SET_ASSIGNMENTS — Child table holding the subsidiary-to-parent mappings for each set. Joins on CONSOLIDATION_SET_ID and CHILD_CONSOLIDATION_SET_ID.
• GL.GL_CONSOLIDATION_HISTORY — Records consolidation run history. Joins on CONSOLIDATION_SET_ID to identify the set used for each run.
• GL.GL_SETS_OF_BOOKS_11I — Referenced via TO_LEDGER_ID to resolve the parent ledger definition.
• GL_CONSOLIDATION_SETS_U1 — Unique index on CONSOLIDATION_SET_ID (primary key enforcement).
• GL_CONSOLIDATION_SETS_U2 — Unique business-key index on NAME and TO_LEDGER_ID; the object referenced by the searched term.
• SQLGL.GL_CONSOLIDATION_SETS — FND design data registration for the underlying schema object.

Together these objects form the consolidation configuration and execution chain in Oracle General Ledger, with GL_CONSOLIDATION_SETS acting as the central hub that ties ledger definitions to consolidation mappings and historical run records.