Upgrade Fails On Script Zxmigratefc.sql Running Driver 6678700

(Doc ID 1594893.1)

Last updated on NOVEMBER 25, 2015

Applies to:

Oracle E-Business Tax - Version 12.2.1 and later
Oracle Payables - Version 12.2.4 to 12.2.4 [Release 12.2]
Information in this document applies to any platform.


On : 12.2.1 version, Upgrade and Migration

When attempting to upgrade to R12.1.3,
the following error occurs.

Upgrading from 11i to R12.1.1, running upgrade driver patch 6678700 fails with the following error


sqlplus -s APPS/***** @/im/rwupg01/apps/apps_st/appl/zx/12.0.0/patch/115/sql/zxmigratefc.sql
ERROR at line 1:
ORA-00001: unique constraint (ZX.ZX_FC_CODES_B_U2) violated
ORA-06512: at "APPS.ZX_FC_MIGRATE_PKG", line 4345
ORA-06512: at "APPS.ZX_FC_MIGRATE_PKG", line 5255
ORA-06512: at line 6

The issue has the following business impact:
Unable to complete upgrade process.


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