My Oracle Support Banner

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

Last updated on APRIL 25, 2023

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:

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.