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.