R12 upgrade driver failed while executing wsh_elup.sql
While performing upgrade from 11.5.10.2 to 12.1.1, we are facing the below issue:
Below error message for your reference:
Start time for file is: Tue Mar 05 2013 21:06:44
sqlplus -s APPS/***** @/la01/oracle/afteul/apps/apps_st/appl/wsh/12.0.0/patch/115/sql/wsh_elup.sql &un_ar &batchsize 32 32
DECLARE
*
ERROR at line 1:
ORA-00001: unique constraint (WSH.WSH_LOCATIONS_U1) violated
ORA-06512: at line 37
The table WSH_LOCATIONS is getting populated from HZ_PARTIES and HZ_PARTY_SITES, Hope it should have duplicate rows. Please advise on how to proceed with this.
Thanks