Results for “run_posting_flag”

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

Overview

GL_CONS_SET_NAMES_V is a General Ledger (GL) view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It presents a denormalized, security-aware listing of consolidation sets defined in the Oracle General Ledger consolidation workbench. A consolidation set identifies a source ledger, a target (parent) ledger, the consolidation method, and a collection of runtime options that govern how balances are transferred, summarized, and posted during a consolidation run.

The view is primarily consumed by consolidation setup forms, list-of-values queries, and reporting or integration components that must display the consolidation set name (cons_set_name) together with its target ledger and method without joining the underlying transaction tables directly. Because it embeds row-level data security through the FND_DATA_SECURITY package, it is the canonical read interface for consolidation set metadata within the EBS application tier.

Underlying Base Objects

The view is defined over four documented objects:

• GL_CONSOLIDATION_SETS (SYNONYM) — the driving table holding consolidation set definitions, including source/target ledger mapping, method code, and runtime flags. Aliased as CONS.
• GL_LEDGERS (SYNONYM) — the target ledger master, joined on CONS.TO_LEDGER_ID = LGR.LEDGER_ID. Supplies currency, calendar, period type, and the consolidation ledger flag. Aliased as LGR.
• GL_LOOKUPS (VIEW) — a lookup view restricted to LOOKUP_TYPE = 'CONSOLIDATION_METHOD', joined on LOOKUP_CODE = CONS.METHOD to resolve the method meaning. Aliased as L.
• FND_DATA_SECURITY (PACKAGE) and FND_GLOBAL (PACKAGE) — invoked in the SELECT list to evaluate per-user privileges against the consolidation set data security object.

No direct base table access is required by callers; the joins and security logic are encapsulated in the view definition.

Key Columns

• CONSOLIDATION_SET_ID — primary identifier of the consolidation set.
• CONS_SET_NAME — the consolidation set name, the column most commonly searched for by the term cons_set_name.
• DESCRIPTION — free-text description of the set.
• TO_LEDGER_ID / TO_LEDGER_NAME / TO_SHORT_NAME / TO_LEDGER_DESC — identifier and descriptive attributes of the target (parent) ledger.
• METHOD_CODE / METHOD_MEANING — consolidation method code and its translated lookup meaning.
• CURRENCY_CODE, CALENDAR, PERIOD_TYPE — target ledger accounting attributes.
• JOURNAL_IMPORT_FLAG, RUN_POSTING_FLAG, SUMMARIZE_LINES_FLAG, AUDIT_MODE_FLAG — runtime option flags, defaulted via NVL where null.
• CONS_LEDGER_FLAG, ADB_FLAG — target ledger characteristics (consolidation ledger indicator, average balances enabled).
• VIEW_PRIVILEGE, USE_PRIVILEGE, MODIFY_PRIVILEGE — security-evaluated flags ('Y'/'N') derived from FND_DATA_SECURITY for the current user.

Common Use Cases and Queries

Typical scenarios include LOV population during consolidation definition, dependency analysis when changing a target ledger, and migration or audit extracts. A common query to retrieve consolidation sets by name is:

• SELECT consolidation_set_id, cons_set_name, to_ledger_name, method_meaning, currency_code, calendar FROM gl_cons_set_names_v WHERE cons_set_name LIKE :search ORDER BY cons_set_name;
• Filtering by target ledger: SELECT cons_set_name, method_meaning FROM gl_cons_set_names_v WHERE to_ledger_id = :ledger_id;
• Security-limited listings that display only sets the current user may view: SELECT cons_set_name, view_privilege, use_privilege, modify_privilege FROM gl_cons_set_names_v WHERE view_privilege = 'Y';

Because the security columns depend on FND_GLOBAL and FND_DATA_SECURITY evaluated in the session context, queries should be executed after FND_GLOBAL.APPS_INITIALIZE in custom code paths.