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.

Symptoms

Issue:
-------

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

Error:
-------

Runtime Error '9':

Subscript Out of Range

Cause

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