Search Results gl_cons_set_assignments_u1

Overview

GL_CONS_SET_ASSIGNMENTS is a General Ledger consolidation table in Oracle E-Business Suite 12.1.1 and 12.2.2, owned by the GL schema and registered under FND Design Data as SQLGL.GL_CONS_SET_ASSIGNMENTS. It stores the individual consolidation mappings that make up the consolidation sets defined through the Consolidation Mapping Set form. Every mapping within a mapping set is materialized as exactly one row in this table, making it the operational backbone of the global consolidation engine that aggregates balances from multiple ledgers, subsidiaries, or consolidation hierarchies into a single parent result.

From a dimensional-modeling perspective, the table exhibits the characteristics of a link table. Its primary key is a composite of two foreign keys — CONSOLIDATION_SET_ID and CONSOLIDATION_ID — and it carries a third foreign key, CHILD_CONSOLIDATION_SET_ID, that enables hierarchical relationships between consolidation sets. The absence of a single surrogate identifier and the presence of multiple referenced hubs support the heuristic classification as a link, though this is offered as a modeling suggestion rather than a mandate for downstream design.

Key Information Stored

The most significant columns are the composite key members and the relationship pointers:

• CONSOLIDATION_SET_ID (NUMBER, 15) — the consolidation set defining column; identifies the parent mapping set to which this mapping belongs.
• CONSOLIDATION_ID (NUMBER, 15) — the consolidation identifier, pairing with the set identifier to form the unique business key.
• CHILD_CONSOLIDATION_SET_ID (NUMBER, 15) — the child consolidation set defining column, allowing a mapping to reference a nested consolidation set rather than a ledger-level source.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — the standard Who columns capturing row-level audit history.
• CONTEXT (VARCHAR2, 150) — the descriptive flexfield context discriminator.
• ATTRIBUTE1 through ATTRIBUTE15 (VARCHAR2, 150 each) — descriptive flexfield segments available for customer-defined consolidation mapping attributes.

The unique index GL_CONS_SET_ASSIGNMENTS_U1, defined over (CONSOLIDATION_SET_ID, CONSOLIDATION_ID) in the APPS_TS_TX_IDX tablespace, mirrors the primary key GL_CONS_SET_ASSIGNMENTS_PK and confirms the composite business key. There is no generated surrogate key column; identity is expressed entirely through the natural key pair.

Common Use Cases and Queries

Typical usage involves verifying that a consolidation set is fully populated, tracing which consolidation identifiers participate in a given set, and auditing hierarchy chains that involve child consolidation sets. A representative query lists all mappings for a set:

• SELECT consolidation_set_id, consolidation_id, child_consolidation_set_id FROM gl_cons_set_assignments WHERE consolidation_set_id = :p_set_id;
• Joining to GL_CONSOLIDATION_SETS on both CONSOLIDATION_SET_ID and CHILD_CONSOLIDATION_SET_ID exposes parent-child consolidation hierarchies.
• Joining to GL_CONSOLIDATION on CONSOLIDATION_ID resolves the descriptive attributes of each consolidation.
• Reporting on LAST_UPDATE_DATE supports change-tracking and audit of mapping maintenance activity.
• Descriptive flexfield columns (CONTEXT and ATTRIBUTE1–15) are queried when clients extend consolidation mappings with custom metadata.

Related Objects

The following objects are most relevant through primary and foreign key relationships:

• GL.GL_CONSOLIDATION_SETS — referenced by both CONSOLIDATION_SET_ID and CHILD_CONSOLIDATION_SET_ID.
• GL.GL_CONSOLIDATION — referenced by CONSOLIDATION_ID.
• The Consolidation Mapping Set form (GLXCONMS) — the primary user interface that inserts and maintains rows in this table.
• Consolidation and translation concurrent programs that read these mappings when executing consolidation sets.

Together these objects form the definition and execution pathway for General Ledger consolidation in EBS Release 12.