My Oracle Support Banner

12.1.3.9.2 Memory Based Planner Taking Over 300 Minutes To Complete (Doc ID 2496333.1)

Last updated on AUGUST 19, 2019

Applies to:

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

Symptoms

Users have upgraded DEV instance from source EBS 12.1.2 on 12.1.3.9.1 with ASCP 12.1.3 on 12.1.3.9.1 to EBS 12.1.3 on 12.1.3.9.2 and ASCP 12.1.3 on 12.1.3.9.2 - 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
10:06
..Net+Peg+PushDown AllItems completed
24:15

> Exiting HLS.
..Scheduling completed
324:59
.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 12.1.3.9.1 code line as well

EXPECTED BEHAVIOR
-----------------------
Expect the plan run to complete in 2 to 2.5 hours

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

Cause

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
Symptoms
Cause
Solution
References


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