Error During R12.2 Upgrade - Encounter Error Unique Constraint (WSH.WSH_LOCATIONS_U1) violated
(Doc ID 2020178.1)
Last updated on JUNE 07, 2021
Applies to:
Oracle Shipping Execution - Version 12.2.2 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2.2 version, Upgrade related issues
When attempting to apply upgrade patch for release 12.2.2,
the following error occurs.
ERROR
-----------------------
sqlplus -s APPS/***** @/oscarpoc/oscart/erpapp/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/oscarpoc/oscart/erpapp/fs1/EBSapps/appl/wsh/12.0.0/patch/115/sql/wsh_elup.sql &un_ar &batchsize 1 24'
Connected.
PL/SQL procedure successfully completed.
DECLARE
*
ERROR at line 1:
ORA-00001: unique constraint (WSH.WSH_LOCATIONS_U1) violated
ORA-06512: at line 37
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply upgrade patch
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 |