My Oracle Support Banner

Unable To Run Pick Release For A Project Sales Order -- Error WMS_PICK_NO_ROWS (Doc ID 1521615.1)

Last updated on JULY 08, 2020

Applies to:

Oracle Warehouse Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

PROBLEM STATEMENT
=================
When attempting to process project sales order in the move Orders form the following error occurs.

ERROR
-----------------------
The material sourcing process failed to create picking suggestions for line x of move order number xxxx

WMS_PICK_NO_ROWS i.e wms.plsql.WMS_Engine_PVT.Create_Suggestions.end G_SUGG_FAILURE_MESSAGE:WMS_PICK_NO_ROWS

Org is non-wms enabled. They can pick release fine for non-project/task sales orders. Issue is with only sales orders associated with project/task. Item is hard pegged and onhand.

Changes

 

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
Changes
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.