Search Results get_fa_param_from_cache




Overview
Explore in AI Chat

Overview

XDP_PARAM_CACHE is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that provides an in-memory parameter caching layer for the Oracle Advanced Supply Chain Planning and fulfillment processing framework, commonly associated with the XDP (eXtended Demand Planning / fulfillment execution) module set. Its principal business function is to reduce the cost of repeatedly querying work item and fulfillment action parameter definitions from the database during the execution of fulfillment work lists, work items, and their associated runtime parameters.

The package is declared with AUTHID CURRENT_USER, meaning that it executes with the privileges of the invoking user rather than the definer's privileges, which allows it to be safely invoked from forms, concurrent programs, and custom code operating under a variety of login contexts. The source header indicates a revision from 2005 (XDPPACHS.pls 120.1), reflecting a long-standing, stable component of the fulfillment engine rather than a recently introduced one. The name "XDP_PARAM_CACHE" aligns with the search term "init_cache," referring to the package's cache initialization routine, which is the primary entry point used to populate the cache before work item or fulfillment action processing begins.

Key Procedures and Functions

The ETRM metadata documents eight procedures and functions within this package, of which the following are listed by name:

  • INIT_CACHE — Initializes the package-level cache structures, loading configuration and parameter definitions so that subsequent lookups avoid repeated database access.
  • CLEAR_CACHE — Resets the cached values, ensuring that stale or context-specific parameter data does not persist between execution cycles.
  • ADD_WI_PARAM_TO_CACHE — Adds a work item parameter definition to the cache, supporting incremental population of the parameter list as work items are encountered.
  • GET_WI_PARAM_FROM_CACHE — Retrieves a work item parameter definition from the in-memory cache, returning the parameter record without requiring a database round trip.
  • GET_FA_PARAM_FROM_CACHE — Retrieves a fulfillment action parameter definition from the cache, used during fulfillment action processing.
  • REMOVE_FROM_CACHE — Removes a specified entry from the cache, supporting invalidation when parameter definitions change or when a processing context ends.

The package declares record and table types (XDP_PARAM and XDP_PARAM_LIST) and cursors such as c_GetWiParams, c_GetWiParamConfig, and c_GetWiConfig, which supply the underlying data used to populate the cache. Package-level variables including pv_workitem_id, pv_workitem_instance_id, pv_fa_id, and pv_fa_instance_id hold the current processing context.

Tables Accessed

The package reads from the following tables via APPS synonyms: XDP_WI_PARAMETERS (work item parameter definitions), XDP_WORKITEMS (work item configuration, including execution procedures and workflow item attributes), XDP_FULFILL_WORKLIST (mapping work item instances to work items), XDP_FA_PARAMETERS (fulfillment action parameters), XDP_FA_RUNTIME_LIST (fulfillment action runtime configuration), XDP_FULFILL_ACTIONS (fulfillment action definitions), and PLITBLM (a standard Oracle Applications temporary/work table structure). These tables collectively define the parameter metadata that the cache serves.

Usage Notes

XDP_PARAM_CACHE is typically invoked at the start of fulfillment processing — for example, when a work list is executed — by calling INIT_CACHE to preload parameters, followed by GET_WI_PARAM_FROM_CACHE and GET_FA_PARAM_FROM_CACHE during processing, and CLEAR_CACHE on completion. It is referenced by two other packages according to the metadata, indicating internal use by the fulfillment engine. Custom code that extends or hooks fulfillment processing may invoke these routines directly, but should call CLEAR_CACHE between logical processing cycles to prevent stale parameter data from affecting results.