ORA-20001: FND-ORG_ID profile cannot read

One day, the user said that after entering the account password, he could not log on to the system and reported the following error message:

ORA-20001: FND-ORG_ID profile cannot read: N, option, MO: operating unit has been detected in fnd_global.initialize ..

 

Find a solution on Metalink as follows:

 

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 pinned Ted. 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 (which can be left empty)

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