EGL9.2:Spreadsheet Journal Import (JRNL1) Batch Process (GL_EXCL_JRNL) Creates Journal Though Amount has 3 Decimal Places

(Doc ID 2340066.1)

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.

Symptoms


Issue:

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.

Business Impact:

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. 

Cause

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