Search Results get_period

Overview

APPS.GL_CONS_WRK_PKG is a PL/SQL package in the Oracle E-Business Suite General Ledger module that supports the consolidation workbench and elimination workflow. Consolidation in General Ledger involves combining the balances of multiple subsidiary ledgers into a parent ledger, applying translation and elimination entries, and tracking the resulting history. This package functions as a supporting work utility within that process rather than a public API. In ETRM it is classified as OTHER, indicating that it is an internal or utility package not exposed as a formally published interface. Its status is VALID, confirming that the package and its body compile and are present in the APPS schema.

The package is closely bound to consolidation history and elimination history views. It is referenced by APPS.GL_CONSOLIDATION_HISTORY_V and APPS.GL_ELIMINATION_HISTORY_V, meaning these views depend on the package for the data or logic they expose to consolidation inquiry screens and reports. Two other packages also reference it, indicating that it is a lower-level building block used by higher-level consolidation logic.

Key Procedures and Functions

The ETRM metadata documents five callable units within GL_CONS_WRK_PKG:

• SET_DATA — Initializes or populates the working data used by the consolidation workbench for a given run or context. It serves as the setup entry point for subsequent processing.
• GET_PERIOD — Returns the accounting period associated with the consolidation context, allowing callers to resolve the correct period name or identifier for history and reporting purposes.
• GET_ACCESS_SET_ID — Retrieves the access set identifier applied to the consolidation operation, which governs the data security and ledger access scope visible to the user.
• SUBMIT_REQUEST — Submits a concurrent request, most likely the consolidation, translation, or elimination program associated with the current workbench action.
• GET_TRANSLATION_STATUS — Returns the translation status for the relevant ledger and period, indicating whether balances have been translated and are ready for consolidation or elimination processing.

Consistent with ETRM practice, no parameter signatures are documented here and none should be assumed.

Tables Accessed

The only documented table reference is GL_TRANSLATION_STATUSES, accessed through an APPS synonym. This table stores the translation status of ledger balances by period, and the package reads it to support GET_TRANSLATION_STATUS and to validate readiness before consolidation or elimination runs. The package also depends on SYS.STANDARD, the standard Oracle PL/SQL package, which is a normal compilation dependency. No other base tables are documented.

Usage Notes

GL_CONS_WRK_PKG is typically invoked indirectly. The consolidation workbench and elimination history views reference it, so consolidation inquiry forms and any reports built on GL_CONSOLIDATION_HISTORY_V or GL_ELIMINATION_HISTORY_V exercise its logic without calling it directly. The presence of SUBMIT_REQUEST indicates that the package can launch concurrent processing on behalf of the workbench, which is characteristic of consolidation and translation submission flows in Oracle General Ledger 12.1.1 and 12.2.2.

Because this is an internal utility package, custom code should not depend on it. Oracle does not guarantee its signature or behavior across patches or upgrades, and undefined parameter lists make direct invocation unsafe. Developers needing consolidation data should query the supported history views or use documented General Ledger APIs instead. Any direct reference should be treated as unsupported and re-validated after every application of patches or upgrades.