Error Accessing iReceivables - ORA-06512 APPS.MO_GLOBAL (Doc ID 2800831.1)

Last updated on MARCH 01, 2023

Applies to:

Symptoms

When trying to access standard iReceivables pages, the following error occurs:

oracle.apps.fnd.framework.OAException: Could not load application module 'oracle.apps.ar.irec.common.server.CustomerSearchAM'.

## Detail 0 ##
JBO-30003: The application pool (server.name.apps.ar.irec.common.server.CustomerSearchAM) 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: SQL_PLSQL_ERROR: N, ROUTINE, MO_GLOBAL.SET_ORG_ACCESS, N, ERRNO, -20001, N, REASON, ORA-20001: APP-FND-02938: Multi-organization routine failed to initialize a session for the product: &PRODUCT. Please inform your support representative.
ORA-06512: at "APPS.FND_MESSAGE", line 509
ORA-06512: at "APPS.MO_GLOBAL", line 36
ORA-06512: at "APPS.MO_GLOBAL", line 852
ORA-06512: at "APPS.MO_GLOBAL", line 795
ORA-06512: at line 1

Normally the error occurs with MO: Operating Unit is null at the Site level.  But the error is occurring even with that profile option set correctly.

Steps to Reproduce:

Responsibility: iReceivables 2.0 Internal
Navigation: Customer Search

1. Set the profile option MO:Operating Unit to the correct Operating Unit at the Site level and save.
2. Switch to iReceivables 2.0 Internal, and click on Customer Search and get the error indicating MO profiles are not set.

Cause

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