Search Results rollback_capacity_update

Overview

APPS.WMS_RULE_PVT is the private PL/SQL package that implements the rule engine for Oracle Warehouse Management (WMS) in Oracle E-Business Suite 12.1.1 and 12.2.2. Its central responsibility is to evaluate a WMS rule against a transaction or reservation request and generate execution recommendations. The package specification is delivered in WMSVPPRS.pls, with the current source header dated 2013/01/31. It is declared AUTHID CURRENT_USER, meaning it executes with the privileges of the calling session rather than the definer.

The rule engine underpins directed put-away, picking, replenishment, labeling, and operation assignment. Callers supply a rule identifier, a rule type code, and the identifier of the source transaction or reservation so the package can apply the configured rule logic and persist the resulting recommendations. Because the package is classified as PVT, it is not supported for direct customer invocation; it is consumed internally by WMS and by approved product code. The metadata records 23 documented procedures and functions, and the package is referenced by 35 other packages, confirming its position as a foundational internal API.

Key Procedures and Functions

The documented entry points fall into three functional groups.

• APPLY — the principal entry point. It applies a WMS rule to a given transaction or reservation input and creates recommendations. The source notes that the strategy temporary view must contain a unique record for the transaction, at least one transaction detail line must exist, the rule must exist in WMS_RULES_B, and, for picking, a quantity tree must have been created via INV_Quantity_Tree_PVT.Create_Tree.
• Rule execution: EXECUTE_TASK_RULE, EXECUTE_OP_RULE, APPLYDEFLOC, APPLYLABEL, ASSIGNTTS, ASSIGNTT, ASSIGN_OPERATION_PLANS, ASSIGN_OPERATION_PLAN, and QUICKPICK. These apply rule definitions to task, operation, default location, label, and quick-pick scenarios.
• Rule maintenance: FIND_RULE, CHECKSYNTAX, GENERATERULEPACKAGE, GETPACKAGENAME, COMPILE_ALL_RULE_PACKAGES, CALCRULEWEIGHT, GETCONVERSIONRATE, GET_WMS_SYS_TASK_TYPE, ISRULEDEBUGON, and ROLLBACK_CAPACITY_UPDATE. These support rule lookup, syntax validation, dynamic package generation and compilation, weighting, UOM conversion, system task type resolution, debug control, and recovery of capacity updates.

GET_WMS_SYS_TASK_TYPE is the function associated with the search term "get_wms_sys_task_type". It resolves the system task type used during rule evaluation, allowing rule logic to branch on the task being performed.

Tables Accessed

The package reads and writes core WMS and inventory tables through APPS synonyms:

• Transaction and reservation context: MTL_MATERIAL_TRANSACTIONS_TEMP, WMS_TRANSACTIONS_TEMP, MTL_RESERVATIONS, MTL_ONHAND_QUANTITIES_DETAIL, and MTL_SERIAL_NUMBERS supply the transaction, detail, reservation, on-hand, and serialization data required for rule evaluation.
• Location and item definitions: MTL_ITEM_LOCATIONS, MTL_ITEM_LOC_DEFAULTS, MTL_ITEM_SUB_DEFAULTS, MTL_SYSTEM_ITEMS, MTL_PARAMETERS, and MTL_SECONDARY_INVENTORIES provide location, defaulting, item, organization parameter, and subinventory attributes.
• Operations and conversions: BOM_STANDARD_OPERATIONS, MTL_LOT_UOM_CLASS_CONVERSIONS, FND_FLEX_VALUE_SETS, and FND_FLEX_VALIDATION_TABLES support operation assignment and flexfield-based value validation.

Usage Notes

WMS_RULE_PVT is normally invoked indirectly. Warehouse execution forms and concurrent programs such as rule compilation and strategy processing call into it, and 35 other packages reference it, including public WMS APIs that delegate rule evaluation. Custom code should not call this package directly; integrators should use the supported public APIs and let them invoke WMS_RULE_PVT. The AUTHID CURRENT_USER declaration requires that the invoking session hold the necessary object privileges.