Understanding And Troubleshooting AutoInvoice Purge Interface Tables
(Doc ID 1127413.1)
Last updated on JUNE 14, 2021
Applies to:Oracle Receivables - Version 184.108.40.206 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
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.
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
|1. Overview of AutoInvoice Purge|
|2. Running AutoInvoice Purge|
|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?|