Text Description of the Payables Open Interface Import Graphic

This graphic shows a summary of the sources of invoice data that are imported by Payables Open Interface Import and the database tables that store the data before and after the import process.

You can load invoice data into the Payables Open Interface Tables from the following sources:

  1. Inbound Invoice data file (810/INVOIC) in Oracle e-Commerce Gateway

  2. Quick Invoices

  3. Invoice data from external system

  4. Invoice data from credit card transactions. This data is originally stored in the Procurement Card Transactions Tables, AP_EXPENSE_FEED_DISTS

  5. Invoice data for lease payments from Oracle Assets and Property Manager

  6. 6. Payment Request type invoices from various applications such as Receivables.

The Payables Open Interface Import Process imports the invoice records into the Invoice Tables. The two primary invoice tables are AP_INVOICES_ALL and AP_INVOICES_LINES_ALL. The import process creates invoices with lines and scheduled payments. If the lines are matched to POs then distributions are also created.