Copy and Paste, Drag and Drop Functionality in the Invoice Header Identifier Column of the Create Invoice in Spreadsheet Causing Problems after Upgrade

(Doc ID 1943985.1)

Last updated on NOVEMBER 11, 2014

Applies to:

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


Client needs to enter more than 100 invoices at a time using the spreadsheet. After inserting new rows and numbering these rows using the EXCEL function of drag and drop, the spreadsheet becomes unusable. The web picker for all columns becomes inactive. It is also not possible to directly enter values and have them imported.

Also, when entering an invoice with more than 1 line and the value for 'Invoice Header Identifier' is copied down the sheet, the same problems arise

The following Visual Basic error is displayed:

Run-time error '13': Type mismatch 




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