ORA-20001: FND-ORG_ID PROFILE CANNOT READ

一天用户说在输入帐号密码后，不能登录系统，有报以下错误信息：

ORA-20001: FND-ORG_ID PROFILE CANNOT READ: N, OPTION, MO: Operating Unit has been detected in FND_GLOBAL.INITIALIZE.　。

 

在Ｍｅｔａｌｉｎｋ　上查到一篇解决办法，如下：

 

Subject:  Unable to login: &REASON has been detected in &ROUTINE
  Doc ID:  Note:311329.1 Type:  PROBLEM
  Last Revision Date:  28-NOV-2006 Status:  PUBLISHED

In this Document
  Symptoms
  Changes
  Cause
  Solution

 

--------------------------------------------------------------------------------

 

Applies to: Oracle Application Object Library - Version: 11.5.5 to 11.5.10
This problem can occur on any platform.
Unable to login into applications. So, everything gets effected. SymptomsWhen logging into the applications, we get the following error:

Oracle error &ERRNO: &REASON has been detected in &ROUTINE.

We will be unable to login using none of the seeded users nor custom users. Applications will not allow any user to be logged in.

ChangesChange in Profile option "MO: Operation Unit"

CauseFor a VISION instance(only), if the Profile option "MO: Operation Unit" (short name for this profile options is ORG_ID) is changed to any other value apart from "Vision Operations", we encounter the above specified error.

Another place where we can check the error is when we run adstrtal.sh or adstpall.sh scripts. The following errors can be found in the log file:

Oracle error -20001: ORA-20001: FND-ORG_ID PROFILE CANNOT READ: N, OPTION, MO: Operating Unit has been detected in FND_GLOBAL.INITIALIZE.

SolutionFollowing are steps to change the profile option from backend:

1. Get the Profile option ID using the following query:

SQL> Select PROFILE_OPTION_ID,PROFILE_OPTION_NAME from fnd_profile_options
where PROFILE_OPTION_NAME ='ORG_ID';

2. Run the following procedure which changes the profile option:

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;

3) Restart the apache server　（可以不做）

from: http://www.erp100.com/1194-6758555.html