My Oracle Support Banner

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

Last updated on JUNE 12, 2018

Applies to:

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


On : 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.

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

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.

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

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)


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.