Aggregation Measures for "Days Of Supply" And "Average Days Of Supply" Are Wrong In Weekly Buckets (Doc ID 2127544.1)

Last updated on JUNE 29, 2017

Applies to:

Oracle Rapid Planning - Version 12.2.5 to 12.2.5 [Release 12.2]
Information in this document applies to any platform.

Symptoms

12.2.5 with patch #2 - 22493520

PROBLEM
-------------
We are testing on RP 12.2.5. For the measures "Days of Supply and "Average Days of Supply" we observe the below behavior when viewing Material Plan at week level.

At Day level
                                      D1   D2    D3    D4    D4    D6    D7
Days of Supply                                                19    18   17
Average Days of Supply                                    21    21   21


When Material Plan is viewed at week level
Days of Supply                54
Average Days of Supply    63

The measures for each day are summed up when viewing at week level.

This is incorrect, because at the end of the week we have 17 Days of Supply and 21 Average Days of Supply and not 54 and 63 respectively.

When going to weekly level, just like Projected Available Balance for these two measures also the Material Plan should display the last value of the week.

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