My Oracle Support Banner

EGL 9.2: Spreadsheet Journal Import (JRNL1_WS) Sometimes Fails with "Imported 0 journal" When Line Description is Over 30 Characters (Doc ID 2682110.1)

Last updated on SEPTEMBER 26, 2022

Applies to:

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


Spreadsheet Journal Import (JRNL1_WS) behaves inconsistently when line description is over 30. Import succeeds in certain cases by truncating the description and fails in other cases with below message:

Steps to Replicate:

Case 1

1. Enter Spreadsheet Journal with line description like Abc.DE fgh. Bijk.ab Jul'15- Aug.'21, which is more than 30 characters
2. Attempt to Import and above message is received

Case 2

1. Enter Spreadsheet Journal with line description like Abc.Abcdefgh Bcd Hijkl.- C'efg'hi, which is also more than 30 characters
2. Import successful with JRNL.LINE_DESCR truncated to 30 characters

Replication document attached.




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.