My Oracle Support Banner

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.

Symptoms

On : 12.1.3 version, Interface Trip Stop

When attempting to run the interface trip stop
the following error occurs.

ERROR

  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


STEPS
The issue cannot be reproduced at will

--Just this one Internal Sales Order is affected
--Only occurs in production


Changes

 

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
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.