Results for “gl_cons_map_set_v”

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

Overview

GL_CONS_MAP_SET_V is an APPS-owned view in the Oracle E-Business Suite General Ledger (GL) module. It exposes consolidation set definitions (formerly referenced in earlier releases as consolidation mappings) stored in the GL_CONSOLIDATION_SETS base table, joined to GL_LEDGERS to resolve the parent ledger name. The view presents consolidation sets in the context of their owning (parent) ledger, along with a full set of operational flags and descriptive attributes. Its principal role is to provide a single, security-aware source of consolidation set information for Oracle Forms, OAF pages, concurrent programs, and reporting or integration queries that need to identify target consolidation definitions by name.

Because the view exposes a column named CONSOLIDATION_SET_NAME, it is the primary object referenced when users or developers search for the "consolidation set name." The status is VALID in both 12.1.1 and 12.2.2, and the definition is consistent across those releases.

Underlying Base Objects

The view is defined over the following documented base objects:

• GL_CONSOLIDATION_SETS (SYNONYM) — the primary source table providing consolidation set identifiers, name, description, method, audit and journal import flags, security flag, and the DFF context and attribute columns.
• GL_LEDGERS (SYNONYM) — joined on TO_LEDGER_ID to supply the parent ledger name.
• FND_DATA_SECURITY (PACKAGE) — invoked via FND_DATA_SECURITY.CHECK_FUNCTION for the three privilege columns, enforcing data security on secured consolidation sets.
• FND_GLOBAL (PACKAGE) — invoked via FND_GLOBAL.USER_NAME to resolve the current user for the privilege checks.

The view fabricates one column, RUN_POSTING_FLAG, as a literal 'N', and applies NVL defaults (METHOD defaults to 'B', RUN_JOURNAL_IMPORT_FLAG and AUDIT_MODE_FLAG default to 'N'). SUMMARIZE_LINES_FLAG is forced to 'N' when journal import is not run.

Key Columns

• ROW_ID — the rowid of the base GL_CONSOLIDATION_SETS row.
• CONSOLIDATION_SET_ID — primary key of the consolidation set.
• CONSOLIDATION_SET_NAME — the consolidation set name; the most commonly queried human-readable identifier.
• PARENT_LEDGER_ID / PARENT_LEDGER_NAME — the owning ledger and its name.
• DESCRIPTION, CONTEXT, ATTRIBUTE1–ATTRIBUTE15 — descriptive text and descriptive flexfield columns.
• METHOD — consolidation method; defaults to 'B' when null.
• RUN_JOURNAL_IMPORT_FLAG, RUN_POSTING_FLAG, AUDIT_MODE_FLAG, SUMMARIZE_LINES_FLAG — consolidation run behavior flags.
• SECURITY_FLAG — indicates whether the set is security-enabled.
• VIEW_PRIVILEGE, USE_PRIVILEGE, MODIFY_PRIVILEGE — computed 'Y'/'N' privileges returned by FND_DATA_SECURITY, used to control access in secured environments.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — audit columns.

Common Use Cases and Queries

Typical uses include locating a consolidation set by name for maintenance, joining consolidation activity or balance transfer programs to the owning ledger, and filtering results by computed privileges so secured sets are hidden from unauthorized users.

Example — locate consolidation sets by name for a specific ledger:

SELECT consolidation_set_id,
       consolidation_set_name,
       parent_ledger_name,
       method,
       security_flag,
       view_privilege,
       use_privilege
FROM   apps.gl_cons_map_set_v
WHERE  consolidation_set_name LIKE :search_name
AND    parent_ledger_id = :p_ledger_id
ORDER BY consolidation_set_name;

Example — list all consolidation sets the current user may view or modify:

SELECT consolidation_set_name,
       parent_ledger_name,
       use_privilege,
       modify_privilege
FROM   apps.gl_cons_map_set_v
WHERE  view_privilege = 'Y';

Because access is governed by SECURITY_FLAG and FND_DATA_SECURITY, queries executed in a secured environment return only sets for which the current user holds the appropriate privilege, making the view safe to use directly in custom integrations and reports.