Error During R12.2 Upgrade - Encounter Error Unique Constraint (WSH.WSH_LOCATIONS_U1) violated

(Doc ID 2020178.1)

Last updated on MARCH 08, 2017

Applies to:

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


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