EGL: Spreadsheet Journal Import(JRNL1) Encountered 'Run-time error '1004': Application-defined or object-defined error' While Using Excel 2016

(Doc ID 2190744.1)

Last updated on JULY 20, 2017

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.



When trying to upload journal entry via Spreadsheet Journal Import using Excel 2016 the user receives an error. Same Template works without error using Excel 2010 and 2013.


Run-time error '1004':
Application-defined or object-defined error

Steps to Replicate:
The issue can be reproduced at will with the following steps:

  1. While Using Excel 2016 create a journal import using JRNL1
  2. Click Import
  3. Run-time error '1004': Application-defined or object-defined error


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