Search Results gl_auto_alloc_vw_pkg




Overview
Explore in AI Chat

Overview

GL_AUTO_ALLOC_VW_PKG is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It supports the General Ledger automatic allocation framework, a feature that lets users define allocation rules and have the system generate balanced journal entries across accounting flexfield combinations on a recurring or on-demand basis. The package supplies the underlying query and lookup logic that the allocation views and forms rely on to display allocation batch information, resolve the owner associated with an allocation definition, and present descriptive context for automatic allocation and recurring journal processing.

Its ETRM classification is OTHER, indicating that it is an internal support package rather than a public, documented API. It exposes a small number of utility routines rather than a full business API, and it is not referenced by any other database object, which confirms its role as a leaf-level helper consumed by the forms layer and related packages.

Key Procedures and Functions

  • GET_BATCH_NAME — Resolves and returns the batch name associated with an allocation batch. This allows allocation-related forms and reports to display a human-readable batch identifier instead of a raw key, and supports navigation between varying batch and allocation definitions.
  • GET_OWNER_DSP — Returns the display value of the owner for an allocation rule or batch. The owner identifies the individual or role responsible for the allocation definition, drawing on workflow role information to render a meaningful value in the user interface.

Both routines are read-only helpers. No parameter lists are documented in the ETRM metadata, and none should be assumed; the package performs lookup and formatting work rather than maintaining transactional state.

Tables Accessed

  • GL_ALLOC_BATCHES — Stores allocation batch header definitions used to group automatic allocation runs. The package reads this table to obtain the batch name and batch context returned by GET_BATCH_NAME.
  • GL_RECURRING_BATCHES — Holds recurring journal batch definitions, the mechanism behind recurring allocations and journal entries. The package references it for batch naming and owner display when the allocation originates from a recurring batch.
  • PA_ALLOC_RULES_ALL — Projects allocation rule definitions shared across Oracle Projects and General Ledger. The package reads it to resolve rule-level attributes such as the rule owner rendered by GET_OWNER_DSP.
  • GL_WF_ROLES_V — A workflow role view used to translate role identifiers into display names for the owner value.

Usage Notes

The package is typically invoked indirectly by the Oracle General Ledger allocation and recurring journal forms, and by the surrounding allocation packages. It is not called directly by end users and is not scheduled as a concurrent program. Because it is classified OTHER and exposes no public API contract, custom code should avoid calling it directly; implementers who need batch or owner information should use the documented GL allocation open interfaces instead. The metadata notes that the package is referenced by five other packages, so changes to its internal logic can affect those dependents. When upgrading between 12.1.1 and 12.2.2, verify that any form or extension overlaying allocation batch or owner display still resolves correctly, since the package is compiled in the APPS schema and validated against the seeded GL and PA tables.