Search Results cache_data




Overview
Explore in AI Chat

Overview

GLXJEENT_PKG is the journal entry engine package in the Oracle E-Business Suite General Ledger module, owned by the APPS schema and classified as an OTHER API object. It provides the server-side foundation for the Journal Entry form (GLXJEENT) and its supporting entry workflow, supplying account and ledger context, defaulting journal attributes, resolving accounting periods, and validating period status before a journal can be saved or posted. In EBS 12.1.1 and 12.2.2 the package is a core dependency of the standard journal entry screens, where its logic drives source and category defaults, reversal defaults, conversion type defaults, and effective-date handling.

Key Procedures and Functions

  • CACHE_DATA — The central defaulting routine. It is invoked with an account identifier, ledger identifier, and form mode, and derives journal entry defaults: journal source and category (default and user-defined), journal approval flag, reversal change sign flag, reversal period, reversal start/end dates, period name, period start/end dates, effective date, period year and number, conversion type defaults (default, user default, and user fixed), and active date bounds. It returns these values through NOCOPY OUT parameters for performance. It keys source defaults on form mode, using 'Manual' for mode 'A' and 'Encumbrance' otherwise, then calls GL_JE_SOURCES_PKG.SELECT_COLUMNS to populate source-level attributes.
  • GET_PERIOD — Resolves the accounting period associated with a given date and ledger, returning period name, year, and number context used throughout journal entry validation.
  • IS_PRIOR_PERIOD — Tests whether a supplied period precedes the current or default period, supporting controls on back-dated entries.
  • DEFAULT_STILL_GOOD — Determines whether a previously cached default set remains valid and can be reused without re-querying setup data.
  • DEFAULT_ACTUAL_PERIOD — Derives the actual open period to be used as the working context for the entry.
  • SET_FIND_WINDOW_STATE — Manages the state of the Journal Entry Find window, controlling which query criteria are retained or reset between invocations.

Tables Accessed

  • GL_JE_HEADERS — The journal entry header table, read to validate or reference existing journal context during defaulting and window state management.
  • GL_LEDGERS — Supplies ledger-level attributes such as the default period and accounting calendar context.
  • GL_PERIODS — Provides period name, year, and number derivation from dates via the calendar.
  • GL_PERIOD_STATUSES — Supplies period open/closed status used by IS_PRIOR_PERIOD and period validation logic.
  • GL_DATE_PERIOD_MAP — Maps dates to periods for effective-date and period resolution.
  • DUAL — Used for singleton lookups and simple scalar evaluation.

Usage Notes

GLXJEENT_PKG is not referenced by any other documented package, confirming its role as a leaf-level engine invoked directly by the Journal Entry form and related UI components rather than a shared library. It is typically called when the form initializes, when the user changes ledger or account context, and when defaults must be refreshed or validated. Because its procedures carry IN OUT NOCOPY parameters, callers must supply properly typed variables. Custom code should prefer calling this package only where the standard journal entry form behavior must be reproduced, since its defaulting rules are tightly coupled to form mode semantics and ledger setup. The header comment indicates the package body was last revised in 2004 at version 120.8, so behavior is stable across 12.1.1 and 12.2.2.