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