EGL9.2:Spreadsheet Journal Import (JRNL1) Creates Journal Having Amount With Incorrect Decimal Places
(Doc ID 2340066.1)
Last updated on OCTOBER 08, 2019
Applies to:PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
Batch spreadsheet journal import (GL_EXCL_JRNL) process is creating a journal even though the currency field goes out to three decimal places.
Steps to Replicate:
1. Populated JRNL1.xls file and write journal to a file (with 3 decimal places)
2. Uploaded journal thru GL_EXCL_JRNL (batch spreadsheet journal import)
3. When the journal was uploaded:
'Process completed successfully with 1 journals imported.
Imported these journals: System ID (Unit, Journal ID, Date) Reference, Description
1028 (USxxx, 0000000123, yyyy-mm-dd), To reclass journal to retro payment to proper fiscal year
Updated these journals: System ID (Unit, Journal ID, Date) Reference, Description
4. On Edit Journal process, Amounts retained the 3 decimal places
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