My Oracle Support Banner

EGL9.1: Spreadsheet Journal Import(JRNL1) If Using NEXT Journal Id, Allows Journal ID to be Incremented When the Import Fails (Doc ID 1348952.1)

Last updated on JULY 06, 2020

Applies to:

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



When using NEXT Journal ID Spreadsheet Journal Import Increments the Journal ID When the Import Fails.

Steps to Replicate:

1. Enter Spreadsheet Journal with invalid Dept ID
2. Click on Icon to Import the journal online

Actual Behavior:
Process fails with message

Imported 0 journals - System ID (Unit, Journal ID, Date) Reference, Description:
1026 (US001, 0000000325, 2011-06-13) -, Test NEXT Jrnl ID in Excel 2007 : Invalid Department value DEP01.

 However the Journal ID is assigned.

Expected Behavior:
If the Spreadsheet data failed import the Journal ID should not be incremented


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.