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 DECEMBER 03, 2019

Applies to:

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


On : version, Supply Chain Optimizer in Test:

Users are on 12.2.6 and have applied patch 25920948 - 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
#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);
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.
Program was terminated by signal 6

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




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

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