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:
Oracle iProcurement - Version 12.2.4 and laterInformation in this document applies to any platform.
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
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 |
References |