EGL9.2:Spreadsheet Journal Import (JRNL1) Batch Process (GL_EXCL_JRNL) Creates Journal Though Amount has 3 Decimal Places
Last updated on JANUARY 04, 2018
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.
Test in PUM18 environment this returns, which correctly indicated there were errors and did not create a journal.
This is causing problem with any reports that are pulled from the file
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 (UCS01, 0002947736, 2017-09-12), To reclass our 9/6/17 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
Replication screenshots attached.
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