Error 'ORA-20001: APP-FND-02902: Multi-Org Profile Option Is Required' When Open Account Details (Doc ID 1406860.1)

Last updated on MARCH 29, 2024

Applies to:

Symptoms

In R12.1.3, when an existing customer is searched from the Customers page, and the searched record is selected further, and users try to open the account details, the following error is received:

Error
You have encountered an unexpected error. Please contact the System Administrator for assistance.

Error Page
Exception Details.
oracle.apps.fnd.framework.OAException: Could not load application module 'oracle.apps.ar.cusstd.acctoview.server.AcctOviewAM'.
at oracle.apps.fnd.framework.webui.OAJSPApplicationRegistry.registerApplicationModule(OAJSPApplicationRegistry.java:279)
at oracle.apps.fnd.framework.webui.OAJSPApplicationRegistry.registerApplicationModule(OAJSPApplicationRegistry.java:78)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1300)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431)
.....
.....
## Detail 0 ##
JBO-30003: The application pool (hostname.oracle.apps.ar.cusstd.acctoview.server.AcctOviewAM) failed to checkout an application module due to the following exception:
oracle.jbo.JboException: JBO-29000: Unexpected exception caught: oracle.apps.fnd.framework.OAException, msg=Application: FND, Message Name: FND_GENERIC_MESSAGE. Tokens: MESSAGE = java.sql.SQLException: ORA-20001: SQL_PLSQL_ERROR: N, ROUTINE, MO_GLOBAL.INIT, N, ERRNO, -20001, N, REASON, ORA-20001: APP-FND-02902: Multi-Org profile option is required. Please set either MO: Security Profile or MO: Operating Unit profile option.
ORA-06512: at "APPS.FND_MESSAGE", line 509
ORA-06512: at "APPS.MO_GLOBAL", line 36
ORA-06512: at "APPS.MO_GLOBAL", line 757
ORA-06512: at "APPS.MO_GLOBAL", line 700
ORA-06512: at line 1
;

The site details are opening fine, the issue is only with account details.


Steps to reproduce:

-Responsibility: Receivables Manager
-Navigation:  Customers > Customers
-Query a customer
-Select the resultant record, and click on Details in the Account section.
-The error appears.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.