- 论坛徽章:
- 0
|
问题症状:登陆EBS的时候输入用户名和口令后提示 ERROR PAGE
停apache的时候报错
Oracle error -20001: ORA-20001: FND-ORG_ID PROFILE CANNOT READ: N, OPTION, MO: Operating Unit
has been detected in FND_GLOBAL.INITIALIZE.
处理:
查询:
select pfv.PROFILE_OPTION_VALUE
from FND_PROFILE_OPTION_VALUES pfv, fnd_profile_options pfo
where pfv.PROFILE_OPTION_ID = pfo.PROFILE_OPTION_ID
and pfv.APPLICATION_ID =0
and pfv.level_id = 10001
and pfo.PROFILE_OPTION_NAME ='ORG_ID'
查出结果1991
select site_enabled_flag , resp_enabled_flag , user_enabled_flag
from fnd_profile_options
where profile_option_name = 'ORG_ID' and start_date_active <= sysdate and nvl(end_date_active, sysdate) >= sysdate ;
查出三个结果都是Y
如果不是Y,执行
update fnd_profile_options
set site_enabled_flag = 'Y' , resp_enabled_flag = 'Y' , user_enabled_flag = 'Y'
where profile_option_name = 'ORG_ID' and start_date_active <= sysdate and nvl(end_date_active, sysdate) >= sysdate ;
之后在plsql执行
DECLARE stat boolean;
BEGIN dbms_output.disable;
dbms_output.enable(100000);
stat := FND_PROFILE.SAVE('ORG_ID',1991, 'SITE');
IF stat THEN dbms_output.put_line( 'Stat = TRUE - profile updated' );
ELSE dbms_output.put_line( 'Stat = FALSE - profile NOT updated' );
END IF;
commit;
END;
之后重启apache 测试 |
|