Oracle EBS AP发票导入 API Rejection List 第四部分

Oracle EBS AP发票导入 API Rejection List 第四部分

The report lists the reason the invoice could not be imported and prints a brief explanation of the problem.

Invalid Who Information. Invalid information in one of the following columns: LAST_UPDATED_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY.

Invoice Amount Incorrect. Invoice amount (AP_INVOICES_INTERFACE.INVOICE_AMOUNT) does not equal the sum of the line amounts (AP_INVOICE_LINES_INTERFACE.AMOUNT) for rows with the same INVOICE_ID.

Line Has Price Break. You are matching to a blanket purchase order release at the line level which has been set to allow price override. You have provided only line level data. Payables cannot identify the shipment to

which it should match because shipments can have different prices. If you identify the shipment, then Payables can complete the match.

Line Type Cannot Be AWT. Open Interface Import will not import an invoice if the LINE_TYPE_LOOKUP_CODE is AWT (automatic withholding tax).

No Exchange Rate. The invoice currency is different from your functional currency, you have entered USER as the exchange rate type, and you have not entered a value for DEFAULT_EXCHANGE_RATE.

No Invoice Lines. You must enter at least one invoice line to create an invoice.

No Invoice Number. INVOICE_NUM is a required column but it is NULL for this invoice.

No PO Line Num. You matched the invoice to a multi-line purchase order, and you did not enter purchase order line number (PO_LINE_ID or PO_LINE_NUMBER).

No Supplier. You did not identify the supplier in any of the following columns: VENDOR_ID, VENDOR_NUM, or PO_NUMBER.

No Supplier Site. You did not identify the supplier site in any of the following columns: VENDOR_SITE_ID, VENDOR_SITE CODE, or PO_NUMBER.

No Tax Code. You did not enter a tax code, and a valid tax code could not be found based on the Tax Name Default hierarchy you defined in the Payables Options window.

No Terms Info. You did not specify payment terms in the import tables, the invoice is not matched to a purchase order, and you have not specified default payment terms for the supplier site.

Non Unique Location Code. You have provided a Ship-To location as the matching criterion and it is not unique. For example, you provide a ship to location of Boston and Boston is the ship to on three different shipments for the purchase order.

Non-Unique Location Code. You have provided a Ship-To location as the matching criterion and it is not unique. For example, you provided a Ship-To location of Boston, and Boston is the Ship-To location on three

different shipments on the purchase order.

Not Pay Site. The supplier site is not enabled as a pay site in the Supplier Sites window in Payables.

Orphan Line. No invoice exists for this invoice line.

Pay X Rate Not Fixed. Invoice currency and payment currency are not associated fixed-rate currencies.

Unit Prc Not Equal to PO. Unit price does not equal the Unit Price on the Purchase Order within the tolerance you defined in the Invoice Tolerances window.

UOM Does Not Match PO. Unit Of Measure does not match the Unit of Measure on the purchase order.

-- 刘轶鹤