Search Results gl_glppos_acctseq_pkg




Overview
Explore in AI Chat

Overview

GL_GLPPOS_ACCTSEQ_PKG is an internal Oracle General Ledger package owned by the APPS schema and classified under the ETRM as an "OTHER" API. Its name reflects its role within the posting pipeline: "GL" for General Ledger, "GLPPOS" for the posting program family, and "ACCTSEQ" for accounting sequence generation. In Oracle EBS 12.1.1 and 12.2.2, the package supports the Posting process by establishing and initializing the accounting sequence context used when journal entries are assigned accounting dates and sequence identifiers prior to transfer and posting. The single documented entry point, BATCH_INIT, is explicitly a batch-level initialization routine, indicating that the package prepares global temporary state once per posting batch rather than per journal line. It forms part of the broader GL_GLPPOS_* package suite that underpins the Journal Posting concurrent program.

Key Procedures and Functions

The ETRM documents exactly one procedure for this package:

  • BATCH_INIT — The batch initialization procedure. Based on the package's purpose and name, BATCH_INIT sets up the accounting sequence generation context for a posting run, preparing the temporary structures and locking that subsequent posting logic depends upon. The p_ledgers_locked OUT parameter indicates the procedure reports whether the relevant ledgers were successfully locked as part of this initialization, reflecting the concurrency controls required to guarantee contiguous, gap-free accounting sequences. No other procedures or functions are documented in the ETRM for this object.

Tables Accessed

The ETRM lists the following tables, referenced through APPS synonyms:

  • GL_JE_BATCHES — The journal batch header table. BATCH_INIT operates at batch scope, so this table supplies batch-level context such as ledger, period, and posting status information needed to initialize the sequence run.
  • GL_JE_HEADERS — The journal header table, holding individual journals within a batch. It is referenced to identify the journals that will require accounting sequence assignment during posting.
  • GL_POSTING_ACCT_SEQ_GT — A global temporary table dedicated to posting accounting sequence generation. This is the primary working store the package populates during initialization, holding the sequence values that will ultimately be applied to journals.
  • PLITBLM — An Oracle Applications-standard PL/SQL index-by table (associative array) package for in-memory collections. Its presence confirms that BATCH_INIT also builds in-memory PL/SQL tables, likely for efficient batch processing of ledger and batch identifiers.

Usage Notes

GL_GLPPOS_ACCTSEQ_PKG is not a public, customer-facing API. The ETRM records zero packages referencing it and does not expose it as a documented integration point. In practice it is invoked internally by the General Ledger posting engine as the first step of processing a posting batch, immediately before the logic that assigns accounting sequences. It is not called directly from Oracle Forms, and it is not intended to be called from custom code; customer extensions should use supported GL interfaces such as Journal Import instead. Because the $Header line shows a 2005 revision (gluposqs.pls 120.1), the interface has been stable across the 12.1.1 and 12.2.2 releases, and its behavior should be treated as internal implementation detail subject to change without notice. Any diagnosis of posting errors relating to accounting sequences should be performed through the Journal Posting concurrent program and its log output rather than through direct invocation of this package.