Search Results load_application_ledgers

Overview

XLA_ACCOUNTING_CACHE_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite subledger accounting (XLA). Its declared purpose is to cache frequently used reference data during execution of the Accounting Program, improving performance and providing a modular, lean interface between the Accounting Engine and the Accounting Program. The package header is defined with AUTHID CURRENT_USER, and its procedures and functions never execute COMMIT or ROLLBACK, leaving transaction control to the calling process. The original specification was created in October 2002 and evolved through 2003 with the new bulk processing approach of the accounting program, additions such as p_max_event_date to load_application_ledgers, and the introduction of several GetValue* and session-value utilities.

Key Procedures and Functions

The documented interface exposes eighteen program units that fall into three functional groups.

• LOAD_APPLICATION_LEDGERS — the primary cache-loading routine. It populates the in-memory structures for the ledgers associated with an application, using the p_max_event_date parameter introduced for the bulk accounting approach. This is the entry point most commonly referenced when searching for a way to prime the accounting cache.
• GETALCLEDGERS, GETLEDGERS, BUILDLEDGERARRAY, GETLEDGERARRAY — related ledger accessors. GETALCLEDGERS returns Accounting Ledger Configuration ledgers; GETLEDGERS (renamed from GetBaseLedgers) returns base ledgers; the array routines build and retrieve the cached ledger arrays.
• GETVALUENUM, GETVALUEDATE, GETVALUECHAR — overloaded value lookups returning numeric, date, and character values respectively, used to retrieve cached column or mapping values without repeated SQL. GETSESSIONVALUECHAR is the corresponding overloaded session-scoped character accessor.
• GET_PAD_INFO and GETARRAYPAD — return Product Accounting Definition (PAD) information, with the array variant returning cached PAD data. GET_EVENT_INFO supplies cached event details, and GET_JE_CATEGORY resolves journal entry categories. GETCURRENCYMAU returns currency minimum accountable unit information.

Tables Accessed

The package reads reference and setup data through APPS synonyms. Ledger and ledger relationship configuration comes from GL_LEDGERS and GL_LEDGER_RELATIONSHIPS, with chart-of-accounts mappings from GL_COA_MAPPINGS. Accounting method and product rule definitions are read from XLA_ACCTG_METHODS_TL, XLA_ACCTG_METHOD_RULES, XLA_PRODUCT_RULES_B, and XLA_PRODUCT_RULES_TL. Event and journal line metadata come from XLA_EVENT_CLASSES_TL, XLA_EVENT_TYPES_TL, and XLA_JE_CATEGORIES, while XLA_MAPPING_SET_VALUES supplies mapping set values. Descriptive and localization data is drawn from FND_APPLICATION_TL, FND_CURRENCIES, FND_ID_FLEX_STRUCTURES_TL, and FND_LANGUAGES. These tables are predominantly read into the cache rather than written.

Usage Notes

XLA_ACCOUNTING_CACHE_PKG is an internal infrastructure package, not a user-facing API. It is invoked by the Subledger Accounting Program and by the Accounting Engine during rule evaluation, typically after a caller first invokes LOAD_APPLICATION_LEDGERS to prime the cache and then calls the various Get* accessors instead of querying base tables directly. ETRM records 58 other packages referencing this package, confirming its role as a shared service layer. Because the APIs perform no COMMIT or ROLLBACK, callers retain full transaction control. Customizations should not call this package directly where public XLA accounting APIs exist; when integration is unavoidable, the package must be called within the caller's transaction and the cache loaded before any value accessor is used.