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 SEPTEMBER 21, 2017

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

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