My Oracle Support Banner

SPP Plan Errors MSONWL64 - Memory Based Planner 64-bit Linux With ORA-01001 APP-MRP-22075 Signal 6 (Doc ID 2309889.1)

Last updated on NOVEMBER 09, 2018

Applies to:

Oracle Service Parts Planning - Version 12.2.6.2 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.6.2 version, Supply Chain Optimizer in Test:

Users are on 12.2.6 and have applied patch 25920948 12.2.6.2 - Mandatory patch #2. They are running an SPP plan. If they run this plan without an IO plan attached as a demand schedule, it completes successfully. However when they add an IO plan (about 15 items) as a demand schedule in the plan options and run it, it fails with the following in MSONWL64 module: Memory Based Planner 64-bit Linux
Starts 13-SEP-2017 18:07:39
Ends 13-SEP-2017 18:09:51
Total 2 min 12 seconds to fail
 
ERROR
-----------------------
#OM 129:122.66: Starting: planned orders
APP-FND-01564: ORACLE error 1001 in mrslsq_select_sequence

Cause: mrslsq_select_sequence failed due to ORA-01001: invalid cursor

The SQL statement being executed at the time of the error was: declare
var_handle1 varchar2(128);
begin
dbms_lock.allocate_unique (' and was executed from the file .
APP-MRP-22075: An internal error has occurred (writePrimaryAndCoProductSupplies, 132332, , )
@ERRORTEXT Cause: The current routine encountered the specified@ERRORTEXT x Action: Contact your customer supportrepresentative.
MSONWL64.exe: /d1/EBS64_TOOL/APS64_R122_WORKER/mso/src/omre/msopomproductionflow.cpp:4017: int OmProductionFlow::writePrimaryAndCoProductSupplies(OmSupplyStruct&, FlowQty, int&, int&, data_supply_cell**, int&, int&) const: Assertion `false' failed.
/apps/applmgr/r12/fs2/EBSapps/appl/mso/12.0.0/bin/MSONWL64.exe
Program was terminated by signal 6


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run SPP plan without IO plan and it is successful
2. Run IO plan successfully
3. Attach IO plan as a demand schedule to the SPP plan options
4. Rerun the SPP plan and it fails with multiple errors

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


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