Autoinvoice Error: ORA-1403: no data found (Doc ID 1209403.1)

Last updated on APRIL 13, 2017

Applies to:

Oracle E-Business Tax - Version 12.0.0 and later
Oracle Receivables - Version 11.5.0 to 12.1.3 [Release 11.5.0 to 12.1]
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 > Note 1209403.1

When attempting to run Autoinvoice, the following error is displayed in the log file captured as instructed from <Note 1079666.1>

ORA-01403: no data found

ORA-1403 errors occur when the code fetches data expecting at least one row to be returned, but instead none is found. When the code block does not have an exception handler for NO_DATA_FOUND, this error is returned.

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