ERP里删除或者修改业务实体后出错

问题症状：登陆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  测试

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

转载于:http://blog.itpub.net/13561774/viewspace-591083/