My Oracle Support Banner

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

Last updated on FEBRUARY 25, 2019

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.


Item Effective Date UOM Quantity
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'.

  19-JAN 20-JAN 21-JAN 22-JAN 23-JAN 24-JAN 25-JAN 26-JAN 27-JAN
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).

Exception Org Item Qty From To
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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.