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 = CMP and Structure number = 101 (APPID=800)

 Dear DBAS,

While we were applying R12.ATG_PF.C.delta.8 - 28840844 on 12.2.8 instance. It failed with below error.

from patch log file

===============

ATTENTION: All workers either have failed or are waiting:

           FAILED: file fdfcmp       on worker  1.

ATTENTION: Please fix the above failed worker(s) so the manager can continue.

From worker1 log file

================

Application Id: 800

    Short Name: PER

          Name: Human Resources

Flexfield Code: CMP

          Name: Competence Flexfield

 Structure Num: 101

          Code: COMPETENCE_FLEXFIELD

          Name: Competence Flexfield

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 = CMP and Structure number = 101 (APPID=800)

FDFBKS: REQUIRED constraint specified for the Default Attribute qualifier is not satisfied

Since there wasn't direct steps mentioned in ML. We have raised an Sr and suggested to have below steps.

Go to 1. System Administrator >> Application > Flexfield>> Key> On Flex Filed title - Competence Flexfield and Unfreeze flexfiled definition then Go to segments and click on Flex field qualifiers. 

Enable check box for Default attribute and save it.

Then come to main form and enable check box for freeze flexfield definition and click on compile.

Now it compiles successfully

Continue with the patch using the below command.

adop phase=apply patches=28840844 workers=12 patchtop=/u01/app/****/Patch/220419-08028 abondon=no restart=yes