AutoInvoice Error: ORA-20001 (Doc ID 1210483.1)

Last updated on MAY 19, 2017

Applies to:

Oracle Receivables - Version 11.5.10.0 and later
Oracle Order Management - Version 11.5.10.0 and later
Oracle E-Business Tax - Version 12 and later
Oracle Financials for India - Version 11.5.10.0 and later
Information in this document applies to any platform.
EXECUTABLE:RAXTRX - Autoinvoice Import Program


Symptoms

Oracle Receivables (AR): AutoInvoice Information Center > Troubleshooting AutoInvoice for Oracle Receivables Release 11.5 Through 12 >Troubleshooting AutoInvoice: Concurrent Request Failures (Request Status = Error) > Note 1210483.1

In Release 12, Autoinvoice ends with the following error in the log:

ORA-20001

This may be followed by an additional test indicating the table that would not accept the null value.  For example:

APP-AR-11526: ORA-20001: Reason, Organization
and Location are required fields as Tr
INSERT INTO RA_CUSTOMER_TRX_LINES (
customer_trx_line_id,
last_update_
APP-AR-11526: 1403734/ar/src/autoinv/raaild.lpc 906

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