Cannot Receipt for Inter Organization Transfer with Serial Because MTL_SERIAL_NUMBERS_TEMP Stuck
(Doc ID 2594019.1)
Last updated on SEPTEMBER 29, 2019
Applies to:Oracle Inventory Management - Version 12.2.3 and later
Information in this document applies to any platform.
When Inter-organization Transfer trying to receive, below error occur on PO_INTERFACE_ERRORS
INV_ALL_SQL_ERROR (ROUTINE=INV_RCV_INTERFACE_PVT.VALIDATE_LOT_SERIAL_INFO) (ERR_NUMBER=ORA-01422: exact fetch returns more than requested number of rows) (SQL_ERR=ORA-01422: exact fetch returns more than requested number of rows)
WMSINB-22605:Lot/Serial validation failed. Please check log for details.
Steps to Reproduce
- Cannot reproduce at will
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