The Sales Order Line Number Does Not Correspond with the Invoice Lines in Receivables. Cannot Select Invoice Line as a Reference for RMAs (Doc ID 1566647.1)

Last updated on AUGUST 08, 2023

Applies to:

Symptoms

The line numbers on the Invoice do not match with the Sales Order lines.

Is there a script to update the sales order line numbers in receivables to fix the sales order line number in Invoice Line?

The problem is that line numbers in Sales Orders somehow changed after the AR Invoice Line creation.
Now you need to make values in field sales_order_line equal to corresponding sales order line numbers.
When creating a RMA, you cannot select the invoice line as a reference, since the line numbers are different in the invoice and sales order.

There are 13 orders affected.

For Example:
Order #3192180
Line number in the Sales Order 3192180 = 44.1.
Line number in the corresponding Invoice 3868 = 63.

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.