Allocation Fails Even When Plenty Onhand, Availalbe, Rules Setup: wms.plsql.WMS_Rule_PVT..execute_open_rule: Invalid Package, Contact your DBA - wms_rule_pick_pkg3 / WMS_RULE_2 (Doc ID 2257220.1)

Last updated on APRIL 20, 2017

Applies to:

Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.
wms.plsql.WMS_Rule_PVT..execute_open_rule
wms_rule_pick_pkg1 / WMS_RULE_1
wms_rule_pick_pkg2 / WMS_RULE_2
wms_rule_pick_pkg3 / WMS_RULE_2
WMS_RULE_3
wms.plsql.WMS_Engine_PVT.Create_Suggestions.exit: WMS_Engine_PVT.Create_Suggestions
wms.plsql.WMS_Engine_PVT.Create_Suggestions.end G_SUGG_FAILURE_MESSAGE: Invalid Package, Contact your DBA - wms_rule_pick_pkg3 / WMS_RULE_2
wms.plsql.WMS_Engine_PVT.Create_Suggestions.End: End create_suggestions

Symptoms

Items are not automatically allocating even when there is plenty Onhand and Available.

What Tried
Added onhand/available quantity.
Setup Picking Rules.
Setup item transaction defaults.

Steps
1. Navigate to move orders > move orders : Create a replenishment move order.

* The same could happen on a pick release for a sales order or component pick for WIP Job.

2. Navigate to move orders > transact move order : Query the move order.
3. Click the Allocate button.
4. See Allocation = None, Allocated Quantity = 0

Business Impact
Production issue.
Extra time to select locators.
Delays processing move orders. Delays shipments.
Users must manually select locators to transact.
System not behaving as designed.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms