ORA-20001: Could Not Apply Crossedition Trigger "MSC_PLANS_F1": ORA-20001 (Doc ID 2900188.1)

Last updated on OCTOBER 06, 2022

Applies to:

Symptoms

On : 12.2.6 version, Patch Application Issues

Patch application failed while applying 12.2.6 release update pack(21900901)


ERROR

Time is: Wed Sep 21 2022 20:58:46
  FAILED: file AD_ZD_TABLE_APPLY.sql on worker 1 for product ad username APPLSYS.
Time is: Wed Sep 21 2022 20:59:06
ATTENTION: All workers either have failed or are waiting:
  FAILED: file AD_ZD_TABLE_APPLY.sql on worker 1.
ATTENTION: Please fix the above failed worker(s) so the manager can continue.
Current time is: Wed Sep 21 2022 20:59:06

sqlplus -s APPS/***** @/<dir>/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/AD_ZD_TABLE_APPLY.sql MSC_PLANS_F1'
Connected.

PL/SQL procedure successfully completed.

BEGIN AD_ZD_TABLE.APPLY('MSC_PLANS_F1'); END;
*
ERROR at line 1:
ORA-20001: Could not apply crossedition trigger "MSC_PLANS_F1": ORA-20001:
Parallel update task failed: "MSC_PLANS_F1" status=9 Error:
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 1843
ORA-06512: at line 1

Time when worker failed: Wed Sep 21 2022 20:58:45


STEPS

The issue can be reproduced at will with the following steps:
1. Apply patch: 21900901 - ORACLE E-BUSINESS SUITE 12.2.6 RELEASE UPDATE PACK

Changes

Cause

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