MSONWS64 Memory Based Planner 64-Bit Hangs With Unknown Activity (Doc ID 1375681.1)

Symptoms

On : 12.1.3 version, Memory Based Planner

MBP hangs after running for hours.
Customer is running an EDD constrained plan on 64 bit MBP for Solaris.

MBP log file shows:

MSONWS64 module: Memory Based Planner 64-bit Sun

On entry to SCO
Decomp: nr of processes: 1 total groups nr: 1

om cost roll-up, time taken = 0.116667
reading mbp sup, time taken = 0.116667

oi, time taken = 157.6
...Optimization completed 159:15
Batch PROCESS=1 plan_type=3

UNKNOWN ACTIVITY
UNKNOWN ACTIVITY
UNKNOWN ACTIVITY
UNKNOWN ACTIVITY
UNKNOWN ACTIVITY
UNKNOWN ACTIVITY
ITEM 83968, ORG 2110, INST 1, 18, 79, 18, 1
UNKNOWN ACTIVITY

Trace file shows the following sql hanging:

A.  Trace file was hung on the following:

begin
:var_output := dbms_lock.release(:var_handle);
end;

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse       38      0.00       0.00          0          0          0           0
Execute     38      0.00       0.00          0          0          0          38
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total       76      0.00       0.00          0          0          0          38

Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: 173  (APPS)

Elapsed times include waiting on following events:
Event waited on                             Times   Max. Wait  Total Waited
----------------------------------------   Waited  ----------  ------------
SQL*Net message to client                      76        0.00          0.00
SQL*Net message from client                    76   313316.92     313321.62

B.  Debug log file was huge but the last 1000 lines repeated over an over:

Negative Buffer Problem: ITEM/ORG=83968/2110; Qty=nan
msnnslvr end of solve
#= First Negative *NO* Lot for Lot: ItemId: 26705 m_newSupply: nan
#= Btk: 0 m_newSupply: nan 0
#= Bkt: 0


EXPECTED BEHAVIOR
-----------------------
Expect plan to complete in around 4 hours or less


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Advanced Supply Chain Planner Responsibility
2. Run plan

Cause

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