Results for “gl_das_elimination_set_v”

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

Overview

APPS.GL_ELIM_SET_HISTORY_V is a General Ledger (GL) reporting and integration view that exposes the definition and execution history of elimination sets configured within Oracle E-Business Suite. An elimination set groups the balancing and elimination rules used to remove intercompany and intragroup balances when consolidated financial results are produced. The view presents one row per elimination set, joined to its owning ledger, together with the last period in which the set was executed and the standard WHO audit columns. Because it is defined only over synonyms and packaged functions, the view is a read-only, security-aware projection rather than a stored entity.

The view is closely associated with the DAS (Data Access Set) security model. Two derived columns, VIEW_PRIVILEGE and USE_PRIVILEGE, call FND_DATA_SECURITY.CHECK_FUNCTION and FND_GLOBAL.USER_NAME to determine, for the current user, whether the set may be viewed or executed. Users searching for gl_das_elimination_set_v are typically working with the same elimination-set definition from a Data Access Set perspective; GL_ELIM_SET_HISTORY_V complements that object by surfacing execution history and audit context. Both are consumed in consolidation and reporting workflows.

Underlying Base Objects

Per the documented ETRM metadata, the view is owned by APPS and is defined over the following referenced objects:

• GL_ELIMINATION_SETS (SYNONYM) — the primary source, supplying elimination set identity, name, ledger, security flag, last executed period, and audit columns.
• GL_LEDGERS (SYNONYM) — joined on LEDGER_ID to resolve the ledger name.
• FND_DATA_SECURITY (PACKAGE) — provides CHECK_FUNCTION, used to evaluate view and use privileges against the GL_DAS_ELIMINATION_SET and GL_DAS_ELIMINATION_SET_U functions.
• FND_GLOBAL (PACKAGE) — supplies the current USER_NAME passed into the privilege check.

The defining query is a simple inner join: FROM gl_elimination_sets els, gl_ledgers gl WHERE gl.ledger_id = els.ledger_id. Consequently, an elimination set whose ledger does not resolve in GL_LEDGERS will not appear.

Key Columns

• ELIMINATION_SET_ID — Primary identifier of the elimination set.
• NAME — User-defined name of the elimination set.
• LEDGER_ID / LEDGER_NAME — The ledger that owns the set; the name is resolved via GL_LEDGERS.
• LAST_EXECUTED_PERIOD — The most recent accounting period in which the elimination set was run, forming the core of the view's "history" purpose.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard audit (WHO) columns inherited from GL_ELIMINATION_SETS.
• VIEW_PRIVILEGE — Evaluates to Y when the set's SECURITY_FLAG is not Y, or when the current user passes the GL_DAS_ELIMINATION_SET_V function check; otherwise N.
• USE_PRIVILEGE — Equivalent evaluation against GL_DAS_ELIMINATION_SET_U, indicating whether the user may execute the set.

Common Use Cases and Queries

The view is typically used to audit when elimination sets were last run, to report set ownership by ledger, and to drive security-filtered pick lists in consolidation or intercompany workflows. A representative query lists sets for a ledger with their execution period:

• SELECT elimination_set_id, name, ledger_name, last_executed_period FROM apps.gl_elim_set_history_v WHERE ledger_id = :p_ledger_id ORDER BY name;
• SELECT name, ledger_name, last_update_date FROM apps.gl_elim_set_history_v WHERE view_privilege = 'Y' AND last_executed_period IS NOT NULL;
• SELECT name, ledger_name FROM apps.gl_elim_set_history_v WHERE use_privilege = 'Y';

Because the privilege columns depend on FND_GLOBAL.USER_NAME, results are automatically scoped to the connecting user's Data Access Set and function grants, making the view suitable for use within concurrent programs and OAF-based inquiry pages without additional row-level filtering.