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