Payables Open Interface Import Troubleshooting
There are two types of errors that you may experience while trying to import invoices: incorrect data or program failure.
The Payables Open Interface Report lists invoices that were not imported correctly. If there is a problem at the invoice level, the invoice is rejected without further validation. Examples of these fatal errors are:
- No supplier or supplier site
If the invoice level information is correct, Payables will validate all values at the line level, and the rejections report will list all line level problems. If a distribution is rejected, the whole invoice is rejected.
- The invoice number is a duplicate
You can correct the data in one of the following ways:
- Use the Open Interface Invoices window to correct problems directly in the Payables Open Interface tables.
- Submit Purge Payables Open Interface to purge the rejected records from the Payables Open Interface tables, then import corrected data for the rejected records into the tables.
If there is a failure with either the EDI Gateway Program or the Payables Open Interface Program, you can query the program in the Concurrent Requests Summary. You can read about any errors in the log file.
Payables Open Interface Import commits in cycles of 100. For example, if there is an error that stops the import program when it is validating the 350th invoice record, the system will have already committed the first 300 invoices.
Payables Open Interface Import