12.2 E-Business Suite Upgrade Errors with "ORA-20001: Cannot apply invalid crossedition trigger" When Applying EBS 12.2.4 RUP Patch (17919161) (Doc ID 2094808.1)

Last updated on MARCH 21, 2016

Applies to:

Oracle Applications DBA - Version 12.2 to 12.2.4 [Release 12.2Cloud]
Information in this document applies to any platform.

Symptoms

E-Business Suite 12.2, Upgrade related issues

When applying 12.2.4 RUP <Patch 17919161>, multiple cross edition trigger errors occur:

ORA-20002: Cannot apply invalid crossedition trigger errors

ERROR
-----------------------
BEGIN AD_ZD_TABLE.APPLY('FV_GTAS1_REPORT_T2_F1'); END;

*
ERROR at line 1:
ORA-20001: Cannot apply invalid crossedition trigger: FV_GTAS1_REPORT_T2_F1
ORA-06512: at "APPS_AOL.AD_ZD", line 26
ORA-06512: at "APPS_AOL.AD_ZD_TABLE", line 19
ORA-06512: at "APPS_AOL.AD_ZD_TABLE", line 1683
ORA-06512: at line 1
:
:
BEGIN AD_ZD_TABLE.APPLY('FV_OPERATING_UNITS_ALL_F1'); END;

*
ERROR at line 1:
ORA-20001: Cannot apply invalid crossedition trigger: FV_OPERATING_UNITS_ALL_F1
ORA-06512: at "APPS_AOL.AD_ZD", line 26
ORA-06512: at "APPS_AOL.AD_ZD_TABLE", line 19
ORA-06512: at "APPS_AOL.AD_ZD_TABLE", line 1683
ORA-06512: at line 1
:
:
BEGIN AD_ZD_TABLE.APPLY('JE_IT_TRX_ABOVE_THR_X1'); END;

*
ERROR at line 1:
ORA-20001: Cannot apply invalid crossedition trigger: JE_IT_TRX_ABOVE_THR_X1
ORA-06512: at "APPS_AOL.AD_ZD", line 26
ORA-06512: at "APPS_AOL.AD_ZD_TABLE", line 19
ORA-06512: at "APPS_AOL.AD_ZD_TABLE", line 1683
ORA-06512: at line 1
:
:
BEGIN AD_ZD_TABLE.APPLY('PO_BULKLOAD_INTF_F1'); END;

*
ERROR at line 1:
ORA-20001: Cannot apply invalid crossedition trigger: PO_BULKLOAD_INTF_F1
ORA-06512: at "APPS_AOL.AD_ZD", line 26
ORA-06512: at "APPS_AOL.AD_ZD_TABLE", line 19
ORA-06512: at "APPS_AOL.AD_ZD_TABLE", line 1683
ORA-06512: at line 1
:
:
BEGIN AD_ZD_TABLE.APPLY('JE_IT_TRX_LINES_X1'); END;

*
ERROR at line 1:
ORA-20001: Cannot apply invalid crossedition trigger: JE_IT_TRX_LINES_X1
ORA-06512: at "APPS_AOL.AD_ZD", line 26
ORA-06512: at "APPS_AOL.AD_ZD_TABLE", line 19
ORA-06512: at "APPS_AOL.AD_ZD_TABLE", line 1683
ORA-06512: at line 1
:
:
BEGIN AD_ZD_TABLE.APPLY('JE_IT_ABOVE_THR_HDR_X1'); END;

*
ERROR at line 1:
ORA-20001: Cannot apply invalid crossedition trigger: JE_IT_ABOVE_THR_HDR_X1
ORA-06512: at "APPS_AOL.AD_ZD", line 26
ORA-06512: at "APPS_AOL.AD_ZD_TABLE", line 19
ORA-06512: at "APPS_AOL.AD_ZD_TABLE", line 1683
ORA-06512: at line 1


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply 12.2.4 RUP <Patch 17919161>

Cause

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