My Oracle Support Banner

EGL9.2: While Clicking on 'Write To File' or 'Copy Sheet' Button in Spreadsheet Journal Import ( JRNL1_WS) Template Getting "Run-Time Error '6': Overflow" Error, If Sheet has More Than 32767 Rows (Doc ID 2683780.1)

Last updated on NOVEMBER 13, 2023

Applies to:

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

Symptoms

While clicking on 'Write To File' or 'Copy Sheet' button in Spreadsheet Journal Import ( JRNL1_WS) template getting an error,  if Sheet has More Than 32767 Rows:

 

Steps to Replicate:

  1. Open spreadsheet journal template JRNL1_WS and add a new sheet with 32767 Journal lines.
  2. Click on Home icon in template.
  3. Then click on either 'Write To File' or 'Copy Sheet' 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.