My Oracle Support Banner

Rapid Implementation General Ledger Excel Spreadsheet Step 1 Validate, Run-time Error 9 Subscript Out Of Range (Doc ID 2342055.1)

Last updated on MAY 12, 2020

Applies to:

Oracle Fusion General Ledger - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Symptoms

When running the Step 1: Validate on the Rapid Implementation General Ledger Excel Spreadsheet the following error occurs:

Microsoft Visual Basic
Run-time error '9':
Subscript out of range

Steps to reproduce the issue:

1. Open a previously used RapidImplementation General Ledger Spreadsheet.

2. Change the Chart of Accounts segment names in the 'COA, Calendar, and Ledger' sheet.

3. Save the work.

4. In the 'COA, Calendar, and Ledger' sheet press the 'Step 1: Validate' button

-> Error:

Microsoft Visual Basic
Run-time error '9':
Subscript out of range 

Debug shows the following line as the one causing the error:

Sub checkValidValues(worksheetname As String, valReportSheet As String, iErrorCounter As Integer)
Dim rCell As Range
Dim rRng As Range
Dim lastRow As Long
lastRow = Sheets(worksheetname).Range("L" & "1048576").End(xlUp).row

Due to this error validation cannot continue and structure cannot be uploaded to Fusion Applications

Changes

The spreadsheet file was used from another project and some information was replaced with new values for a new project, also using cut and paste and drag and drop (using pasting only values function in Excel)

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
Changes
Cause
Solution

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