12.1 Upgrade has Invalid Key Flexfield View (KFV) with Error VIEW_HAS_FAILED_CHECK_LOG_FILE (Doc ID 975083.1)

Last updated on OCTOBER 27, 2022

Applies to:

Symptoms

Applying R12.1 maintenance pack has failed workers compiling KFV

Here is the log file:
$ cat /d70/apps/apps_st/appl/admin/r12two/log/l9193703.req
+---------------------------------------------------------------------------+
Application Object Library: Version : 12.0.0
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
module:
+---------------------------------------------------------------------------+
Current system time is 13-NOV-2009 09:27:25
+---------------------------------------------------------------------------+
CREATE OR REPLACE VIEW MTL_CATEGORIES_B_KFV
AS SELECT 'View generation has failed. Check log file for error messages' VIEW_HAS_FAILED_CHECK_LOG_FILE
FROM SYS.DUAL
+---------------------------------------------------------------------------+


Here is the error in the worker log for MTL_CATEGORIES_B_KFV

/d70/apps/apps_st/appl/fnd/12.0.0/bin/FNDFFVGN &ui_apps 0 Y 2 401 'MCAT' 'MTL_CATEGORIES_B_KFV' 'N'
Log filename : /d70/apps/apps_st/appl/admin/r12two/log/l9193703.req
Report filename : /d70/apps/apps_st/appl/admin/r12two/out/o9193703.out

AD Worker error:
The above program failed with error code 1.
See the AD Worker log file and/or the program log file for details.

Changes

Applied R12.1 maintenance pack

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.