Unexpected Error When Opening The Parts Requirement HTML Page (Doc ID 1487871.1)

Last updated on JANUARY 03, 2023

Applies to:

Symptoms

On : 12.1.3 version, Spares Logistics

When attempting to open Part Requirements HTML page, the following error occurs:

ERROR
-----------------------
"You have encountered an unexpected error. Please contact the System Administrator for assistance. "

Error details:

oracle.apps.fnd.framework.OAException: Could not load application module 'oracle.apps.csp.portal.requirement.server.RequirementAM'.
....
JBO-30003: The application pool (<HOSTNAME>.combiopch1521oracle.apps.csp.portal.requirement.server.RequirementAM) 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


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Open Part Requirement HTML page.

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.