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 APRIL 26, 2017

Applies to:

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

Symptoms

Issue:
-------

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

Cause

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 hundreds of Community platforms