AutoInvoice Import and External Data

You can import transaction data from Project and Distributed Order Orchestration, and from non-Oracle financial systems, to create transactions in Receivables using AutoInvoice.

Use the AutoInvoice file-based data import spreadsheet to import external transaction data. The transaction data you import is temporarily stored in these AutoInvoice interface tables:

• RA_INTERFACE_LINES_ALL

• RA_INTERFACE_SALESCREDITS_ALL

• RA_INTERFACE_DISTRIBUTIONS_ALL

There are two other AutoInvoice interface tables:

• AR_INTERFACE_CONTS_ALL is populated if there are any revenue contingencies associated with the transaction line.

• RA_INTERFACE_ERRORS_ALL stores information about interface data that failed validation.

The AutoInvoice file-based data import spreadsheet and the Load Interface File for Import scheduled process are both part of the External Integration Services for Oracle Cloud.