Aggregation Measures for "Days Of Supply" And "Average Days Of Supply" Are Wrong In Weekly Buckets
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.
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.
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