My Oracle Support Banner

While Upgrading From 12.2.3 To 12.2.8 Patch 26787767 (12.2.8 RELEASE UPDATE PACK) Failed With Error (Doc ID 2526027.1)

Last updated on MAY 19, 2020

Applies to:

Oracle Installed Base - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms

When attempting to apply patch 26787767 'ORACLE E-BUSINESS SUITE 12.2.8 RELEASE UPDATE PACK' via adop,
the following error occurs.

ERROR
-----------------------

sqlplus -s APPS/***** /app/fs2/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '.../app/fs2/EBSapps/appl/ad/12.0.0/patch/115/sql/AD_ZD_TABLE_APPLY.sql CSI_I_PRICING_ATTRIBS_H_F1'
Connected.

PL/SQL procedure successfully completed.

BEGIN AD_ZD_TABLE.APPLY('CSI_I_PRICING_ATTRIBS_H_F1'); END;

*
ERROR at line 1:
ORA-20001: Could not apply invalid crossedition trigger
"APPS"."CSI_I_PRICING_ATTRIBS_H_F1": PLS-00049: bad bind variable
'NEW.NEW_PRICING_ATTRIBUTE1':: PLS-00049: bad bind variable
'NEW.NEW_PRICING_ATTRIBUTE10':: PLS-00049: bad bind variable
'NEW.NEW_PRICING_ATTRIBUTE2':: PLS-00049: bad bind variable
'NEW.NEW_PRICING_ATTRIBUTE3':: PLS-00049: bad bind variable
'NEW.NEW_PRICING_ATTRIBUTE4':: PLS-00049: bad bind variable
'NEW.NEW_PRICING_ATTRIBUTE5':: PLS-00049: bad bind variable
'NEW.NEW_PRICING_ATTRIBUTE6':: PLS-00049: bad bind variable
'NEW.NEW_PRICING_ATTRIBUTE7':: PLS-00049: bad bind variable
'NEW.NEW_PRICING_ATTRIBUTE8':: PLS-00049: bad bind variable
'NEW.NEW_PRICING_ATTRIBUTE9':: PLS-00049: bad bind variable
'NEW.OLD_PRICING_ATTRIBUTE1':: PLS-00049: bad bind variable
'NEW.OLD_PRICING_ATTRIBUTE10':: PLS-00049: bad bind variable
'NEW.OLD_PRICING_ATTRIBUTE2':: PLS-00049: bad bind variable
'NEW.OLD_PRICING_ATTRIBUTE3':: PLS-00049: bad bind variable
'NEW.OLD_PRICING_ATTRIBUTE4':: PLS-00049: bad bind variable

Changes

 

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


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