My Oracle Support Banner

ORA-20001: Could not apply invalid crossedition trigger Error While Applying Patch 29252621:R12.ICX.D (Doc ID 2719901.1)

Last updated on OCTOBER 14, 2020

Applies to:

Oracle iProcurement - Version 12.2.7 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.7 version, Installation and Configuration

When attempting to apply Patch 29252621:R12.ICX.D,
the following error occurs.

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

*
ERROR at line 1:
ORA-20001: Could not apply invalid crossedition trigger
"APPS"."POR_UDA_INTERFACE_F1": PLS-00049: bad bind variable
'NEW.DATA_LEVEL_1#1':: PLS-00049: bad bind variable 'NEW.DATA_LEVEL_2#1'::
PLS-00049: bad bind variable 'NEW.DATA_LEVEL_3#1'
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 1714
ORA-06512: at line 1

Patch Log shows following Error:
-----------------------------------
FAILED: file AD_ZD_TABLE_APPLY.sql on worker 1 for product ad username APPLSYS.
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.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply Patch 29252621:R12.ICX.D
2. Gets the above error  

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
Cause
Solution
References


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