ORA-20001: FND-ORG_ID PROFILE CANNOT READ when starting Apps 11i (Doc ID 400840.1)

Last updated on JANUARY 12, 2016

Applies to:

Oracle Applications Technology Stack - Version 11.5.10.0 to 11.5.10.2 [Release 11.5 to 11.5.10]
Information in this document applies to any platform.
Checked for relevance on 03-SEP-2013

Symptoms

Starting apache fails with:

adapcctl.sh version 115.43
Oracle error -20001: ORA-20001: FND-ORG_ID PROFILE CANNOT READ: N, OPTION, MO: Operating Unit
has been detected in FND_GLOBAL.INITIALIZE.
Starting Apache Web Server Listener (dedicated HTTP) ...
Oracle error -20001: ORA-20001: FND-ORG_ID PROFILE CANNOT READ: N, OPTION, MO: Operating Unit
has been detected in FND_GLOBAL.INITIALIZE.
Oracle error -20001: ORA-20001: FND-ORG_ID PROFILE CANNOT READ: N, OPTION, MO: Operating Unit
has been detected in FND_GLOBAL.INITIALIZE.
Starting Apache Web Server Listener (dedicated PLSQL) ...
Oracle error -20001: ORA-20001: FND-ORG_ID PROFILE CANNOT READ: N, OPTION, MO: Operating Unit
has been detected in FND_GLOBAL.INITIALIZE.

adapcctl.sh: exiting with status 0

 

Changes

You are not able to log to the application via f60cgi and have already tried to run the statements listed in

<Note 387581.1> How to Restore System Profile 'MO: Operating Unit' When it  has been Set to Blank 

     2. SQL>Select ORGANIZATION_ID from HR_ALL_ORGANIZATION_UNITS;

     3. SQL> Update FND_PROFILE_OPTION_VALUES
     set PROFILE_OPTION_VALUES = '<pick a numeric value from #2>'
     where PROFILE_OPTION_ID = 1991 
     and APPLICATION_ID =0
     and level_id = 10001;

     4. Commit;

and

<Note 249587.1>  ORA-20001 FND ORG_ID PROFILE CANNOT READ N OPTION MO

     DECLARE stat boolean;
     BEGIN dbms_output.disable;
    dbms_output.enable(100000);
     stat := FND_PROFILE.SAVE('ORG_ID', <value for the org_id, '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;

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms