During 11i to R12 upgrade, while running zxgeotoratesmi41.sql, getting following error ORA-00001: un
We are currently running EBS 11iCU2 to R12 Upgrade (database version=11.2.0.3, application version=11.5.10.2, OS= Linux 2.6.32-358.el6.x86_64 )
We are currently in phase "upg+82" and 10541 jobs remaining (current phase=A257):
when running this zxgeotoratesmi41.sql, we are getting the following error
====================================================================================================
sqlplus -s APPS/***** @/Apps/oaperf/product/12.1/zx/12.0.0/patch/115/sql/zxgeotoratesmi41.sql &un_ar &batchsize 6 48
DECLARE
*
ERROR at line 1:
ORA-00001: unique constraint (ZX.ZX_JURISDICTIONS_B_U2) violated
ORA-06512: at line 41
======================================================================================================
We have already applied the CUP patches and oracle recommended pre-install patches.
The version of the zxgeotoratesmi41.sql file is
strings -a /Apps/oaperf/product/12.1/zx/12.0.0/patch/115/sql/zxgeotoratesmi41.sql | grep Header