Hi Experts,
- Applying the merged Patch 12.2.0 upgrade driver errors
ATTENTION: All workers either have failed or are waiting:
FAILED: file FNDFFVGN on worker 1.
FAILED: file FNDFFVGN on worker 3.
A) adworker1.log
$FND_TOP/bin/FNDFFVGN &ui_apps 0 Y 2 401 'MSTK' 'MTL_SYSTEM_ITEMS_B_KFV' 'Y'
Log filename : $APPL_TOP/admin/sid/log/l4090815.req
Report filename : $APPL_TOP/admin/sid/out/o4090815.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.
- cat $APPL_TOP/admin/sid/log/l4090815.req
APP-FND-01564: ORACLE error 4063 in FDFKDS_RAISE_KFF_STRUCTURE_COMPILED
Cause: FDFKDS_RAISE_KFF_STRUCTURE_COMPILED failed due to ORA-04063: package body "APPS.FND_FLEX_SERVER" has errors
ORA-06508: PL/SQL: could not find program unit being called: "APPS.FND_FLEX_SERVER"
ORA-06512: at line 3.
The SQL statement being executed at the time of the error was:
BEGIN
fnd_flex_server.raise_kff_structure_compiled(
:p_application_id,
:p_id_flex_code,
:p_id_flex_num);
END;
and was executed from the file &ERRFILE.
The data that defines the flexfield on this field may be inconsistent. Inform your system administrator that the function: FDFRKS could not find the s
tructure definition for the flexfield specified by Application = &APPL, Code = MSTK and St
CREATE OR REPLACE VIEW MTL_SYSTEM_ITEMS_B_KFV
AS SELECT 'View generation has failed. Check log file for error messages' VIEW_HAS_FAILED_CHECK_LOG_FILE
FROM SYS.DUAL
- cat $APPL_TOP/admin/sid/out/o4090815.out
The data that defines the flexfield on this field may be inconsistent. Inform your system administrator that the function: FDFRKS could not find the s
tructure definition for the flexfield specified by Application = &APPL, Code = MSTK and St
View Name: MTL_SYSTEM_ITEMS_B_KFV
Name Null? Type
------------------------------- -------- ----
VIEW_HAS_FAILED_CHECK_LOG_FILE CHAR(61)
B) adwork3.log
$FND_TOP/bin/FNDFFVGN &ui_apps 0 Y 3 401 'MTL_ITEM_CATALOG_GROUPS'
Log filename : $APPL_TOP/admin/sid/log/l4090813.req
Report filename : $APPL_TOP/admin/sid/out/o4090813.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.
- cat $APPL_TOP/admin/sid/log/l4090813.req
APP-FND-01564: ORACLE error 4063 in FDFDDS_RAISE_DFF_COMPILED
Cause: FDFDDS_RAISE_DFF_COMPILED failed due to ORA-04063: package body "APPS.FND_FLEX_SERVER" has errors
ORA-06508: PL/SQL: could not find program unit being called: "APPS.FND_FLEX_SERVER"
ORA-06512: at line 3.
The SQL statement being executed at the time of the error was:
BEGIN
fnd_flex_server.raise_dff_compiled(
:p_application_id,
:p_descriptive_flexfield_name);
END;
and was executed from the file &ERRFILE.
- cat $APPL_TOP/admin/sid/out/o4090813.out
-> return no value