My Oracle Support Banner

Exception Items Below Safety Stock Report Shows Whole Safety Stock Qty As Exception (Doc ID 2000028.1)

Last updated on MARCH 08, 2017

Applies to:

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


On : version, Memory Based Planner

You have user-defined safety stock for item 1-0110400MK of 674 from 04-JUL-2013 to 30-NOV-2015.


ItemEffective DateUOMQuantity
1-0110400MK 04-JUL-2013 EA 674
1-0110400MK 01-DEC-2015 EA 0

After the plan runs, the Horizontal Plan shows the following 'Projected available balance' and 'Safety stock'.

PAB 534 534 574 574 574 574 574 549 549
Safety Stock 674 674 674 674 674 674 674 674 674
Difference -140 -140 -100 -100 -100 -100 -100 -125 -125

The difference between the PAB and the Safety Stock should be reflected in the Qty column for the exception 'Item below safety stock', but when you look at the exception, the data from 26-JAN-2015 to 19-FEB-2015 is incorrect (-674).

Items below safety stock DVX:M08 1-0110400MK -140 19-JAN-2015 20-JAN-2015
Items below safety stock DVX:M08 1-0110400MK -100 21-JAN-2015 25-JAN-2015
Items below safety stock DVX:M08 1-0110400MK -674 26-JAN-2015 19-FEB-2015

Expectation is that the Quantity for the exception on 26-JAN-2015 should be -125 because that's the value of the PAB - Safety Stock.

The issue can be reproduced at will with the following steps:
1. Responsibility : Advanced supply chain planner
2. Navigation : Supply chain planning > Workbench
3. Exception Items below safety stock report shows whole Safety Stock Qty as exception


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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.