My Oracle Support Banner

EGL9.2:The System Generated Journal ID Is Replaced With '1' When Journals Are Created By Spreadsheet import (JRNL1_WS) (Doc ID 2972821.1)

Last updated on JANUARY 10, 2024

Applies to:

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


The system generated Journal ID is replaced with a '1' when Journals are Created By Spreadsheet import (JRNL1_WS)

"Imported 1 journals - System ID (Unit, Journal ID, Date) Reference, Description: 1423 (US001, 1, 02/02/2023) -,

Steps to reproduce the issue:

1) Open the ¬JRNL1_WS.xlsm template

2) Click on the Setup & Defaults button and populate the subpage Define Options and Defaults

3)Keep the journal_id as Next

4)Run the import process

More information can be found in the attached replication document.





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

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