My Oracle Support Banner

Patch Failing With "CREATE OR REPLACE VIEW MTL_CATEGORIES_B_KFV for FNDFFVGN" and FNDFFVGN Generating With "FDFQPC unable to allocate temporary 64K memory for code combination" (Doc ID 2533145.1)

Last updated on SEPTEMBER 06, 2023

Applies to:

Oracle Application Object Library - Version 12.2 to 12.2 [Release 12.2]
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version, Patch Application Issues


While applying 26787767 (12.2.8) its failing for 6 workers with FAILED: file FNDFFVGN error

The adworker log file Says out of memory error as below:


ERROR
-----------------------
Cause: FDFQPC unable to allocate temporary 64K memory for code combination QuickPick statement because the system is out of memory.
Action: Contact your system administrator or support representative. (ROUTINE=FDFKCV)
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


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply patch 26787767
2. The adworker fails with error


Unable to finish upgrade.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


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