My Oracle Support Banner

WMS Pick Strategy Failing at Pick Release For a Non WMS Organization (Doc ID 1389115.1)

Last updated on DECEMBER 01, 2023

Applies to:

Oracle Warehouse Management - Version 12.1.3 and later
Information in this document applies to any platform.
Executable:WSHPSGL - Pick Selection List Generation


On release 12.1.3:

Pick Selection List Generation concurrent program (WSHPSGL) completes in warning with the following message in the request log and the sales order line gets backordered whereas there is enough available quantity for the related item.

The problem occurs with one shipping organization only.
This organization is not WMS enabled. Other organizations are WMS enabled and it is working fine for those organizations.

Per the Inventory debug information, the WMS rule engine is selecting a Pick strategy and all WMS rules assigned to this strategy are failing like below:

-- Error
[...] wms.plsql.WMS_Engine_PVT.Create_Suggestions.end G_SUGG_FAILURE_MESSAGE: WMS_PICK_NO_ROWS

-- Expectation
Expect not getting any WMS Pick strategy involved for non WMS organizations.

-- Steps
1. Create and book a one line sales order.
2. Go to Release Sales Orders form and launch the pick release with Auto Allocate=Yes and Auto Pick Confirm=No.
3. See the Pick Selection List Generation concurrent program completes in warning.
4. Query the sales order in Shipping Transactions form. See the line got backordered.


Just created the problematic Inventory organization. It is the first one which is not WMS enabled.


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.