E1: 42: Understanding How To Successfully Process a Sales Order Where a Portion of the Sales Order Detail Lines (F4211) Have Already Processed Through Sales Update (R42800) (Doc ID 2847979.1)

Last updated on FEBRUARY 08, 2022

Applies to:

Goal

Customer has order 123456 has 5 lines (2.000 - 6.000) that can't be processed by sales update (R42800) because of a invoice number issue. Invoice print (R42565) was run over all lines on the order. The invoice number (22222) has been assigned to all sales order detail lines (F4211).

The order has 7 lines. After the order was invoiced, Sales Update (R42800) was run but only lines 1.0 and 1.1 were processed by Sales Update because the other 5 lines were on hold. Now sales update can't be run for the remaining 5 lines because it thinks there is a duplicate invoice number (22222).

What is the best way to fix this issue? Can Sales Update somehow be run for the remaining 5 lines or does a database utility such as SQL need to be run to clear out the invoice number on the F4211 rows and reset the status back to 580 so that these lines can be invoiced again?
 

Solution

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