My Oracle Support Banner

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 OCTOBER 02, 2018

Applies to:

Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.
wms_rule_pick_pkg1 / WMS_RULE_1
wms_rule_pick_pkg2 / WMS_RULE_2
wms_rule_pick_pkg3 / WMS_RULE_2
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


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.

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.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.