This value is already in use for this value set

Valueset Error: This value is already in use for this value set [ID 787827.1]

Cause
A translated value is missing from the FND_FLEX_VALUES_TL table.
Solution
Ensure there is a corresponding row for each installed language in the FND_FLEX_VALUES_TL and FND_FLEX_VALUES table:

a. Get the flex_value_set for the value set:

Select FLEX_VALUE_SET_ID
from FND_FLEX_VALUE_SETS
where FLEX_VALUE_SET_NAME =' ';

b. Display the values in that value set:

Select FLEX_VALUE_ID, FLEX_VALUE, ENABLED_FLAG
from FND_FLEX_VALUES
where FLEX_VALUE_SET_ID =
;


c. Display the corresponding rows in FND_FLEX_VALUES_TL for the values found in step b. Substitute the FLEX_VALUE_IDs returned in step b in the selection list below:

select language, description
from FND_FLEX_VALUES_TL
where FLEX_VALUE_ID in (,
,
);

d. There should be a corresponding row returned in step c for each value in step b, for each installed language. If not, then run the following to populate the FND_FLEX_VALUES_TL table:

Using adadmin please run Maintain multi-lingual tables:

- Menu Option 4 Maintain Applications Database Entities Menu
- Menu Option 3 Maintain multi-lingual tables

as we run the following query, the data missed in FND_FLEX_VALUES_TL

 

Select * --FLEX_VALUE_SET_ID
from apps.fND_FLEX_VALUE_SETS
where -- FLEX_VALUE_SET_ID=1012807  ---
FLEX_VALUE_SET_NAME  like '%';


 Select FLEX_VALUE_ID, FLEX_VALUE, ENABLED_FLAG
from apps.FND_FLEX_VALUES
where FLEX_VALUE_SET_ID =
1012787   and flex_value=

 select *
from apps.FND_FLEX_VALUES_TL
where FLEX_VALUE_ID in
( 301380);-- (301402, 139361, 301381)

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/15225049/viewspace-721070/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/15225049/viewspace-721070/