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 12, 2024

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

Cause

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
Symptoms
Cause
Solution
References


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