My Oracle Support Banner

ID <value> for the flexfield segment <segment> does not exist in the value set <value set> (Doc ID 1522826.1)

Last updated on OCTOBER 31, 2019

Applies to:

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

Symptoms

On : 12.1.3 version,

1.Getting below message when trying to end date cost center

ID <LAST_NAME>, <SALUTATION> <FIRST_NAME> <MIDDLE NAME> for the flexfield segment Branch Manager does not exist in the value set PO_SRS_EMPLOYEE.
ID <LAST_NAME>, <SALUTATION> <FIRST_NAME> <MIDDLE NAME> for the flexfield segment Cost Center Manager does not exist in the value set NHLS_SRS_EMPLOYEES.
and when
Try removing ‘Enabled’ check box, you will get the error message:
FRM-40654: Record has been updated. Requery to see the change


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Select “NHLS_COST_CENTER” value set and enter value “94062”
 
Click on “Find” button.
See ID <value> for the flexfield segment <segment> does not exist in the value set <value set>.
Try removing ‘Enabled’ check box, you will get additional error message:
FRM-40654: Recod has been updated. Requery to see the change


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot disable a segment value

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
 <Internal_Only>
7. Based on the results from the script, update the corresponding Attributes that show extra spaces for a particular value within a value set. The Attribute numbers may vary:
  make a backup of table fnd_flex_values
create table <backup table name> as select * from <table name>;
 update fnd_flex_values
set attribute1 = rtrim(ltrim(attribute1)),
  attribute2 = rtrim(ltrim(attribute2))
  attribute3 = rtrim(ltrim(attribute3))
  attribute4 = rtrim(ltrim(attribute4))
where flex_value_set_id = {value set id}
and flex_value ={flex value};
commit;
 </Internal_Only>
 
 
References


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