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 04, 2016

Applies to:

Oracle Receivables - Version 12.1.3 and later
Oracle Order Management - Version 12.1.3 and later
Information in this document applies to any platform.

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.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms