AutoInvoice is one of several utilities provided to import transactions. Other options include:
- Oracle EDI Gateway
- Oracle Receivables API's
- XML Invoices (Part of Bill Presentment Architecture)
Despite the availability of alternatives, AutoInvoice is by far the most popular and heavily used integration point for Receivables (AR) transactions.
AutoInvoice is run using the Concurrent Request submission process. Through the Concurrent Request form, AutoInvoice can be scheduled to run on a periodic basis.
When scheduling or submitting AutoInvoice, parameters allow you to control what data sources are used when importing records and what dates default on transactions. Additional controls are available on the transaction source that you specify on the records being imported.
AutoInvoice Master Program (RAXMTR): Upon submission the master program is called. This program coordinates the activities being done such as gathering statistics, marking records for processing (setting request IDs on blocks of records, parallel processing). The master program also spawns and manages child requests for importing and purging of data.
AutoInvoice Import Program (RAXTRX): The key step in AutoInvoice is the import program. Upon submission this request is spawned by the Master Program. It converts the data in the interface table into invoices and also produces the execution and validation reports.
Output of the AutoInvoice Import is referred to as AutoInvoice Execution and Validation report.
AutoInvoice Purge (RAXDEL): This is conditionally run after import (based upon your AR system options settings).
Tip:
To correct the error, navigate back to the lines form and position your cursor on the Line type field, Click on the folder menu and click on Show field. Doing this will allow you to expose more fields from the table in the form.
Tables involved:
- RA_INTERFACE_LINES_ALL
- RA_INTERFACE_DISTRIBUTIONS_ALL
