My Oracle Support Banner

Depot Repair Shipment Update Process Errors: 'There is no instance found for the serial number (<Serial Number>)' (Doc ID 970165.1)

Last updated on JULY 14, 2020

Applies to:

Oracle Depot Repair - Version 11.5.10.2 to 12.2.8 [Release 11.5 to 12.2]
Information in this document applies to any platform.
CSDDRDSU

Symptoms

When attempting to run the 'Depot Repair Shipment Update' (CSDDRDSU) concurrent program, the following error occurs:

ERROR
-----------------------

There is no instance found for the serial number (<Serial Number>)
ORA-01086: savepoint 'SO_SHIP_UPDATE' never established
ORA-01086: savepoint 'SHIPMENT_LINES' never established
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-01422: exact fetch returns more than requested number of rows in Package CSD_UPDATE_PROGRAMS_PVT Procedure SHIPMENT_UPDATE


The issue can be reproduced at will by running the 'Depot Repair Shipment Update' concurrent program.

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.