ECC Constrained Plan: Recent Plan Run Exponentially Populates More Rows in the MSC_CRITICAL_PATHS Table than Usual (Doc ID 2276027.1)

Last updated on JUNE 12, 2017

Applies to:

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

Goal

When running an ECC constrained plan, exponentially more rows get populated into the MSC_CRITICAL_PATHS table.

Recently noticed a large increase in the plan run times. While investigating it, noticed over 100 Million records in this particular table, which is a dramatically higher number of records than usual.
Neither understand what that means nor how to troubleshoot it. Clearly something was different, but did not know where to look. Could not notice any correlated increase in neither supplies nor demands.

The concern is (as follows):
How does one troubleshoot such a change in this particular dataset? Tomorrow, if one notices a plan that is not acting normally. Then, after reviewing the log file and discovering that the number of the critical paths skyrocketed into the millions, then
What does this mean? Where should one look to investigate?

This question is not so much looking for a reason as to why the plan ran long.
The questions are (as follows):
1) How does this table get populated? AND
2) What does it mean if there are 300 times more records in this table than usual, with no change in supply or demand.
 

Solution

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