My Oracle Support Banner

EGL 9.2: Spreadsheet Journal Import (JRNL1_WS) Fails with Invalid Department for Active Effective Dated Row (Doc ID 2645796.1)

Last updated on JULY 06, 2020

Applies to:

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

Symptoms


When attempting to import spreadsheet journal, the following error occurs:

 


Replication Steps

1. Dept ID 21100 has effective dated rows as follows
   - 11/05/2019 Inactive
   - 01/01/1900 Active
2. Enter spreadsheet journal with above Dept and Journal Date 09/25/2019
3. Attempt to import

Refer replication document attached.


Note: Journal entered and Edited online runs successfully for above scenario.

Changes

 

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
Changes
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.