My Oracle Support Banner

Applying 26787767 AD_ZD_TABLE_APPLY.sql PA_CC_ORG_RELATIONSHIPS_F1 Fails With ORA-00001 (Doc ID 2576379.1)

Last updated on DECEMBER 12, 2023

Applies to:

Oracle Project Foundation - Version 12.2.8 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.8 version, Upgrade

Applying 12.2.8 update worker fails with below error:

PL/SQL procedure successfully completed.

BEGIN AD_ZD_TABLE.APPLY('PA_CC_ORG_RELATIONSHIPS_F1'); END;

*
ERROR at line 1:
ORA-20001: Could not apply crossedition trigger
"APPS"."PA_CC_ORG_RELATIONSHIPS_F1": ORA-20001: Parallel update task failed:
"PA_CC_ORG_RELATIONSHIPS_F1" status=8 Error: ORA-00001: unique constraint
(PA.PA_CC_ORG_RELATIONSHIPS_U1) violated
ORA-06512: at "APPS.AD_ZD", line 26
ORA-06512: at "APPS.AD_ZD_TABLE", line 19
ORA-06512: at "APPS.AD_ZD_TABLE", line 1784
ORA-06512: at line 1

 

ERROR:
"PA_CC_ORG_RELATIONSHIPS_F1" status=8 Error: ORA-00001: unique constraint



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


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