My Oracle Support Banner

AutoInvoice Error: ORA-20001 (Doc ID 1210483.1)

Last updated on SEPTEMBER 09, 2019

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
 
 Receivables Issues
 India Globalization (Localizations)
References

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