Search Results gl_elim_gen_pkg




Overview
Explore in AI Chat

Overview

GL_ELIM_GEN_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It supports the General Ledger elimination process, which is used to remove intercompany and intracompany balances prior to financial consolidation. Within the EBS architecture, this package operates as a supporting utility rather than a public API; the ETRM classification for the object is OTHER, indicating that it is not designated as a formally supported extension point. The package is registered as VALID in the data dictionary and depends on the SYS schema's STANDARD package, which provides the standard PL/SQL constructs required for compilation. Its primary business function is to assemble the inputs needed for elimination entry generation — primarily the correct accounting period boundaries — and to persist a record of elimination activity into the GL elimination history tables so that generated entries can be identified, reviewed, or excluded in subsequent runs.

Key Procedures and Functions

The ETRM metadata documents five procedures and functions within GL_ELIM_GEN_PKG. No parameter lists are documented; the descriptions below are limited to purpose.

  • SET_DATA — Initializes the internal state or working data required by the package before period or history processing is performed. It acts as a setup routine that prepares the session for the elimination generation logic that follows.
  • GET_PERIOD_START_DATE — Retrieves the start date of the accounting period relevant to the elimination run, allowing the generation process to scope its selection of balances correctly.
  • GET_PERIOD_END_DATE — Retrieves the end date of the accounting period, completing the date range used to bound elimination calculations.
  • INSERT_ELIM_HISTORY — Writes a new record into the elimination history table, capturing details of an elimination run or elimination entry so that it can be traced and reported.
  • SAVE_TO_ELIM_HIST — Persists elimination data to the history structures, providing the transactional save mechanism that finalizes the history record for the current processing cycle.

Tables Accessed

The package references the following objects through APPS synonyms, as documented in ETRM 12.2.2.

  • GL_ELIMINATION_HISTORY — The primary history table for elimination activity. INSERT_ELIM_HISTORY and SAVE_TO_ELIM_HIST write to this table, recording which eliminations were generated and in which period.
  • GL_ELIM_HISTORY_S — The corresponding sequence or supporting table for elimination history, used to generate or validate identifiers for new history records.
  • DUAL — The standard Oracle single-row dummy table, typically used for date retrieval, sequence value selection, or simple expression evaluation within the package's helper routines.

Usage Notes

GL_ELIM_GEN_PKG is an internal component of the General Ledger elimination and consolidation flow. It is most commonly invoked indirectly, driven by the concurrent programs and forms that perform elimination entry generation rather than being called directly by end users. The package is referenced by no other documented packages, meaning it sits near the leaf of the dependency tree and is unlikely to be a shared utility used across multiple modules. Because it is classified as OTHER and is not a published API, customizations should avoid direct dependency where possible; integrators should prefer supported GL interfaces. When troubleshooting elimination output, the GL_ELIMINATION_HISTORY and GL_ELIM_HISTORY_S records written by this package are the first place to confirm whether an elimination run was registered for a given period, and the period date functions can be checked to verify that the correct accounting range was applied.