My Oracle Support Banner

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

Last updated on JULY 10, 2018

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]
Oracle Receivables - Version 12.2.3 to 12.2.3 [Release 12.2]
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

To view full details, 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 a vibrant support community of peers and Oracle experts.