My Oracle Support Banner

E1: 40R: R47032 (ASN Extraction) CUM Shipped Quanity Incorrect in F470372 (EDI ASN Demand Scheduling Detail) (Doc ID 2837157.1)

Last updated on JANUARY 27, 2022

Applies to:

JD Edwards EnterpriseOne Demand Scheduling Execution - Version 9.1 and later
Information in this document applies to any platform.


When running the ASN Extraction (R47032) over a shipment that contains multiple shipment detail lines for the same item, the CUM shipped quantity is not getting calculated with the correct value for the item level in the F470372.



1. Using the R40R010, create a sales order for a DSE customer.
2. Adjust the quantity in the demand detail to a higher level and run the R40R010 again to add a new line.
3. Using the P4620, create multiple cartons for each sales order detail line for the item. This will create multiple F4216 records for each sales order line.
4. Process the shipment through ship confirm. Verify the CUM shipped quantity in the F40R12 and the F4942 (Shipment Detail) for both lines that contain the same item. These values are correct.
5. Run the R47032 (ASN Extraction) over the shipment. The CUM Shipped Quantity in the F470372 contains the value for the first record in the F4942 table and not the total CUM Shipped Quantity for the second line. This only occurs on the hierarchy level of Item (I).





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

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