Different Sources that can load data into Open invoice
import interface tables
- Quick Invoices window
- Oracle e-Commerce Gateway
- Credit Card transaction data
- Property Manager
- The Oracle Assets Export Lease Payments to Payables process
- Oracle XML Gateway
- SQL*Loader OR BPEL Interfaces can load invoice information from Legacy Systems
- Invoices that your suppliers entered and submitted online via Oracle iSupplier Portal
Interface Tables:
AP_INVOICES_INTERFACE
AP_INVOICE_LINES_INTERFACE
Base Tables:
AP_INVOICES_ALL
AP_INVOICE_LINES_ALL
AP_INVOICE_DISTRIBUTIONS_ALL
(&)
Payment Tables
Basic Process:
The
Payables Open Interface program validates each record you select for import,
and if the record contains valid data, then the program creates a Payables
invoice with distributions and scheduled payments based on the invoice header
and line information in the record.
Records in the
AP_INVOICE_LINES_INTERFACE table create one or more invoice distributions. Note
that one row may create more than one distribution. For example, if you enter a
Tax line in this table and prorate it across three Item lines, during Open Interface
Import the system will create three Tax invoice distributions based on the
single Tax line in this table.
