Results for “gl_cons_wrk_pkg”

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

Overview

GL_CONS_WRK_PKG is a consolidation and translation work package within the Oracle General Ledger (GL) application. It belongs to the APPS schema and is classified under ETRM as an OTHER object, meaning it is not registered as a formal public API but functions as an internal utility package used by Oracle EBS consolidation and translation processes. The package supports the currency translation and consolidation workflow by maintaining session-level context (period and access set), submitting concurrent translation requests, and exposing translation status information to callers. In Oracle EBS 12.1.1 and 12.2.2, this package operates in the same functional area as the GL consolidation and translation programs that generate translated and consolidated balances for reporting and analysis. Its role is primarily orchestration: it packages together the parameters required to launch the GL translation concurrent programs and provides lightweight accessors for the working context.

Key Procedures and Functions

• SET_DATA — Stores the working period and access set identifier in package-level variables so that subsequent calls within the same session can reference them without re-supplying the values.
• GET_PERIOD — Returns the period value previously set through SET_DATA.
• GET_ACCESS_SET_ID — Returns the access set identifier previously set through SET_DATA.
• SUBMIT_REQUEST — Submits the appropriate GL translation concurrent request via FND_REQUEST.SUBMIT_REQUEST. The procedure branches on the average translation flag: when average translation is not required, it submits the GLTTRN program; when average translation is required, it submits the GLTATR program. The procedure accepts ledger, currency, period, balance type, balancing segment, budget version, access set, chart of accounts, rate type, and ledger short name parameters to fully specify the translation run, and returns a request identifier.
• GET_TRANSLATION_STATUS — Returns translation status information, querying the GL_TRANSLATION_STATUSES table to report on the state of translation activity. This is the function most commonly referenced by callers seeking to determine whether translation has completed for a given context.

Tables Accessed

The documented table reference is GL_TRANSLATION_STATUSES, accessed through an APPS synonym. This table stores translation status records for ledgers, currencies, and periods. GET_TRANSLATION_STATUS reads from it to determine whether translation has been performed or completed for the requested context. No additional tables are documented in the ETRM metadata; the package otherwise relies on the FND_REQUEST infrastructure to launch concurrent programs rather than writing directly to application data tables.

Usage Notes

GL_CONS_WRK_PKG is typically invoked from consolidation and translation forms, concurrent program wrappers, and custom code that needs to launch or monitor GL translation. The standard pattern is to call SET_DATA once to establish the period and access set, then use GET_PERIOD and GET_ACCESS_SET_ID as needed, invoke SUBMIT_REQUEST to launch the translation program, and poll GET_TRANSLATION_STATUS to confirm completion. Because the package is classified as OTHER rather than a public API, its interface is not guaranteed stable across releases, and customizations should avoid direct dependency where a supported API exists. The package is referenced by two other packages in the ETRM inventory, indicating it is a shared internal dependency in the GL consolidation work flow. In 12.1.1 and 12.2.2 the behavior is consistent, with the underlying concurrent program names (GLTTRN and GLTATR) remaining the submission targets.