Excess And Obsolete Metrics In APCC Appear To Be Incorrect

(Doc ID 1994609.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Advanced Planning Command Center - Version 12.1.3.9 and later
Information in this document applies to any platform.

Symptoms

In Advanced Planning Command Center 12.1.3.9 version, Reports and Dashboards

ACTUAL BEHAVIOR
---------------
In APCC, several KPIs appear to be calculating incorrectly.

DMD_WITHIN_OBS_HORIZON and DMD_WITHIN_EXCESS_HORIZON both appear to be ignoring past due real demands

Example for #1:
Excess Horizon Days = 30
Item = ABC

In ASCP workbench, total demand within 30 days of 11-NOV-14 is 33.2 units, of which 18.2 is past due; but in MSC_ITEMS_F, DMD_WITHIN_EXCESS_HORIZON shows only 14.999681 (round to 15).  Every other item I looked at also exhibits this problem
.

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