Previous	Next		Contents	Index	Navigation	Glossary	Library

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 EDI Gateway, define the trading partner. See: Defining Trading Partner Information.

   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).

   In Oracle EDI Gateway, define any code conversions for the transaction. See: Defining Code Conversion Categories and Assigning Categories.

   Use Oracle EDI Gateway to submit the EDI Gateway Invoice Inbound Program from the Run EDI Inbound Datafile Import Process window. See: Running the EDI Invoice Inbound Program.

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.

   Transfer invoices into the Payables Open Interface tables. See: Using SQL*Loader to Populate the Payables Open Interface tables.

Additional Prerequisites for Invoices You Transfer Using the Credit Card Invoice Interface Summary.

   Transfer invoices into the Payables Open Interface tables. See: 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:

• Payables Open Interface Report

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 Options

Defining Financials Options

Payables Open Interface Import Troubleshooting

Account Overlay in Payables Open Interface Import