Results for “gl_cons_set_assign_v”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

GL_CONS_SET_ASSIGN_V is an APPS-owned database view in the General Ledger (GL) module of Oracle E-Business Suite, valid in releases 12.1.1 and 12.2.2. It presents the assignment relationships that link consolidation definitions to consolidation sets, enriching the underlying assignment rows with descriptive and ledger-level information. Specifically, the view joins the consolidation set assignment table to the consolidation definition table and to the ledger table, and resolves the child consolidation set name and subsidiary ledger name for each assignment.

The view is intended for reporting, inquiry, and integration use rather than for transactional maintenance. Analysts and concurrent programs consume it to display which consolidation sets belong to a given consolidation, the descriptive text of the consolidation, and the ledger context from which the consolidation originates. Its inclusion of the CONSOLIDATION_DESCRIPTION column makes it a natural source for users who search on consolidation descriptions when identifying the correct consolidation or set assignment.

Underlying Base Objects

The view is defined over four documented base objects, three of which are synonyms to base tables and one a PL/SQL package referenced through a function call:

• GL_CONS_SET_ASSIGNMENTS (CSA) — the driving table, providing the core assignment rows, identifiers, audit columns, and the ATTRIBUTE1 through ATTRIBUTE15 descriptive flexfield columns.
• GL_CONSOLIDATION (CONS) — supplies the consolidation name and description; joined on CONSOLIDATION_ID.
• GL_LEDGERS (LEDGER) — supplies the subsidiary ledger identity; joined on FROM_LEDGER_ID to LEDGER_ID.
• GL_CONSOLIDATION_SETS (CST) — supplies the child consolidation set name and identifier; joined with an outer join on CHILD_CONSOLIDATION_SET_ID.
• GL_FC_XLATE_PKG — a package whose GET_LEDGER_NAME function resolves the subsidiary ledger name using the ledger name, ledger identifier, and the consolidation's FROM_CURRENCY_CODE.

The join conditions are: CSA.CONSOLIDATION_ID equals CONS.CONSOLIDATION_ID; CONS.FROM_LEDGER_ID equals LEDGER.LEDGER_ID; and CST.CONSOLIDATION_SET_ID is an outer-joined match to CSA.CHILD_CONSOLIDATION_SET_ID. Because the child set join is outer, assignments without a corresponding child set are still returned.

Key Columns

• ROW_ID — the ROWID of the underlying assignment row, useful for row-level identification.
• CONSOLIDATION_SET_ID — the consolidation set associated with the assignment.
• CONSOLIDATION_ID — the consolidation definition to which the set is assigned.
• CHILD_CONS_SET_NAME / CHILD_CONS_SET_ID — the name and identifier of the child consolidation set resolved from GL_CONSOLIDATION_SETS.
• CONSOLIDATION_NAME — the name of the consolidation definition.
• CONSOLIDATION_DESCRIPTION — the descriptive text of the consolidation, sourced from GL_CONSOLIDATION.DESCRIPTION.
• SUBSIDIARY_LEDGER_NAME / SUBSIDIARY_LEDGER_ID — the subsidiary ledger identity, with the name derived through GL_FC_XLATE_PKG.GET_LEDGER_NAME.
• CONTEXT and ATTRIBUTE1–ATTRIBUTE15 — descriptive flexfield context and segment values carried from the assignment table.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard audit columns.

Common Use Cases and Queries

Typical usage includes identifying assignments by consolidation description, listing child sets per consolidation, and reporting subsidiary ledger context for consolidation processing. A representative query retrieves assignments filtered by consolidation description:

• SELECT consolidation_name, consolidation_description, child_cons_set_name, subsidiary_ledger_name FROM gl_cons_set_assign_v WHERE consolidation_description LIKE :search_term;
• SELECT consolidation_id, consolidation_name, child_cons_set_id, child_cons_set_name FROM gl_cons_set_assign_v ORDER BY consolidation_name;
• SELECT subsidiary_ledger_name, COUNT(*) FROM gl_cons_set_assign_v GROUP BY subsidiary_ledger_name;

Because the view embeds a call to GL_FC_XLATE_PKG.GET_LEDGER_NAME, queries returning SUBSIDIARY_LEDGER_NAME incur per-row function execution; filtering on other columns first improves performance. The view is read-only in practice and should not be used as a target for DML.