How do you check if there is Available Quantity for Lead Time Promising in GOP/DOO ? (Doc ID 1395014.1)

Last updated on JANUARY 11, 2017

Applies to:

Oracle Fusion Distributed Order Orchestration - Version 11.1.1.5.1 to 11.1.9.2.0 [Release 1.0]
Information in this document applies to any platform.
***KM Review - Dec 2016 - Checked for Relevance - Release 9 Specific***

Goal

How do you check if there is Available Quantity for Lead Time Promising in GOP/DOO ?
GOP always returns '0' Qty in the Expected Available Qty On Requested Date Field -- ExpectedAvailabilityOnRequestedDate.

While Orchestrating an Order, I am calling the Global Order Promising (GOP) CheckAvailabilityInput Process with:

Portion of Input Payload

<dood:InventoryOrganization>300000001257961</dood:InventoryOrganization>
<dood:ProductName />
- <!-- Optional: -->
<dood:RequestedItemId>VSSXWL-23315</dood:RequestedItemId>
<dood:PromisingType>Ship</dood:PromisingType>
<dood:RequestedDate>2011-12-27</dood:RequestedDate>
<dood:RequestedQuantity>10.0</dood:RequestedQuantity>
<dood:RequestedQuantityUOM>2~}</dood:RequestedQuantityUOM>


Portion of Output Payload returned

<tns:RequestedDate>2011-12-27</tns:RequestedDate>
<tns:PromisingType>Ship</tns:PromisingType>
<tns:ExpectedArrivalDate>2011-12-27</tns:ExpectedArrivalDate>
<tns:ExpectedShipDate>2011-12-27</tns:ExpectedShipDate>
<tns:ExpectedPickDate>2011-12-27</tns:ExpectedPickDate>
<tns:RequestedItemId>VSSXWL-23315</tns:RequestedItemId>
<tns:ExpectedAvailableItem>VSSXWL-23315</tns:ExpectedAvailableItem>
<tns:ExpectedAvailabilityOnRequestedDate>0.0</tns:ExpectedAvailabilityOnRequestedDate>
<tns:ExpectedAvailableQuantity>10.0</tns:ExpectedAvailableQuantity>
<tns:ExpectedAvailableQuantityUOM>2~}</tns:ExpectedAvailableQuantityUOM>


We are using lead time based promising. And we have defined sourcing rules and assignments for that. The payload returned shows that:

a. ExpectedAvailabilityOnRequestedDate = 0
b. ExpectedAvailableQuantity = 10

1. Why are these values returned, why is ExpectedAvailabilityOnRequestedDate = 0 and ExpectedAvailableQuantity = 10 ?
2. How can I verify that these values are correct ?

Why when the requested date cannot be met is the expected availability still provided. The customer is requesting 10, availability is 10.

1. SYSDATE is 2011-12-05
2. Supply Based Promising is being used
3. The Item has lead time of 10 days.


Test Case 1 -- Note that the requested date is for two days from the date the order was created

<dood:RequestedItemId>VSSXWL-23315</dood:RequestedItemId>
<dood:PromisingType>Ship</dood:PromisingType>
<dood:RequestedDate>2011-12-07</dood:RequestedDate>
<dood:RequestedQuantity>10.0</dood:RequestedQuantity>


Results in

<tns:RequestedDate>2011-12-07</tns:RequestedDate>
<tns:PromisingType>Ship</tns:PromisingType>
<tns:ExpectedArrivalDate>2011-12-14</tns:ExpectedArrivalDate>
<tns:ExpectedShipDate>2011-12-14</tns:ExpectedShipDate>
<tns:ExpectedPickDate>2011-12-14</tns:ExpectedPickDate>
<tns:RequestedItemId>VSSXWL-23315</tns:RequestedItemId>
<tns:ExpectedAvailableItem>VSSXWL-23315</tns:ExpectedAvailableItem>
<tns:ExpectedAvailabilityOnRequestedDate>0.0</tns:ExpectedAvailabilityOnRequestedDate>
<tns:ExpectedAvailableQuantity>10.0</tns:ExpectedAvailableQuantity>


Test Case 2 -- The requested date is for a date in the future -- beyond the lead time.


<dood:RequestedItemId>VSSXWL-23315</dood:RequestedItemId>
<dood:PromisingType>Ship</dood:PromisingType>
<dood:RequestedDate>2011-12-19</dood:RequestedDate>
<dood:RequestedQuantity>10.0</dood:RequestedQuantity>


Results in

<tns:RequestedDate>2011-12-19</tns:RequestedDate>
<tns:PromisingType>Ship</tns:PromisingType>
<tns:ExpectedArrivalDate>2011-12-19</tns:ExpectedArrivalDate>
<tns:ExpectedShipDate>2011-12-19</tns:ExpectedShipDate>
<tns:ExpectedPickDate>2011-12-19</tns:ExpectedPickDate>
<tns:RequestedItemId>VSSXWL-23315</tns:RequestedItemId>
<tns:ExpectedAvailableItem>VSSXWL-23315</tns:ExpectedAvailableItem>
<tns:ExpectedAvailabilityOnRequestedDate>0.0</tns:ExpectedAvailabilityOnRequestedDate>
<tns:ExpectedAvailableQuantity>10.0</tns:ExpectedAvailableQuantity>


OBSERVATIONS

1. For the test case where it is not possible to meet the requested date -- availability shows that the 10 items can be ordered
2. HOWEVER the expected Arrival Date is set to be 2011-12-14

REQUIREMENTS

1. Why is the ExpectedAvailableQuantity set to 10 even though the availability cannot be met for the requested date ?
2. How is the ExpectedArrivalDate calculated ?

Solution

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