Performance Capacity Constrained Plan After Adding Warehouses, R12.MSC.B.3, Memory Based Planner $MSO_TOP/bin/MSONWA64.exe

(Doc ID 1922113.1)

Last updated on SEPTEMBER 09, 2016

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.3 and later
Information in this document applies to any platform.


On : version, Constrained planning.  Added additional warehouses to the capacity constrained plan.

There is a performance issue with Memory Based Planner 64-bit.

Memory Based Planner 64-bit should run faster.

The issue can be reproduced at will with the following steps:
1. Responsibility: Advanced Supply Chain Planner
2. Run ASCP plan with Memory Based Planner 64-bit.


The fix in is only for reducing the loops in the code and no business logic changed.  

It is only a code issue and we could not explain the root cause.  So just an example about the before and after the fix.

Before fix,
Planner goes to the loop logic about  
1+2+3+4+..264697=264697*(264697+1)/2=35032383253 times in total to find the processes.

After fix about 264697 times in total.


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