Depot Repair Shipment Update Process Errors: 'There is no instance found for the serial number (<Serial Number>)'
(Doc ID 970165.1)
Last updated on FEBRUARY 24, 2019
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.
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
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
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 |
| Cause |
| Solution |
| References |