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 18.104.22.168 and later
Information in this document applies to any platform.
On : 22.214.171.124 version, Supply Chain Optimizer in Test:
Users are on 12.2.6 and have applied patch 25920948 126.96.36.199 - 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
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