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:

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms