My Oracle Support Banner

EGL: Spreadsheet Journal Entry Line Limitation (JRNL1) (Doc ID 661216.1)

Last updated on MAY 11, 2018

Applies to:

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

Goal

If user creates a new spreadsheet journal entry sheet and do a "Ctrl-End", the cursor will position itself on cell AV16384 of the excel worksheet. This implies Excel determines that the last row of data on the worksheet is on Cell AV16384 (Cell AW16455 for Excel 2007 and above; BC16385 for Excel 2016). So even before journal header and journal lines are inserted, Excel has consumed about 16384 rows. When 49151 journal lines are inserted, Excel reaches its maximum limit (Microsoft Excel 2000, 2003).

Can Spreadsheet Journal Entry be used to create journals with 60,000 or more rows?

Solution

To view full details, 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 a vibrant support community of peers and Oracle experts.