APP-FND-00690: Program error: The data that defines the flexfield on this field may be inconsistent (Doc ID 1337417.1)

Last updated on DECEMBER 10, 2013

Applies to:

Oracle Inventory Management - Version 12.1.2 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.2 version, Other Inventory Issues

When attempting to retrieve specific item category set, found following error message.

ERROR
-----------------------
APP-FND-00690: Program error: The data that defines the flexfield on this field may be inconsistent.

Inform your system administrator that the routine FND_FLEX_SERVER2.get_qualsegs() could not find any segments for the flexfield specified by application id = 401, Code = MCAT and structure number = 2

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. When customer review the categories set, the error APP-FND-00690 occurs.
2. Customer try to unfreeze the DFF, and then freeze and compile it.
3. The problem still there, and customer change system option to "Validation Flexfild on Server" to "No", but it is not working and it will close alll form when customer go to that category set record.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms