2018-08-26 回答
英文的错误信息如下:
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_op