Submitting Payables Open Interface Import
Use Payables Open Interface Import to import invoices from the Payables Open Interface Tables.
If you are importing EDI invoices through the Oracle EDI Gateway, you can submit the EDI Invoice Inbound Set. This report set submits both the EDI Gateway program, which populates the Payables Open Interface Tables, and the Payables Open Interface Import Program, which transfers the invoice data from the interface tables into the invoice tables in Payables. To submit the EDI Invoice Inbound Set, see: Running the EDI Invoice Inbound Program. The discussion below describes how you can submit the EDI Gateway program and the Payables Open Interface Program separately. You may need to submit Payables Open Interface Import separately if you have had rejections that you have fixed and want to import remaining records.
Payables supports the outbound application advice (824/APERAK) for EDI invoices. When you submit the Payables Open Interface Outbound Advice, Payables creates a notification for invoices that were successfully imported and those that failed import, and you can send this notification to your supplier via the EDI Gateway.
Prerequisites
Enter suppliers and supplier sites in the Payables Suppliers window. See: Entering Suppliers.
Additional Prerequisites for EDI (810/INVOIC) Invoices
In Oracle EDI Gateway, enable the Inbound Invoice Transaction for each supplier you define as a trading partner. See: Enabling Electronic Transactions (Oracle EDI Gateway User's Guide).
Additional Prerequisites for Invoices You Transfer Using SQL*Loader
Use the QuickCodes window to define a Source type QuickCode. In the Type field of the QuickCodes window, select "Source." Enter any name you want in the "Name" field, except EDI Gateway, or Credit Card. See: QuickCodes.
Additional Prerequisites for Invoices You Transfer Using the Credit Card Invoice Interface Summary.
To submit Payables Open Interface Import:
1. In the Submit Request window, choose Request in the Type field. In the Name field, enter Payables Open Interface Import.
2. Enter the report parameters. For more information on report parameters, see Payables Open Interface Import Parameters. In the Source field, select the source name from the list of values. If your records have a Group and you want to import invoices for only that group, enter the Group. This will allow you to import smaller sets of records concurrently for the same source, which will improve your performance. If you use batch control, enter a Batch Name.
3. Choose OK to submit Payables Open Interface Import. Payables creates invoices with the following attributes:
- Invoice Number you specified in the flat file
- Scheduled payments based on payment terms of the purchase order, if you matched to one. If you did not, they are from the flat file. If you did not match to a purchase order or specify terms in the flat file, the terms are from the supplier site.
- Payment Method from the supplier site
- Project Information from purchase order if you matched to a project related purchase order
When the program is complete, you can query the new invoices in the Invoice workbench. The new invoices are ready for the normal process of approval and payment.
Payables automatically produces the following report so you can review the invoices Payables Open Interface Import successfully created, and the invoices Payables Open Interface Import was unable to import:
Fix problems that are identified in the Payables Open Interface Report. You can either use the Open Interface Invoices window to make changes in the Payables Open Interface tables, or you can purge the rejected records and load a new flat file into the table. You can then resubmit Payables Open Interface Import.
See Also
Payables Open Interface Import
Payables Options
Defining Financials Options
Payables Open Interface Import Troubleshooting
Account Overlay in Payables Open Interface Import