Interface Trip Stop Fails Calling Program WSH_LOCATIONS_PKG.Get_Intransit_Time Due to Unexpected Error ORA-01422: "exact fetch returns more than requested number of rows"
(Doc ID 2695053.1)
Last updated on AUGUST 27, 2020
Applies to:Oracle Shipping Execution - Version 12.1 and later
Information in this document applies to any platform.
On : 12.1.3 version, Interface Trip Stop
When attempting to run the interface trip stop
the following error occurs.
Calling program WSH_LOCATIONS_PKG.Get_Intransit_Time
123456(aka the number for the delivery_detail_id): Interface detail to inventory failed with unexpected error
The unexpected error is ORA-01422: exact fetch returns more than requested number of rows
Unexpected error has occured. Oracle error message is ORA-01422: exact fetch returns more than requested number of rows
The issue cannot be reproduced at will
--Just this one Internal Sales Order is affected
--Only occurs in production
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