During Patching or Upgrade to Later R12.2.x Version, Error Occurs - ORA-20001: Could not apply invalid crossedition trigger on APPS.POR_UDA_INTERFACE_F1 (Doc ID 2719901.1)

Last updated on NOVEMBER 02, 2022

Applies to:

Symptoms

In Oracle Applications / Oracle iProcurement, when applying a one-off patch such as Patch 29252621:R12.ICX.D, or during upgrade to a later R12.2.x release such as Release 12.2.11, an error occurs when trying to create crossedition trigger POR_UDA_INTERFACE_F1.


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


   -- OR --


sqlplus -s APPS/***** @/oracle/apps/DEV/fs2/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/oracle/apps/DEV/fs2/EBSapps/appl/ad/12.0.0/patch/115/sql/AD_ZD_TABLE_APPLY.sql POR_UDA_INTERFACE_F1'
Connected.

ERROR at line 1:
ORA-20001: Could not apply invalid crossedition trigger
"APPS"."POR_UDA_INTERFACE_F1": PLS-00049: bad bind variable 'NEW.ATTR_VALUE_NUM'

Changes

Apply a one-off patch for product ICX, or upgrade to later R12.2.x release such as Release 12.2.11 (it can occur for other R12.2.x releases also).

Cause

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