My Oracle Support Banner

Flexfield Error "APP-FND-00668: The data that defines the flexfield on this field may be inconsistent" During Upgrade And The Flexfields Are Not Available At The Front End From English Session (Doc ID 2916784.1)

Last updated on DECEMBER 27, 2022

Applies to:

Oracle Human Resources - Version 12.2.10 and later
Information in this document applies to any platform.

Symptoms

During upgrade process, error is encountered for the below seeded Personal Analysis KFFs.

FR_PQH_MINISTRY_AWARDS
FR_PQH_NATIONAL_AWARD
JP_EDUC_BKGRD

ERROR
======

Application Id: 800
   Short Name: PER
         Name: Human Resources
Flexfield Code: PEA
         Name: Personal Analysis Flexfield
Structure Num: 1
         Code: JP_EDUC_BKGRD
         Name:  

Compilation aborted for current key flexfield...

Application Id: 800
   Short Name: PER
         Name: Human Resources
Flexfield Code: PEA
         Name: Personal Analysis Flexfield
Structure Num: 50170
         Code: FR_PQH_MINISTRY_AWARDS
         Name:  

Compilation aborted for current key flexfield...

Application Id: 800
   Short Name: PER
         Name: Human Resources
Flexfield Code: PEA
         Name: Personal Analysis Flexfield
Structure Num: 50170
         Code: FR_PQH_NATIONAL_AWARD
         Name:  

Compilation aborted for current key flexfield...

APP-FND-00668: The data that defines the flexfield on this field may be inconsistent. Inform your system administrator that the function: FDFRKS could not find the structure definition for the flexfield specified by Application = &APPL, Code = PEA and Structure number = 1 (APPID=800)
APP-FND-00874: Routine FDFBKS found no rows in table FND_ID_FLEX_STRUCTURES. Please contact your system administrator or support representative.

And when tried to compile the flexfields manually, the KFFs are not visible from front-end from English session.

STEPS
=====

The issue can be reproduced at will with the following steps:

1. Follow the RUP upgrade process and encounter the error.
2. Responsibility: System Administrator
3. Navigate to Application > Flexfield > Key > Segments > Personal Analysis Flexfield
4. Query FR_PQH_MINISTRY_AWARDS
5. The KFF is not visible from front-end.
6. Same is the case for the other two; FR_PQH_NATIONAL_AWARD, & JP_EDUC_BKGRD

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
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.