My Oracle Support Banner

EGL9.2:Spreadsheet Journal Import (JRNL1_WS) Results to Error: 'Imported 0 journals - System ID (Unit, Journal ID, Date) Reference, Description:' ' Invalid decimal positions on amount value nnn.nn for currency' (Doc ID 2332674.1)

Last updated on JULY 14, 2023

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
*** Checked for currency on 04-July-2023 ***


Symptoms

Issue:

Using the new spreadsheet import template - JRNL1_WS.xlsm - importing lines with Currency field value imports 0 journals with below error/s:


Steps to replicate:

1.  Using spreadsheet journal import (JRNL1_WS.xlsm), populate the journal details but use Currency field value = <blank>
2.  Import the journal using 'Import Now' button.

Replication screenshots attached. 

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
Cause
Solution
References


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