My Oracle Support Banner

Troubleshooting AutoInvoice Customer, Address and Contact Errors and Exceptions (Doc ID 1097660.1)

Last updated on JUNE 05, 2024

Applies to:

Oracle Receivables - Version 11.5.10.0 and later
Information in this document applies to any platform.
Executable:RAXTRX - Autoinvoice Import Program


Purpose

Oracle Receivables (AR): AutoInvoice Information Center >Troubleshooting AutoInvoice for Oracle Receivables Release 11.5 Through 12 > Note 1097660.1

The purpose of this note is explain the usage of the Customer ID, Customer Contact and Customer Address fields in AutoInvoice (AI) and to provide step-by-step instructions to troubleshoot common errors and exceptions returned by AutoInvoice related to these fields.

This note should be used in conjunction with the following two documents:

Troubleshooting Steps

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
Purpose
Troubleshooting Steps
 1. Customer Fields: Usage and Validation in AutoInvoice
     a. Transaction (Batch) Source Setup:  Value vs. ID vs. None
         i. Value
         ii. ID
         iii. None
     b. Sold To
     c. Bill To
     d. Ship To
     e. Paying Customer
 2. Troubleshooting Common Errors and Exceptions
     a. Validate Record(s) Using AutoInvoice Interface Data Diagnostic test
     b. Review AutoInvoice Execution Report
     c. Review the Failed Transactions
         i. Interface Lines Form
         ii. Interface Data Collection Scripts & Querying RA_CUSTOMER_TRX_LINES_ALL
     d. Review the Transaction Source to Check which Fields are Validated
     e. Make Certain the Values are Valid
     f. AutoInvoice will Import Invoices for Inactive Customers
     g. Review Common Exceptions and Errors in Section 3
 3. Common Customer, Address and Contact Errors
 4. Still Have Questions?
References

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