Search Results log_statement

Overview

WMS_RULE_PVT is the private rules engine package body owned by APPS in Oracle E-Business Suite, delivered as part of the Warehouse Management System (WMS) module and shared with the Oracle Warehouse Management / Logistics execution stack. Its documented API classification is PVT, indicating that it is an internal, non-public API surface intended to be called by other WMS packages rather than directly by end-user code, forms, or external integrations. The package implements the core rule evaluation, rule-packaging, and rule-extraction logic used by Warehouse Management for picking, putaway, task, operation, and label strategies. It builds and compiles dynamically generated rule packages, evaluates the generated SQL predicates against actual item, location, lot, serial, and transaction attributes, and returns the matching rule or strategy to the calling process. As of ETRM 12.2.2 the package exposes 23 documented procedures and functions and is referenced by 35 other packages, confirming its role as a foundational internal dependency for WMS execution flows.

Key Procedures and Functions

The documented API set groups into several functional clusters:

• Rule evaluation and application: APPLY, APPLYDEFLOC, APPLYLABEL — evaluate a given rule against the current context and return the applicable rule or default location/label outcome.
• Rule discovery and packaging: FIND_RULE, GETPACKAGENAME, GENERATERULEPACKAGE, COMPILE_ALL_RULE_PACKAGES, CHECKSYNTAX — locate a rule, determine the dynamically generated package name, generate or compile rule packages, and validate generated rule syntax.
• Task and operation rules: EXECUTE_TASK_RULE, EXECUTE_OP_RULE, ASSIGNTTS, ASSIGNTT, ASSIGN_OPERATION_PLANS, ASSIGN_OPERATION_PLAN, CALCRULEWEIGHT — support task-type assignment, operation rule execution, operation-plan assignment, and rule weighting/scoring.
• Utility and support: GETCONVERSIONRATE, GET_WMS_SYS_TASK_TYPE, ISRULEDEBUGON, ROLLBACK_CAPACITY_UPDATE, QUICKPICK — provide conversion-rate lookup, system task type resolution, rule debug-state checking, capacity-update rollback, and quick-pick rule support.

In the context of the search term "log_statement", note that ISRULEDEBUGON is the documented toggle controlling whether rule execution emits debug diagnostics; rule debugging is the mechanism through which statement-level logging is enabled for this package. Detailed parameter lists are intentionally omitted here and should be obtained from the live package specification in the target instance.

Tables Accessed

The package reads and writes WMS and inventory foundation tables via APPS synonyms. Location and item defaults (MTL_ITEM_LOCATIONS, MTL_ITEM_LOC_DEFAULTS, MTL_ITEM_SUB_DEFAULTS, MTL_SECONDARY_INVENTORIES) supply the attributes evaluated by rule predicates. Item and lot data (MTL_SYSTEM_ITEMS, MTL_SERIAL_NUMBERS, MTL_LOT_UOM_CLASS_CONVERSIONS, BOM_STANDARD_OPERATIONS) support serial, lot UOM, and operation-based rules. On-hand, reservation, and transaction tables (MTL_ONHAND_QUANTITIES_DETAIL, MTL_RESERVATIONS, MTL_MATERIAL_TRANSACTIONS_TEMP, WMS_TRANSACTIONS_TEMP) are used during execution and temporary capacity/task processing. MTL_PARAMETERS provides organization-level defaults. Flexfield metadata (FND_FLEX_VALUE_SETS, FND_FLEX_VALIDATION_TABLES) validates key-flexible rule attributes.

Usage Notes

WMS_RULE_PVT is invoked indirectly through WMS execution packages and concurrent programs rather than directly. Rule packages are generated and compiled at setup or on rule changes, then executed during pick, putaway, task, operation, and label processing. Custom code should not call this PVT package directly; supported extension points are the corresponding public WMS APIs. When troubleshooting rule behaviour, enable ISRULEDEBUGON so that statement-level diagnostics are emitted for the rule being evaluated.