R12: ZX/AR: While Migrating from R12.2.3 to R12.2.10 Getting Error for One Worker: ORA-00001: Unique Constraint (ZX.ZX_EXCEPTIONS_U2) Violated ORA-06512: At Line 3621
(Doc ID 2992797.1)
Last updated on AUGUST 07, 2024
Applies to:
Oracle E-Business Tax - Version 12.1.1 and laterInformation in this document applies to any platform.
Migrating from an earliest version of R12.2.X to a latest version of R12.2.X
Symptoms
While doing an upgrate to a latest version of Application R12.2.X, One of the Log workers is having the following error :
ORA-00001: unique constraint (ZX.ZX_EXCEPTIONS_U2) violated ORA-06512: at line 3621
This is the complete error and log
Index re-created and restarted the patch. I got the same error:
~~~ /ebs/amedev7/oracle/fs_ne/EBSapps/log/adop/363/XXXXX /apply/XXXXXX/ADOP_MRG_20231203_1701617696/log/u_90297619.log ~~~
ATTENTION: All workers either have failed or are waiting:
FAILED: file zxexemptmig1.sql on worker 2.
ATTENTION: Please fix the above failed worker(s) so the manager can continue.
Current time is: Tue Dec 05 2023 20:06:19
~~~ adwork002.log ~~~
Start time for file is: Tue Dec 05 2023 20:06:19
sqlplus -s APPS/***** @/ebs/amedev7/oracle/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/ebs/amedev7/oracle/fs1/EBSapps/appl/zx/12.0.0/patch/115/sql/zxexemptmig1.sql &un_ar &batchsize 1 16'
Connected.
PL/SQL procedure successfully completed.
DECLARE
*
ERROR at line 1:
ORA-00001: unique constraint (ZX.ZX_EXCEPTIONS_U2) violated
ORA-06512: at line 3621
~~~ /ebs/amedev7/oracle/fs_ne/EBSapps/log/adop/363/XXXXX /apply/XXXXXX/ADOP_MRG_20231203_1701617696/log/u_90297619.log ~~~
ATTENTION: All workers either have failed or are waiting:
FAILED: file zxexemptmig1.sql on worker 2.
ATTENTION: Please fix the above failed worker(s) so the manager can continue.
Current time is: Tue Dec 05 2023 20:06:19
~~~ adwork002.log ~~~
Start time for file is: Tue Dec 05 2023 20:06:19
sqlplus -s APPS/***** @/ebs/amedev7/oracle/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/ebs/amedev7/oracle/fs1/EBSapps/appl/zx/12.0.0/patch/115/sql/zxexemptmig1.sql &un_ar &batchsize 1 16'
Connected.
PL/SQL procedure successfully completed.
DECLARE
*
ERROR at line 1:
ORA-00001: unique constraint (ZX.ZX_EXCEPTIONS_U2) violated
ORA-06512: at line 3621
Changes
Upgrade to a latest version of the application.
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 |
References |