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 FEBRUARY 23, 2022

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


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.