patch 13520870 fails running fvclmupg.sql PL/SQL: ORA-00904: "CONTACT_FAX": invalid identifier
Applying patch 13520870 failed :
FAILED: file fvclmupg.sql on worker 1 for product fv username FV
sqlplus -s APPS/***** @APPL_TOP/fv/12.0.0/patch/115/sql/fvclmupg.sql
contact_fax = rec.ach_fax
*
ERROR at line 51:
ORA-06550: line 51, column 9:
PL/SQL: ORA-00904: "CONTACT_FAX": invalid identifier
ORA-06550: line 47, column 9:
PL/SQL: SQL Statement ignored
File name : /fvclmupg.sql version 120.0.12000000.5
----------------------------------
loop
FND_FILE.PUT_LINE(FND_FILE.LOG,
'Updating for bank_account_id: '||rec.bank_account_id);
update iby_ext_bank_accounts set
contact_name = null,
contact_phone = nvl(rec.ach_us_phone, rec.ach_non_us_phone),
contact_email = rec.ach_email,
Tagged:
0