Sales Order Discount Lines Stuck In The RA_INTERFACE_LINES with ERROR You Must Supply The Amount For This Transaction (Doc ID 1403994.1)

Last updated on JULY 13, 2016

Applies to:

Oracle Order Management - Version 12.1.3 and later
Information in this document applies to any platform.
***Checked for relevance on 24-Jul-2013***
***Checked for relevance on 06-FEB-2015***

Symptoms

The Open sales orders loaded through the conversion program get stuck in the AR Interface lines with the following Error:
'The amount Value could not be null.'

This only happens for the discounts on the sales order lines not the line itself.
When passing the discount value in the error-ed interface lines it is processed after running the autoinvoice master program.

The problem is user has to manually go and do this activity every time the lines are to be invoiced.

Note:
The problem is only with the Open sales orders that were loaded through the conversion program.
It is only for the discount the lines, the discounts passed in the sales order level using overidable modifier gets stuck in the AR Interface table.

Steps:
Ship confirm the orders that were loaded through the conversion program, Run the Autoinvoice master program , Query the interface lines and see the error-ed records.

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