My Oracle Support Banner

INVIDCAT Cannot Save While Creating Item Categories, Receive Error "Value ... for the flexfield segment ... does not exist ..." (Doc ID 467565.1)

Last updated on FEBRUARY 01, 2023

Applies to:

Oracle Item Master - Version 12.0.0 and later
Information in this document applies to any platform.
FORM:INVIDCAT.FMB - Define Category

Symptoms

When attempting to create item categories in Define Categories form (INVIDCAT), the following error occurs at saving.

Recompiling the key flexfield does not help and it has been verified that the Flexfield View Generator (FDFVGN) is not failing. (there is no error in the request log)

The below error message is raised for a segment based on an independent value set.
It does not occur for all segment values in this value set.

The problematic values are active / enabled.

In the below error message, the value is truncated to 40 characters.
The problem only occurs for values with higher length, eg with more than 40 characters.
On the related value set, format validation type is Char and maximum size is 50.

ERROR
-----------------------------
"Value <value> for the flexfield segment <segment> does not exist in the value set <value set name>."

STEPS
-----------------------------
The issue can be reproduced at will with the following steps:
1. Define an independent value set.
Set format validation type to Char and maximum size to 50.
2. Create a value in the value set with more than 40 characters, say 45 characters.
3. Define an Item Categories key flexfield structure with a segment based on above value set.
Navigation: Inventory: (N) Setup > Inventory > Flexfields > Key > Segments
Compile the key flexfield and ensure there is no error in the request log of the Flexfield View Generator.
4. Go to Define Categories form.
Navigation: Inventory: (N) Setup > Items > Categories > Category Codes
5. Create a new record.
6. Select the above structure.
7. In the enter key flexfield segment values window select the above created value.
8. Press OK to quit the flexfield window.
9. You are back in the Categories window.
10. Save.
11. See the reported error.

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


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