My Oracle Support Banner

Supply Demand Shows Incorrect Records for Purchase Order that Has Multiple Distributions and Partially Received (Doc ID 2572866.1)

Last updated on AUGUST 06, 2020

Applies to:

Oracle Purchasing - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version, Receiving Functions

Supply/Demand Details form shows incorrect records when a purchase order with single line/shipment and multiple distributions was received.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1.Navigate to Purchasing responsibility>Purchase Orders>Purchase Orders.
  
2.Create a PO with single line/shipment and multiple distribution lines, like below:
  One line with quantity 50000
  and one shipment with quantity 50000
  and three distribution lines like below:
  Distribution 1   20000(quantity)
  Distribution 2   20000(quantity)
  Distribution 3   10000(quantity)

3. And the records show correctly in Supply/Demand Details form now:
  Supply/Demand Type       Quantity
  Purchase Order                  10000
  Purchase Order                  20000
  Purchase Order                 20000

4.Go to Receipts form and receive 1050 quantity.

5. Now go to Supply/Demand Details form again, see it still can show the records correctly until this step.

  Supply/Demand Type      Quantity
  Purchase Order               10000
  Purchase Order               18950
  Purchase Order               20000
  PO in receiving               1050

6. Go to Receipts form to receive another 20500 quantity.

7.Then Supply/Demand Details form can't show the data correctly, it shows as below:
 Supply/Demand Type            Quantity
  PO in receiving                       1050
  PO in receiving                       1550
  PO in receiving                      18950

  The issue here is the un-received quantity 28450 does not show in the Supply/Demand Details as expected.

8.Go to Purchase Order Summary form, it shows that Quantity Ordered=50000, Quantity Received=21550.

 

Cause

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
Symptoms
Cause
Solution
References


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