Search Results xla_accounting_cache_pkg




Overview
Explore in AI Chat

Overview

XLA_ACCOUNTING_CACHE_PKG is a PL/SQL package body in the APPS schema that belongs to the Subledger Accounting (XLA) product family within Oracle E-Business Suite. Its primary business function is to provide an in-memory caching mechanism for the setup and configuration metadata that the Subledger Accounting engine requires when creating and maintaining accounting entries. Rather than querying application, ledger, event type, accounting method, journal category, and subledger configuration tables repeatedly during posting and accounting cycle processing, the Subledger Accounting engine relies on this package to load and expose that information efficiently. This caching reduces the volume of repetitive dictionary and setup lookups performed during high-volume accounting generation, thereby improving performance of the Create Accounting process.

In EBS 12.1.1 and 12.2.2 the object is documented as VALID and is classified as an "OTHER" type API in the ETRM repository. Its public interface is composed almost entirely of low-level accessor routines that return cached configuration values to the calling Subledger Accounting code, rather than a transactional business API intended for direct customer invocation.

Key Procedures and Functions

The documented public procedures and functions (18 total) reflect the package's role as a setup cache access layer. Representative members include:

  • LOAD_APPLICATION_LEDGERS — populates the internal cache with the ledgers and ledger-related configuration associated with an application, establishing the base data set used by subsequent retrieval calls.
  • GETALCLEDGERS / GETLEDGERS / BUILDLEDGERARRAY / GETLEDGERARRAY — retrieve and assemble the set of ledgers relevant to the current accounting context, returning them either individually or as array structures for bulk processing.
  • GET_PAD_INFO — returns padding or context information maintained by the cache for the active session.
  • GET_EVENT_INFO — supplies cached details for a Subledger Accounting event, drawn from the event class and event type configuration.
  • GET_JE_CATEGORY — returns the journal category associated with the current accounting context.
  • GETVALUENUM / GETVALUEDATE / GETVALUECHAR — typed accessors that return cached numeric, date, and character values respectively, used by the accounting engine to fetch specific configuration attributes without re-querying base tables.
  • GETSESSIONVALUECHAR — returns a character value held for the duration of the current session cache.
  • GETCURRENCYMAU — returns currency-related monetary amounts (Minimum Accounting Unit) information used in rounding and currency handling during accounting entry creation.

All routines are declared in the corresponding package specification XLA_ACCOUNTING_CACHE_PKG, which the body implements. The body itself is not referenced by any database object, confirming that it is invoked at runtime through the specification by other XLA packages rather than by triggers or views.

Tables Accessed

Through APPS synonyms, the package reads the setup and reference tables that underpin Subledger Accounting configuration. These include XLA_MAPPING_SET_VALUES, XLA_ACCTG_METHODS_TL, XLA_ACCTG_METHOD_RULES, XLA_EVENT_CLASSES_TL, XLA_EVENT_TYPES_TL, XLA_JE_CATEGORIES, XLA_PRODUCT_RULES_B, and XLA_PRODUCT_RULES_TL, all of which define how transactions are accounted. It also accesses GL_LEDGERS, GL_COA_MAPPINGS, and GL_LEDGER_RELATIONSHIPS to resolve ledger and chart of accounts context, plus FND_APPLICATION_TL, FND_CURRENCIES, FND_ID_FLEX_STRUCTURES_TL, and FND_LANGUAGES for application, currency, and key flexfield reference data. Dependent helper packages include XLA_CMP_HASH_PKG, XLA_EXCEPTIONS_PKG, FND_PROFILE, FND_LOG, and MO_GLOBAL, which support hashing, error handling, profile retrieval, logging, and multi-org context respectively.

Usage Notes

XLA_ACCOUNTING_CACHE_PKG is an internal engine component rather than a user-facing API. It is invoked indirectly by the Create Accounting concurrent program and by the Subledger Accounting posting and accounting programs whenever setup metadata must be resolved. The documented dependency listing shows the package is referenced by 58 other packages, indicating broad internal reuse across the XLA codebase. Customizations should not call this package directly, as the cache contents and session lifecycle are managed by the calling XLA framework; developers requiring ledger, event, or accounting method information should use the supported Subledger Accounting public APIs, which in turn may leverage this cache.