My Oracle Support Banner

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.