How To Prevent the Profile Option MO: Operating Unit being set to NULL at Site Level? (Doc ID 393560.1)

Last updated on JUNE 24, 2016

Applies to:

Oracle Application Object Library - Version 11.5.10.2 to 12.2 [Release 11.5 to 12.2]
Information in this document applies to any platform.
FORM:FNDPOMPV.FMB - Update System Profile Values
***Checked for relevance on 26-Nov-2012***

Goal

The profile option MO: Operating Unit is crucial in a Multi-Org environment. It is a requirement to have a profile option value at Site level at all times because the application will be unaccessible without it. Not a single application user will be able to login to system using their application User Name. Not even the System Administrator (SYSADMIN) will be able to login to restore the profile option value in case someone accidentally removed it.

Exception encountered at login (AppsLogin):

Error Page  
   
You have encountered an unexpected error. Please contact the System Administrator for assistance.  
Click here for exception details.


The exception details are the following:

oracle.apps.fnd.framework.OAException: Application: FND, Message Name: SQL_PLSQL_ERROR.
 Tokens: ROUTINE = AppsConnectionManager.appsInitialize(int,int,int,int,Connection):-1,-1,-1,0,oracle.jdbc.driver.OracleConnection@1106021;
 REASON = java.sql.SQLException: ORA-20001: Oracle error -20001: ORA-20001: FND-ORG_ID PROFILE CANNOT READ: N, OPTION, MO: Operating Unit
 has been detected in FND_GLOBAL.INITIALIZE.
ORA-06512: at "APPS.APP_EXCEPTION", line 72
ORA-06512: at "APPS.FND_GLOBAL", line 101
ORA-06512: at "APPS.FND_GLOBAL", line 1147
ORA-06512: at "APPS.FND_GLOBAL", line 620
ORA-06512: at line 1
; ERRNO = 20001; 
   at oracle.apps.fnd.framework.server.OAExceptionUtils.processAOLJErrorStack(OAExceptionUtils.java:988)
   at oracle.apps.fnd.framework.OACommonUtils.processAOLJErrorStack(OACommonUtils.java:866)
   at oracle.apps.fnd.framework.webui.OAPageBean.validateUser(OAPageBean.java:4656)
   at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:697)
...
   at org.apache.jserv.JServConnection.processRequest(JServConnection.java:456)
   at org.apache.jserv.JServConnection.run(JServConnection.java:294)
   at java.lang.Thread.run(Thread.java:595)
## Detail 0 ##
 oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_GENERIC_MESSAGE.
 Tokens: MESSAGE = java.sql.SQLException: ORA-20001: Oracle error -20001: ORA-20001: FND-ORG_ID PROFILE CANNOT READ: N, OPTION, MO: Operating Unit
 has been detected in FND_GLOBAL.INITIALIZE.
ORA-06512: at "APPS.APP_EXCEPTION", line 72
ORA-06512: at "APPS.FND_GLOBAL", line 101
ORA-06512: at "APPS.FND_GLOBAL", line 1147
ORA-06512: at "APPS.FND_GLOBAL", line 620
ORA-06512: at line 1
; 
   at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:905)
   at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:879)
   at oracle.apps.fnd.framework.server.OAExceptionUtils.processAOLJErrorStack(OAExceptionUtils.java:980)
   at oracle.apps.fnd.framework.OACommonUtils.processAOLJErrorStack(OACommonUtils.java:866)
...
   at org.apache.jserv.JServConnection.processRequest(JServConnection.java:456)
   at org.apache.jserv.JServConnection.run(JServConnection.java:294)
   at java.lang.Thread.run(Thread.java:595)
## Detail 0 ##
java.sql.SQLException: ORA-20001: Oracle error -20001: ORA-20001: FND-ORG_ID PROFILE CANNOT READ: N, OPTION, MO: Operating Unit
 has been detected in FND_GLOBAL.INITIALIZE.
ORA-06512: at "APPS.APP_EXCEPTION", line 72
ORA-06512: at "APPS.FND_GLOBAL", line 101
ORA-06512: at "APPS.FND_GLOBAL", line 1147
ORA-06512: at "APPS.FND_GLOBAL", line 620
ORA-06512: at line 1

   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
   at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
   at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:589)
...
   at org.apache.jserv.JServConnection.run(JServConnection.java:294)
   at java.lang.Thread.run(Thread.java:595)
oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_GENERIC_MESSAGE.
 Tokens: MESSAGE = java.sql.SQLException: ORA-20001: Oracle error -20001: ORA-20001: FND-ORG_ID PROFILE CANNOT READ: N, OPTION, MO: Operating Unit
 has been detected in FND_GLOBAL.INITIALIZE.
ORA-06512: at "APPS.APP_EXCEPTION", line 72
ORA-06512: at "APPS.FND_GLOBAL", line 101
ORA-06512: at "APPS.FND_GLOBAL", line 1147
ORA-06512: at "APPS.FND_GLOBAL", line 620
ORA-06512: at line 1
; 
   at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:905)
   at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:879)
   at oracle.apps.fnd.framework.server.OAExceptionUtils.processAOLJErrorStack(OAExceptionUtils.java:980) 
...
   at org.apache.jserv.JServConnection.run(JServConnection.java:294)
   at java.lang.Thread.run(Thread.java:595)
## Detail 0 ##
java.sql.SQLException: ORA-20001: Oracle error -20001: ORA-20001: FND-ORG_ID PROFILE CANNOT READ: N, OPTION, MO: Operating Unit
 has been detected in FND_GLOBAL.INITIALIZE.
ORA-06512: at "APPS.APP_EXCEPTION", line 72
ORA-06512: at "APPS.FND_GLOBAL", line 101
ORA-06512: at "APPS.FND_GLOBAL", line 1147
ORA-06512: at "APPS.FND_GLOBAL", line 620
ORA-06512: at line 1

   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
   at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
   at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:589)
   at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1972)
   at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1119)
...


Error encountered within the forms application while trying to open any form:

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

 

Note: The above listed exceptions and errors were gathered from an Oracle E-Business Suite 11i (11.5.10) environment. Quite likely there will be some slight variations in terms of line numbers etc. on other releases such as an Oracle E-Business Suite Release 12 one.

Solution

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