Spare Management: Cannot Open Warehouse Replenishment Planning HTML Screen (Doc ID 1907001.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Spares Management - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.3 version, Spares Logistics

When attempting to open Warehouse Replenishment Planning HTML Form in Spare Management or Depot Repair Manager, the following error occurs.

ERROR
-----------------------
Error Page
Exception Details.
oracle.apps.fnd.framework.OAException: Could not load application module 'oracle.apps.csp.planning.server.CspPlanAM'. 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:1315) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:558) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:446) at _pages.__oa._jspService(__oa.java:233) at

...
## Detail 0 ##
oracle.apps.fnd.framework.OAException: 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

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Responsibility:Spares Management
Navigate through Spares Management->Warehouse Replenishment Planning
OR
Responsibility:Depot Repair Manager,Vision Operations
Navigate through Spares Management->Warehouse Replenishment Planning


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