E1: 40R: Shipped Quantity (CUMS) in the Shipment Detail (F4942) is not Updated with Current Shipped Quantity for Split Lines During Transportation Ship Confirm (P49645/P4205) (Doc ID 2922058.1)

Last updated on MARCH 22, 2023

Applies to:

Symptoms

When ship confirming (P49645/P4205) a Demand Scheduling Sales Order/Shipment, the Shipped Quantity (CUMS) value in the F4942 is not getting updated with the current shipped quantity. This happens when the sales order line was split due to hard commitment for lots during Print Pick Slip (R42520) and the item is setup as a standard pack item. The CUM Shipped Quantity in the F40R12 (CUM Maintenance) is updated correctly.

STEPS
-----------------------
 
1. Setup a new customer and item for Demand Scheduling - Demand Rules (P40R20), Product/Carton CUM Models (P40R23/P40R24), Demand Cross Reference (P40R21) and Item Cross Reference (P4104).
2. Setup an item standard pack (P460131) for the item with 40 EA per box.
3. Add a record in the P40R12 for the item/customer with the CUM Shipped Qty (CUMS) as 200 and Firm CUM Required Quantity (CRQQYFM) with the same values (Ex: 200).
4. Add a header, detail and schedule record for the item using the P47171 (Inbound EDI Maintenance). On the Demand Detail (F47172), set the CUM Quantity Flag to a value of 1 on the CUM 1 tab.
5. On the schedule record (F47173), input a value of 280 for the ship quantity. Since the CUM Quantity Flag is set to 1, the quantity on the demand detail will be the quantity on the schedule (280) minus the current CUM Shipped Quantity (200) for a total of 80.
6. Adjust Inventory (P4114) for the item in two different lots for 40 EA. This has a total of 80 available in two secondary locations.
7. Run the Inbound Demand UBE (R47171) to create Demand Detail (F40R11) records and verify a quantity of 80 exists in the F40R11.
8. Run the Create Schedule UBE (R40R010). A sales order (S4) is created for a quantity of 80.
9. Setup a version of the Print Pick Slips (R42520) to hard commit and run the UBE over the order. The sales order will be split into two lines for each lot hard committed.
10. Approve the shipment using the Shipment Approval (P4915).
11. Confirm the shipment using the P49645/P4205 (Transportation Ship Confirm) and verify the shipment is at a confirmed status.
12. Review the data in the F4942 (Shipment Detail). The Shipped Quantity (CUMS) shows the previous CUMS value from the F40R12 (200), but this should reflect the quantity that was shipped (280). The first line should have a quantity of 240 and the second line should have a quantity of 280. The data in the F40R12 was updated correctly with a value of 280.

 

Changes

Cause

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