Translate

Wednesday, January 7, 2015

Oracle GOP Functionality

REQUIREMENTS

1. Why is the Expected Available Quantity set to 10 even though the

availability cannot be met for the requested date ?
2. How is the Expected Arrival Date calculated ?

SOLUTION

1. The Expected Available Quantity is not related to how much is available

on the requested date. There is no field in Order Promising that shows you

the quantity available on the requested date.

2. To check if there is Available Quantity on the requested date you should

compare the Expected Date and Requested Date to infer that there is no

quantity available on the Requested Date. I.e if these dates do not match

this implies there is no availability on the requested date.

3. The Expected Availability On Requested Date is a redundant field and GOP

does not have logic currently to derive the value in this field (RUP1 --

January 2012).

In the Examples provided The ATP Rule is not Lead Time based, it is a

regular ATP rule but with a Infinite time fence corresponding to the Total

Lead Time. The results are correct, and as expected for the Supply Chain

Search enabled ATP mode with an Infinite Time Fence.

TEST CASE 1.

1. Why is the Expected Available Quantity set to 10 even though the

availability cannot be met for the requested date ?

The Expected Available Quantity is not related to how much is available on

the requested date. It just shows the quantity of the promise, and this is

showing up as 10 since the requested quantity is 10. There is no field in

OP that shows you the quantity available on the requested date.

2. How is the Expected Arrival Date calculated ?

First the ship date is calculated. Since no supply is found until the

Infinite Time Fence, which is on 14-Dec (based on sysdate + Total Lead

Time) the Expected Ship Date is set to 14-Dec. Expected Arrival Date =

Expected Ship Date + Lead time (since no transfer lead times seem to be

setup) which is again 14-Dec.
TEST CASE 2.

3. How is the Expected Arrival Date calculated --- The date was calculated as

request date + lead time. Should the Arrival date be calculated as being

the same as the requested date if the lead time can be met ?

This is not 'Lead time based' promising mode. In this scenario, the request

date is beyond the Infinite time fence. Hence, availability is assumed to

be infinite on this date, and the Ship and Arrival Dates equal the

requested date.



Org has 5 day shipping calendar. (Monday to Friday are working days,

Saturday and Sunday are non shipping days).
Customer has requested to ship the materials on Sunday (20th Nov-2011).
Received order 8-Nov-2011 and Item lead time is 3 days.

System will suggest schedule ship date = 18th Nov 2011
(this is less than the non shipping day the customer requested)


SOLUTION

GOP uses calendar days(7 days) for lead time calculations.
For a 5 day shipping calendar GOP will back up to the previous working day

as long as item as item can be manufactured on or before that date.

No comments:

Post a Comment