My Oracle Support Banner

AutoInvoice Import Validation Report Shows 'No Data Found' And No Error in Log Files (Doc ID 301819.1)

Last updated on FEBRUARY 24, 2020

Applies to:

Oracle Receivables - Version 11.5.8 to 11.5.10.3 [Release 11.5.8 to 11.5.10]
Information in this document applies to any platform.
EXECUTABLE:RAXTRX - Autoinvoice Import Program


Symptoms

Autoinvoice is not picking up lines in the interface tables.  The Autoinvoice Validation report shows "No data found".  There are no errors in the log files. 

Following update has been done and Autoinvoice submitted again. You are still getting 'No data found':

UPDATE RA_INTERFACE_LINES_ALL
SET   interface_line_id = null,
          request_id = null
WHERE interface_line_id = &interface_line_id;
COMMIT;
   
Then you navigated to Customers, Standard, Find appropriate customer record associated to customer record in Autoinvoice interface tables.  Clicked Ok and get following error message: 

FRM-40350: Query caused no records to be retrieved

Changes

Data migration of customer information.

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
Changes
Cause
Solution
References

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