Search Results refresh_cache

Overview

ARP_CACHE_UTIL is a server-side PL/SQL utility package owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the Oracle Receivables (AR) product family, as indicated by the ARP prefix common to Receivables database objects. The package is classified as a UTIL object in the E-Business Suite Technical Reference Manual (ETRM), meaning it is not a public, user-facing API but an internal helper module invoked by other Receivables components.

Its business function is to manage the in-memory caching of Receivables system-level setup information. Receivables relies on organization-level system parameters to drive transaction processing behavior, and repeatedly querying these values from the database during high-volume operations would introduce unnecessary overhead. ARP_CACHE_UTIL provides a controlled mechanism to refresh that cached data so that runtime components operate against current system parameter values without requiring a full session or application restart.

Key Procedures and Functions

The package exposes exactly one documented procedure, REFRESH_CACHE. Based on its name and the ETRM classification, its purpose is to invalidate and repopulate the cached copy of Receivables system parameter data held by the current session or middle-tier process. It takes no documented arguments and returns no value; it is a procedural entry point rather than a query interface.

The package also declares a private package-level variable, PG_OLD_ORG_ID, typed as AR_SYSTEM_PARAMETERS.ORG_ID%TYPE. This anchor variable is not exposed as part of the package specification's callable surface. Its presence indicates that the refresh logic tracks the organization identifier associated with the previously cached parameter set, allowing the procedure to detect when the operating context or organization has changed and to re-read system parameters accordingly.

Tables Accessed

According to the ETRM metadata, ARP_CACHE_UTIL references one table via APPS synonyms: AR_SYSTEM_PARAMETERS. This is the Receivables system parameters table, the authoritative store of organization-level accounting and processing defaults, including the ORG_ID column referenced by the package's internal variable. The package reads from this table during REFRESH_CACHE to obtain current parameter values that populate the cache. No other tables are documented as being accessed, which is consistent with the narrow, single-purpose design implied by the UTIL classification.

Usage Notes

The package specification carries the version header marker $Header: ARXCAUTS.pls 120.1.12010000.1 2008/07/24 16:59:52 appldev ship $, identifying the source file as ARXCAUTS.pls and confirming that the shipped version dates from the 12.1 development cycle and remains in place for 12.2.2.

ARP_CACHE_UTIL is referenced by one other documented package, indicating it is invoked programmatically rather than directly by end users. Typical invocation scenarios include Receivables forms or middle-tier processes that need to synchronize cached system parameters after a configuration change, and concurrent programs or workflows that operate across multiple organizations and must ensure the correct parameter set is loaded. Because the package is internal, customizations should not call REFRESH_CACHE directly unless the surrounding caching assumptions are fully understood; the supported mechanism for modifying Receivables system parameters is the Receivables setup user interface, which in turn triggers the internal refresh path.

Administrators diagnosing stale parameter behavior should note that raising a request to refresh Receivables system options is normally sufficient, and that direct execution of this utility package is not a documented operational procedure.