My Oracle Support Banner

Upgrade Fails On Script Zxmigratefc.sql Running Driver 6678700 (Doc ID 1594893.1)

Last updated on FEBRUARY 05, 2019

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.

Symptoms

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

ERROR
-----------------------

sqlplus -s APPS/***** /appl/zx/12.0.0/patch/115/sql/zxmigratefc.sql
DECLARE
*
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


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

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.