E1: 49: F4615/F4620 Carton Records are Duplicated When Updating Sales Order After Carton Recommendation was Processed (Doc ID 2886163.1)

Last updated on OCTOBER 18, 2022

Applies to:

Symptoms

When carton recommendation records have been created for a sales order / shipment in F4216 - SO Pack Confirm Detail, F4615 - Carton Recommendations and F4620 - Carton Detail Information and when the sales order is updated, a new shipment number is generated and new carton recommendations then the old records in F4216 and F4620 are not updated or deleted. New/duplicate records are added to the F4216 for the same sales order number (DOCO) and also New/duplicate records are added to the F4620 for the new shipment number, but the same order number. The user cannot update the F4620 records for the original shipment as the shipment is cancelled.
This eventually is causing issues with the R47032 ASN as quantities are duplicated in the ASN tables F470371.
  

Steps to Duplicate:
1) P460131 Set up Item Standard Pack
2) Enter Transportation Sales Order
3) P4915 Go to Shipment Detail > Carton Recommendation
4) P4615 Take Row Exit to Carton Detail and in P4620 Confirm Carton Detail
5) Note that F4216, F4615 and F4620 are created correctly
6) P4210 Change the Requested Date which will trigger a new shipment
7) P4915 Go to Shipment Detail > Carton Recommendation > Carton detail to create New carton detail for the new shipment
8) F4216 Note that records have been duplicated
9) F4615 record for original shipment has been reversed and new record for new shipment has been created
10) F4620 records for original shipment still exist and records for new shipment have been created

Cause

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