14733700:R12.AP.A 12.0.4 fvclmupg.sql failes with PL/SQL: ORA-00904: "CONTACT_FAX": invalid identif
Gonzalo says:
Our dba tried to apply the requested patch 14733700:R12.AP.A and received the following adpatch error:
FAILED: file fvclmupg.sql on worker 1.
ATTENTION: Please fix the above failed worker(s) so the manager can continue.
The log adworke001.log contained the following error message:
sqlplus -s APPS/***** @/u11/oracle/erpdev/apps/apps_st/appl/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
We found a similar bug in Metalink:
Patch 11798107 failed on fvclmupg.sql with error ORA-00904: "CONTACT_FAX": Invalid Identifier [ID 1379948.1]