My Oracle Support Banner

EGL9.2:Spreadsheet Journal Import (JRNL1_WS) Amounts Are Reset After Import When Regional Settings Is Changed From Decimal( .) To Comma( ,) (Doc ID 2596757.1)

Last updated on MAY 12, 2021

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


When using the Decimal separator to ',' and the Thousand separator to '.' on Region and language section on PC and on Excel and PIA , import a journal through journal import with 3 decimals after "," , the amounts are arriving in PIA multiplied by 100.

The issue can be reproduced with the following steps
1.Change in PC, on Excel and in PIA , the Region and language section set up the  Decimal separator to ',' and the Thousand separator to '.'
2.Go to Journal Spreadsheet and import a journal with a following amount,yyy
3.On PIA, it will arrive,000 ( multiplied by 100 )
4. The issue is happening for both updating an existing journal from PIA and a newly imported journal.




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.