EGL: Spreadsheet Journal Import(JRNL1) Encountered 'Run-time error '1004': Application-defined or object-defined error' While Using Excel 2016
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:
- While Using Excel 2016 create a journal import using JRNL1
- Click Import
- 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