Depot Repair Shipment Update Process Errors: 'There is no instance found for the serial number (<Serial Number>)'
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
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