My Oracle Support Banner

Error During Pick or Put-away: single-row subquery returns more than one row (Doc ID 2146224.1)

Last updated on MARCH 23, 2021

Applies to:

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


On :  12.2.4 version, Pick Release Process

Example of Error during Put-away  

User is getting the following error message while trying to do put-away for LPN.
The 'Receiving Transaction Processor' completed successfully but the 'Pre-generate Putaway Suggestions' completed in error.

"Error:Can not move this entire LPN|Put away rule fails to find a destination locator  that meets the rules restrictions.|ORA-01427: single-row subquery returns more than one row in Package WMS_Rule_PVT Procedure FetchPutaway. Press any key to continue"

Getting this error message when user enters LPN and clicks on Drop




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.