My Oracle Support Banner

Understanding And Troubleshooting AutoInvoice Purge Interface Tables (Doc ID 1127413.1)

Last updated on OCTOBER 05, 2022

Applies to:

Oracle Receivables - Version to 12 [Release 11.5.10 to 12.0]
Oracle Receivables - Version 12.2.4 to 12.2.4 [Release 12.2]
Oracle Receivables - Version 12.1.3 to 12.1.3 [Release 12.1]
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 > Troubleshooting AutoInvoice for Oracle Receivables Release 11.5 Through 12 > Note 1127413.1

The AutoInvoice feature was developed to provide a means of creating large volumes of transactions without manual input. Since AutoInvoice processes this bulk data through an open interface table, it is not necessary to retain the data in the interface table once the transactions have been generated in Receivables. AutoInvoice Purge provides a mechanism to clean up the data once it has been processed.

This note contains an overview of the AutoInvoice Purge for Interface tables process. It provides setup, execution and troubleshooting information.

If you are encountering other issues involving AutoInvoice, please review Note 1075757.1, Troubleshooting AutoInvoice for Oracle Receivables Release 11.5 Through 12


There is another feature in Receivables called Archive and Purge.
This allows a user to archive old data from core Receivables tables (e.g. Transactions, Receipts, Adjustments) and then purges the data. Archive and Purge does not impact the interface tables used by AutoInvoice. These two features are separate and distinct. 

This note does not discuss Archive and Purge.

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. Overview of AutoInvoice Purge
 2. Running AutoInvoice Purge
    a. Automatically
    b. Manually
 3. Underlying Code and tables Impacted by AutoInvoice Purge
 4. Troubleshooting AutoInvoice Purge
    a. Orphan interface data
    b. Unable to Query records in Interface Lines
 5. Patching and Known Issues
 6. Still Have Questions?

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