My Oracle Support Banner

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 AUGUST 04, 2020

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
*** Checked for Currency on 08/03/2020 ***

Symptoms

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

Error:
Runtime Error '9': Subscript Out of Range

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

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.