My Oracle Support Banner

WMS Pick Release Gives Insufficient Quantity Warning Even Though Free Stock Exists (Doc ID 1281911.1)

Last updated on DECEMBER 02, 2016

Applies to:

Oracle Warehouse Management - Version 12.1.1 and later
Information in this document applies to any platform.
This document includes all versions of Oracle EBS 11i and R12


Symptoms

When attempting to pick release the pick release ends in warning andthe following error occurs.

ERROR
G_SUGG_FAILURE_MESSAGE: WMS_PICK_NO_ROWS
Pick Release process could not allocate ### of item ### for order ### as there was insufficient quantity available Or Inventory allocations have failed, and the line has been back ordered.

Here is an example of what you might see in the Pick Selection List Generation Log:

Line 2377: [04-JAN-11 10:03:56] wms.plsql.WMS_Engine_PVT.Create_Suggestions.end G_SUGG_FAILURE_MESSAGE: WMS_PICK_NO_ROWS
Line 2385: [04-JAN-11 10:03:56] Inv_Pick_Release_PVT.Process_Line: updating reservations created as suggestions failed
Line 2519: Pick Release process could not allocate 1500 of item CFG-HHM-00107 for order 110100163 as there was insufficient quantity available Or Inventory allocations have failed, and the line has been back ordered.

STEPS
1. Run pick release for this item.
2. The issue happens for one specific item.

Changes

It was working before. It stopped working 2 days ago.

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
 Investigation Steps
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.