Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

14733700:R12.AP.A 12.0.4 fvclmupg.sql failes with PL/SQL: ORA-00904: "CONTACT_FAX": invalid identif

edited Jan 3, 2013 6:14AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 4 commentsAnswered ✓

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]

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center