Memory Based Planner Performance Issue MSONWH64 Module (Doc ID 1058694.1)

Last updated on SEPTEMBER 09, 2016

Applies to:

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

Symptoms

On : 11.5.10.2 version, Memory Based Planner

  The MSONWH64 module: Memory Based Planner 64-bit HP, is taking more time in the Test instance, as compared to Production Instance. The same data in Production instance is taking around 80-100 minutes. But in Dev, the same plan is taking close to 5hrs. All the setups are same.

EXPECTED BEHAVIOR
-----------------------
that the time taken for the same datasetup should be same and the plan should complete faster. 

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Responsibility > Advanced Supply Chain Planner.
2. There is a performance issue with Memory based planner.

DETAILS
-----------------------
Current system time is 26-NOV-2009 14:54:02

.Load data completed 1:26
..Selecting Shift times 1,117,46 0:29

DSM om->createAbstEntities(), time taken = 257.617
DSM om->createLinks(), time taken = 257.75
create objects, time taken = 2.25
solve lp 0, take time: 59
gp, time taken = 20.1167
plan 0(1) take time=20.6667
oi, time taken = 20.1833

.Optimization completed 278:22 (SCO)

> Exiting HLS.
..Scheduling completed 36:18 (HLS)


Total Planning Time 321 mins :31 secs --- 5 hrs :21 mins :35 secs
Current system time is 26-NOV-2009 20:15:37

More time is taken by Supply Chain Optimizer.. SCO.. - 278:22
HLS - 36:18


COMPARISON
---------------
Comparing to Dev instance, the SCO is very much faster here.. HLS has taken almost same time.

The below section in SCO in production is the fastest...
DSM om->createAbstEntities(), time taken = 0.233333
DSM om->createLinks(), time taken = 0.383333

The same section in SCO in Development is the slowest...
DSM om->createAbstEntities(), time taken = 257.617
DSM om->createLinks(), time taken = 257.75

..Updated MSC_SYSTEM_ITEMS 3,648 0:03 (In Production)
..Updated MSC_SYSTEM_ITEMS 3,411 0:03 (In Development)

Cause

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