Patch 11798107 failed on fvclmupg.sql with error ORA-00904: "CONTACT_FAX": Invalid Identifier (Doc ID 1379948.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Payables - Version 12.0.6 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.
Patch 11798107 failed on fvclmupg.sql with error ORA-00904: "CONTACT_FAX": Invalid Identifier


Symptoms

Assigned: file fvclmupg.sql on worker 1 for product fv username FV.

Time is: Wed Nov 16 2011 16:21:40

FAILED: file fvclmupg.sql on worker 1 for product fv username FV.

Time is: Wed Nov 16 2011 16:21:40

ATTENTION: All workers either have failed or are waiting:

FAILED: file fvclmupg.sql on worker 1.

ATTENTION: Please fix the above failed worker(s) so the manager can continue.

sqlplus -s APPS/***** @/clone/CLONE/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

Changes

Apply patch 11798107

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms