EGL9.2: Spreadsheet Journal Import(JRNL1) When Cancel On 'Copy Journal Sheet' Window Encounter "Runtime Error '9', Subscript Out of Range"

(Doc ID 2177813.1)

Last updated on MARCH 25, 2017

Applies to:

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



Spreadsheet Journal Import - When Cancel button is clicked on 'Copy Journal Sheet' window encountered an error.

Steps to Replicate:
1. Open JRNL1.XLSM file
2. Click on Copy button and select a sheet to copy
3. Instead of click on Copy button, click on Cancel button


Runtime Error '9':

Subscript Out of Range


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