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 laterInformation 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 |