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 12.1.3.9 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3.9 version, Memory Based Planner

ACTUAL BEHAVIOR
---------------
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'.

 19-JAN20-JAN21-JAN22-JAN23-JAN24-JAN25-JAN26-JAN27-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).

ExceptionOrgItemQtyFromTo
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

EXPECTED BEHAVIOR
-----------------------
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.

STEPS
-----------------------
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


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