Search Results wms_cache




Overview
Explore in AI Chat

Overview

WMS_CACHE is a public PL/SQL package in the APPS schema that provides in-memory caching services for the Oracle Warehouse Management (WMS) rules engine in Oracle E-Business Suite 12.1.1 and 12.2.2. Its principal business purpose is to reduce the cost of repeatedly resolving strategy definitions, rule membership, unit-of-measure conversions, and partial-success flags during high-volume warehouse transactions such as picking, put-away, and shipping. By materializing this configuration data into package-level PL/SQL collections, the package avoids redundant queries against the strategy and rules tables each time the rules engine evaluates a transaction line.

The package specification declares AUTHID CURRENT_USER and defines several associative array types, including a numeric collection type named tbl_num (TABLE OF NUMBER INDEX BY BINARY_INTEGER). This type is used throughout the package for identifier-oriented collections such as rule identifiers and item identifiers. The specification also declares module-level globals, including hash sizing constants and cached conversion and item tables, which persist for the duration of a database session.

Key Procedures and Functions

  • UOM_CONVERT — A function that converts a quantity from one unit of measure to another for a given item, supporting precision handling, lot number, and organization context. It relies on cached from/to UOM code and ratio collections to avoid repeated conversion lookups during transaction processing.
  • GET_STRATEGY_FROM_CACHE — Returns strategy information from the session cache. The package caches the strategy, its over-allocation mode, tolerance value, associated rule identifiers, and partial-success flags. When a new strategy is encountered, the package calls the rules engine initialization API to populate the PL/SQL tables on which the rules engine operates.
  • CLEANUP_RULES_CACHE — Purges cached strategy and rule data so that subsequent calls rebuild the cache from the underlying tables. This is used to release memory and to force refresh after strategy or rule configuration changes.

Tables Accessed

The package reads configuration from the WMS strategy and rules tables through APPS synonyms. WMS_STRATEGIES_B supplies strategy-level attributes such as over-allocation mode and tolerance value. WMS_RULES_B supplies the rule definitions associated with a strategy, and WMS_STRATEGY_MEMBERS supplies the mapping between strategies and their member rules. The package also references DBMS_UTILITY, primarily for hashing and utility operations supporting the cache, and PLITBLM, the PL/SQL table-indexed-by-BINARY_INTEGER package used for collection operations. No direct writes to these base tables are documented; the package is a read-oriented cache layer.

Usage Notes

WMS_CACHE is invoked internally by WMS rules engine components, particularly wms_strategy_pvt, when a strategy is applied to a transaction. It is not intended as an end-user entry point and is not exposed through standard EBS forms or concurrent programs. Extensions and custom code that interoperate with the WMS rules engine may call UOM_CONVERT or GET_STRATEGY_FROM_CACHE directly, and should call CLEANUP_RULES_CACHE after modifying strategy or rule setup to prevent stale cached values. Because cached collections are session-scoped, long-lived sessions may accumulate memory until cleanup is invoked.