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

Last updated on SEPTEMBER 04, 2014

Applies to:

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

Symptoms

On : 11.1.7.0.0 version, Receive and Process Invoices

ACTUAL BEHAVIOR
---------------
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

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

STEPS
-----------------------
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”

BUSINESS IMPACT
-----------------------
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.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms