ITPub博客

首页 > Linux操作系统 > Linux操作系统 > This value is already in use for this value set

This value is already in use for this value set

原创 Linux操作系统 作者:susie0409 时间:2012-04-13 11:11:12 0 删除 编辑

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/,如需转载,请注明出处,否则将追究法律责任。

上一篇: global purchase
下一篇: learn mark
请登录后发表评论 登录
全部评论

注册时间:2009-09-30

  • 博文量
    115
  • 访问量
    260663