My Oracle Support Banner Memory Based Planner Taking Over 300 Minutes To Complete (Doc ID 2496333.1)

Last updated on JULY 14, 2021

Applies to:

Oracle Advanced Supply Chain Planning - Version to [Release 12.1]
Information in this document applies to any platform.


Users have upgraded DEV instance from source EBS 12.1.2 on with ASCP 12.1.3 on to EBS 12.1.3 on and ASCP 12.1.3 on - using 64 bit Linux MBP version MSONWL64.ppc 120.3.12010000.484.
As part of a troubleshooting effort to reduce the overall run time of the planning cycle, the intent of this SR is to reduce the run time.
This plan is constrained on resources ONLY and is 120 days/0 weeks/0 periods.
There are only 3 orgs out of 16 in this plan. They really need to get all orgs in this plan at some point and skip running the unconstrained plan.
However performance of this plan has never been able to get a good timing.

The log file shows the following key areas:

MSONWL64 module: Memory Based Planner 64-bit Linux

Starts 22-OCT-2018 15:54:20
Ends 22-OCT-2018 22:16:30
Total 6 hr 22 minuts

.Load data completed
..Net+Peg+PushDown AllItems completed

> Exiting HLS.
..Scheduling completed
.Generate data completed
356:58 - 5.5 hours for 3 org plan

Total Planning Time 382:00
Total memory usage: 21567608


They also ran into this issue on code line as well

Expect the plan run to complete in 2 to 2.5 hours

1. Upgrade from to
2. Run ASCP Cycle
3. Memory based Planner taking 6 hours in hls on its own


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.