My Oracle Support Banner

Spreadsheet Import Fails for Invoices with Multiple Item and Tax Lines (Doc ID 1923423.1)

Last updated on APRIL 04, 2019

Applies to:

Oracle Fusion Payables - Version and later
Information in this document applies to any platform.


On : version, Receive and Process Invoices

The Invoice Import fails if the invoices have multiple items lines and each item line has multiple tax lines,  AND the Tax Lines are entered following Item lines.
For example, if the invoice lines are entered in the following sequence, the invoice import fails and no rejection reason is displayed in the invoice import report:
Line 1 Item Line 1
Line 2 Tax Line  1
Line 3 Tax Line  2
Line 4 Item Line 2
Line 5 Tax Line  1
Line 6 Tax Line  2

However, if the invoice lines are entered in the following sequence, the import is successful:
Line 1 Item Line 1
Line 2 Item Line 2
Line 3 Tax Line  1
Line 5 Tax Line  2
Line 5 Tax Line  1
Line 6 Tax Line  2

Invoices to be imported successfully regardless of the order in which Item and Tax lines are entered in the spreadsheet.

The issue can be reproduced at will with the following steps:
1) Populate the invoice information in PayablesStandardInvoiceImportTemplate.xlsm, making sure to alternate Item and Tax lines.
2) By using the “Generate CSV File” button in the first tab of the spreadsheet, generate the zip file.
3) Upload the zip file to Fusion by using the “File Import and Export” functionality.
4) Run “Load Interface File for Import”

The issue has the following business impact:
Due to this issue, the invoices which have more than one item lines followed by tax lines are not imported.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.