SPP Plan Errors MSONWL64 - Memory Based Planner 64-bit Linux With ORA-01001 APP-MRP-22075 Signal 6
Last updated on SEPTEMBER 21, 2017
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
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