Error During R12.2 Upgrade - Encounter Error Unique Constraint (WSH.WSH_LOCATIONS_U1) violated
(Doc ID 2020178.1)
Last updated on MARCH 08, 2017
Oracle Shipping Execution - Version 12.2.2 and later
Information in this document applies to any platform.
On : 12.2.2 version, Upgrade related issues
When attempting to apply upgrade patch for release 12.2.2,
the following error occurs.
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'
PL/SQL procedure successfully completed.
ERROR at line 1:
ORA-00001: unique constraint (WSH.WSH_LOCATIONS_U1) violated
ORA-06512: at line 37
The issue can be reproduced at will with the following steps:
1. Apply upgrade patch
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
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.
|This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.|