Results for “last_executed_period”

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

Overview

The GL_ELIM_SET_HISTORY_V view is a General Ledger (GL) data security view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It exposes elimination set definitions from the General Ledger module together with derived privilege flags that determine whether the currently connected user may view or execute a given elimination set. Elimination sets are used in the GL consolidation and elimination workflow, where intercompany and intracompany balances are automatically offset and eliminated at period close. This view provides a secure, user-context-aware projection of that metadata for reporting, integration, and OAF-based inquiry pages.

The view is closely related to GL_DAS_ELIMINATION_SET_V, the term for which the user searched. Both views originate from the same underlying elimination set data; GL_DAS_ELIMINATION_SET_V is referenced directly in the view definition as the data security function argument name, indicating that the two views participate in the same Data Access Security (DAS) framework for elimination sets. Functionally, GL_ELIM_SET_HISTORY_V extends the base projection by exposing execution history metadata (the last executed period) and per-row view/use privileges.

Underlying Base Objects

The view text joins two APPS synonyms and invokes two APPS packages. The primary source table is GL_ELIMINATION_SETS (aliased ELS), which stores the elimination set definitions, security flags, and audit columns. It is joined to GL_LEDGERS (aliased GL) on GL.LEDGER_ID = ELS.LEDGER_ID to resolve the ledger name associated with each elimination set. The packages FND_DATA_SECURITY and FND_GLOBAL are invoked within the SELECT list rather than in the FROM clause. FND_GLOBAL.USER_NAME supplies the current application user, which is passed into FND_DATA_SECURITY.CHECK_FUNCTION to evaluate row-level access against the security flag on each elimination set. This design makes the view a dynamic, security-aware wrapper rather than a simple stored join.

Key Columns

• ELIMINATION_SET_ID — Primary identifier for the elimination set.
• NAME — User-defined name of the elimination set.
• LEDGER_ID / LEDGER_NAME — The ledger to which the elimination set belongs, resolved from GL_LEDGERS.
• LAST_EXECUTED_PERIOD — The most recent GL period in which the elimination set was run, enabling history and status reporting.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns inherited from GL_ELIMINATION_SETS.
• VIEW_PRIVILEGE — Evaluated via CHECK_FUNCTION against GL_DAS_ELIMINATION_SET_V and GL_DAS_ELIMINATION_SET; returns 'Y' when the user may view the set. When SECURITY_FLAG is not 'Y', the privilege defaults to 'Y'.
• USE_PRIVILEGE — Evaluated similarly against GL_DAS_ELIMINATION_SET_U; returns 'Y' when the user may execute or use the set.

Common Use Cases and Queries

Because privileges are computed per row, this view is ideal for security-filtered inquiry pages, personalized reports, and integration extracts. A typical query lists only elimination sets the current user may view:

SELECT elimination_set_id, name, ledger_name,
       last_executed_period, view_privilege, use_privilege
FROM   apps.gl_elim_set_history_v
WHERE  view_privilege = 'Y'
ORDER  BY ledger_name, name;

A narrower query for sets that may be executed returns only those with USE_PRIVILEGE = 'Y', useful for restricting a concurrent program's parameter list of elimination sets. To audit execution history across ledgers, administrators select NAME, LEDGER_NAME, and LAST_EXECUTED_PERIOD, filtering by LEDGER_ID. Note that, as an APPS-owned view, it must be referenced via the APPS schema or an appropriate synonym, and its privilege columns depend on the FND security context in effect at query time.