My Oracle Support Banner

Troubleshooting AutoInvoice for Oracle Receivables Release 11.5 Through 12 (Doc ID 1075757.1)

Last updated on JUNE 21, 2023

Applies to:

Oracle Project Billing - Version and later
Oracle E-Business Tax - Version 12.0 and later
Oracle Receivables - Version and later
Oracle Contracts - Version 11.5.10 and later
Oracle Order Management - Version and later
Information in this document applies to any platform.
Executable:RAXMTR - Autoinvoice Master Program
Executable:RAXTRX - Autoinvoice Import Program
Executable:RAXDEL - Autoinvoice Purge Program


Oracle Receivables (AR): AutoInvoice Information Center > Generic Setup and Troubleshooting Resources > Note 1075757.1

This note is intended to walk you through a set of sequential steps that will facilitate troubleshooting AutoInvoice issues in Releases 11.5 through 12.1.

There are many notes in the Knowledge base written to help you troubleshoot AutoInvoice. However, since this feature is large and is impacted by many components, it may get confusing to navigate through the notes to find your solution.

We highly recommend using the following notes:
  • <Note 1523525.1>, EBS Oracle Receivables AutoInvoice Analyzer: Overview and Installation Instructions
  • <Note 1483249.1>, AutoInvoice: Debugging Flow Advisor, it is designed to help you narrow in and identify the note that may assist in resolving your issue.



In the images below and/or the attached document, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance). Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.


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
Troubleshooting Steps
  1. How Does AutoInvoice Work? 
 2. Alternatives to AutoInvoice
 3. Using Diagnostics to Check Setup
 4. Identifying What Went Wrong
     a. Import Failed: ERROR
     b. Import Completed: Exception Report ERROR
     c. Import Completed:  Nothing Imported
     d. Transaction Imported: Record is Incorrect
     e. Master Program Failed: ERROR
     f. Import Never Completes
 5.  Validating the Data Being Imported (Custom Interface vs. Seeded Integration)
     a. Custom Integration or Data Migration Issues
     b. Integration with Oracle Applications that Feed AutoInvoice
 6. Troubleshooting Specific Steps in AutoInvoice
     a. Accounting (AutoAccounting)
     b. Credit Memos
     c. Customer, Addresses and Customer Contact
     d. Currency and Exchange Rates
     e. Dates: Transaction Date, GL Date
     f. Flexfields: Transaction, Global, Descriptive
     g. Freight
     h. Grouping Rules
     i. Inventory Transactions (Warehouse, Items, etc)
     j. Line Ordering
     k. Numbering: Document Sequencing and Transaction Numbering
     l. Payment Terms
     m. Purge
     n. Invoicing and Accounting Rules
     o. Revenue Recognition
     p. Receipt Method
     q. Remit To Addresses
     r. Sales Representatives, Sales Credits and Territories
     s. Taxes
     t. Transaction Sources
     u. Transaction Types
     v. Unit of Measure
     w. Commitments
 7. Environment Issues: Performance, Hardware, Database, Memory or other peripheral issues
 8. Fixing Data Issues
 9. Capturing Debug Logs and Trace Files
 10. Additional Diagnostics
 11. Still Have Questions?
 12. Logging a Service Request

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