E1: 40R: R40R010 Incorrectly updates Quantity on Split Sales Order Line (Doc ID 2319811.1)

Last updated on JANUARY 01, 2024

Applies to:

Symptoms

************************
E1 Release: 9.2
Program ID: P4205 / R40R010
Tools Release: 9.2
************************

When using Demand scheduling with Ahead/Behind calculation deactivated and when there is a partial shipment the P4205 splits the sales order line and reduces the Requested Ship Quantity (RQSHPQTY) on the Demand Detail line (F40R11) by the amount shipped. Then when the R40R010 is ran (via scheduler or manually) it then reduces again the quantity on the remaining Sales order line, therefore it is double dipping.

STEPS TO DUPLICATE:
1) P40R20 Make sure Ahead/Behind is turned Off
2) P47171 Enter New Demand for 120 EA on 10/24 and Run R47171 to create new Demand detail
3) Run R40R010 and Sales order is created for 120 EA
4) P4915 Approve Shipment and Sales order is advanced to status 540
5) P4205 Pack confirm: Partially confirm line for 30 EA, Inventory is not yet relieved
6) Confirmed line is advanced to status 560 and split line with Remaining qunatity of 90 EA is placed on new shipment
7) P40R10: Verified Demand is still 120
8) P4645/P4205 – Ship confirm line 1.000 for 30 EA
9) P40R10: The Requested Ship Qty was reduced to 90 from 120 after the 30 EA were ship confirmed
10) Re-run R40R010 and the remaining sales order line has the quantity reduced from 90 to 60 EA
11) Demand Detail remains unchanged

Cause

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