Resolving Payables Invoice Import Exceptions
Information may not import properly for a variety of reasons, including duplicate invoice numbers or invalid suppliers. When you submit Payables Invoice Import, Payables automatically prints the Payables Invoice Import Exceptions Report. This report lists employee and expense report information for each expense report for which Payables did not create an invoice. If you import invoices, the report lists supplier and invoice information for each invoice that Payables did not import. For detailed information on all exceptions, see Payables Invoice Import Exceptions Report.
1. Review the Payables Invoice Import Exceptions Report to identify the reason(s) your information did not import properly.
2. Correct the problems depending on your source:
- Payables Expense Reports: Fix expense report problems in the Expense Reports window.
- Oracle Projects: The tieback process updates all expense reports as rejected in Oracle Projects. Correct rejected expense reports in Oracle Projects.
- External Accounting System: Fix invoice problems in the flat file and reload with SQL*Loader, or use SQL*Plus to correct problems directly in the Payables Invoice Import Interface Tables.
3. Resubmit Payables Invoice Import.
Review the Payables Invoice Import Exceptions Report to confirm that you resolved the problems that had prevented import.