Search Results retrieve_globals

Overview

AP_MO_CACHE_UTILS is a PL/SQL package body in the APPS schema that provides shared caching utilities for Oracle Payables multi-organization (MO) processing. Its central responsibility is to gather operating unit attributes and Payables system parameter values from the database in a single bulk operation and return them in a structured, memory-resident form. The package therefore supports the broader Payables design pattern in which operating-unit-specific configuration data is loaded once per session or per processing unit and reused, rather than being re-queried for every transaction. The header comment on the package body notes that it retrieves operating unit attributes from the database and stores them into a specified data structure. In Oracle EBS 12.1.1 and 12.2.2, this pattern is significant because Payables logic is frequently driven by Financials System Parameters and AP System Parameters at the operating unit level, and repeated single-row lookups against those tables would be costly in high-volume invoice and payment processing.

Key Procedures and Functions

The only documented procedure in the package is RETRIEVE_GLOBALS. Its purpose is to populate the GlobalsTable structure with operating unit attributes. The procedure declares an OUT NOCOPY parameter, which allows the populated nested-table structure to be returned to the caller without an unnecessary copy of the collection — an important optimization when the returned structure contains many attributes across potentially many operating units. Internally, RETRIEVE_GLOBALS executes a single SQL statement that joins the relevant Payables and Financials parameter tables and uses BULK COLLECT to load the result set into nested-table structures. The selected attributes include the operating unit organization identifier, chart of accounts identifier, set of books identifier, ledger name and short name, budgetary control flag, functional and base currency codes, multi-currency and payment currency settings, invoice numbering and matching options, code combination identifiers for liability, freight and prepayment accounts, discount distribution method, invoice document category override, approvals option, withholding tax (AWT) flags and distribution types, prepayment terms, settlement date handling, and user XRA calculation settings. The procedure also records a calling sequence string for diagnostic purposes, reflecting the standard Oracle EBS practice of capturing the PL/SQL call stack in local variables to support error reporting and debug tracing. No other procedures or functions are documented for this package.

Tables Accessed

The package reads from a documented set of APPS synonyms. AP_SYSTEM_PARAMETERS supplies the operating unit identifier and the majority of Payables-specific options such as matching, discount, approval, and withholding tax flags. FINANCIALS_SYSTEM_PARAMETERS and FINANCIALS_SYSTEM_PARAMS_ALL supply operating unit and ledger-level settings used to resolve set of books and related attributes. AP_PRODUCT_SETUP provides product installation options, while AP_TERMS supplies payment term name data referenced by the prepayment terms identifier. FND_CURRENCIES provides currency code definitions, and GL_DAILY_CONVERSION_TYPES supports currency conversion type lookup. HR_ORGANIZATION_INFORMATION supplies operating unit organization name and classification information. CE_BANK_ACCOUNTS and CE_BANK_ACCT_USES_ALL provide bank account and bank account usage data referenced by the cached attributes. PLITBLM is the standard Payables interim table used in Payables processing logic. The bulk query joins these sources so that all required operating unit attributes are returned in one pass rather than through repeated round trips.

Usage Notes

AP_MO_CACHE_UTILS is an internal utility package and is referenced by zero other documented packages per the ETRM metadata, indicating that it is called from a restricted set of EBS components rather than being a widely reused API. It is typically invoked from Payables forms, concurrent programs, or originating workflow and invoice processing logic that needs a cached snapshot of operating unit and system parameter settings before performing transaction-level work. Because RETRIEVE_GLOBALS returns a GlobalsTable structure via an OUT NOCOPY parameter, callers must first declare a variable of the appropriate type and then pass it to the procedure; the populated collection can subsequently be referenced without re-querying the parameter tables. The package is classified as OTHER rather than as a public API, so custom code should not treat it as a supported integration point. Its value lies in reducing redundant queries against FINANCIALS_SYSTEM_PARAMETERS, AP_SYSTEM_PARAMETERS and related configuration tables during multi-organization Payables processing.