Question

oracle财务系统错误app-fnd-00027

oracle财务系统错误app-fnd-00027

Answer 1

英文的错误信息如下：
APP-FND-00027:Oracle Application has detected that the current NLS_LANG or NLS_DATE_LANGUAGE environment variables produce valuse for the mask 'MOD' that are greater than 3 bytes.Please notify your System Administrator that a different NLS_DATE_LANGUAGE must be specified.The system cannot be run with the current configuration.

只有这此用户报错，其它的用户没事。[@more@]今天也遇到此问题,一般是ICX：日期语言 的配置文件值有错.检查过此配置文件定义,用户是不可更新的.但是出现此错误,表示用户层的值出错了.
解决方法如下:
先查询地点层的设置
select USER_PROFILE_OPTION_NAME, PROFILE_OPTION_VALUE
from fnd_profile_options_vl fpo, fnd_profile_option_values fpov
where PROFILE_OPTION_NAME like 'ICX_D%'
and fpo.PROFILE_OPTION_ID = fpov.PROFILE_OPTION_ID
and LEVEL_ID = 10001
AND FPO.USER_PROFILE_OPTION_NAME='ICX：日期语言'
再查询错误的用户层的设置
select USER_PROFILE_OPTION_NAME, PROFILE_OPTION_VALUE
from fnd_profile_options_vl fpo, fnd_profile_option_values fpov
where PROFILE_OPTION_NAME like 'ICX_D%'
and fpo.PROFILE_OPTION_ID = fpov.PROFILE_OPTION_ID
and LEVEL_ID = 10004
AND FPO.USER_PROFILE_OPTION_NAME='ICX：日期语言'
and fpov.level_value=&user_id
如果不同,将用户层设置修改为地点层的即可.注意用SQL检查,界面看到的不一定准确.

1.将'ICX：日期语言'修改为用户层可修改/可更新
2.用系统管理员,将该用户的'ICX：日期语言'的配置文件值改为同地点层一致.
3.将'ICX：日期语言'设置修改回来.