FVCLMUPG.SQL: Patch 9000001 Fails with ERROR: FAILED: file fvclmupg.sql : Ora-00904: "Division_name": Invalid Identifier (Doc ID 1321041.1)

Last updated on FEBRUARY 25, 2016

Applies to:

Oracle U.S. Federal Financials - Version 12.1.2 and later
Information in this document applies to any platform.
fvclmupg.sql; Ora-00904

Symptoms

On : 12.1.2 version, Product Issues

When attempting to apply patch 9000001 the following error occurs.

ERROR
-----------------------
Time is: Mon Apr 25 2011 01:10:23

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

Start time for file is: Mon Apr 25 2011 01:10:24

sqlplus -s APPS/***** @/opt/oracle/apps/apps_st/appl/fv/12.0.0/patch/115/sql/fvclmupg.sql
DIVISION_NAME = rec.division_name
*
ERROR at line 39:
ORA-06550: line 39, column 10:
PL/SQL: ORA-00904: "DIVISION_NAME": invalid identifier
ORA-06550: line 35, column 10:
PL/SQL: SQL Statement ignored

Time when worker failed: Mon Apr 25 2011 01:10:24

Changes

Applying patch 9000001.

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