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

Last updated on MARCH 08, 2017

Applies to:

Oracle Depot Repair - Version 11.5.10.2 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.
***Checked for relevance on 13-Jun-2014***

Symptoms

On an 11.5.10 instance, when attempting to run the 'Depot Repair Shipment Update' concurrent process, 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
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 retur



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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms