My Oracle Support Banner

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

Last updated on FEBRUARY 27, 2019

Applies to:

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


12.2.5 with patch #2 - 22493520

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.


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.