Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

During 11i to R12 upgrade, while running zxgeotoratesmi41.sql, getting following error ORA-00001: un

edited Aug 20, 2021 10:03AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 6 commentsAnswered
hi,

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center