My Oracle Support Banner

EGL9.1 - 9.2: Spreadsheet Journal Import(JRNL1) Misleading Decimal Place Setting On 'Define Setup and Options' Window (Doc ID 1579017.1)

Last updated on FEBRUARY 03, 2022

Applies to:

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


User changes the decimal places of Amount field from 2 to 5 in Setup > Configure > Amount field. It resets back to 2 decimal places again when user goes back to verify the setting.
Although the decimal rounding is still occurring based on the setting of 5 decimals, the displayed setting as 2 decimals, which is misleading.

Steps To Replicate:
The issue can be reproduced at will with the following steps:
1. Open jrnl1.xlsm
2. Go to Setup > Configure > Field Format for FOREIGN_AMOUNT, MONETARY_AMOUNT, STATISTIC_AMOUNT
3. Change the decimal places of Amount field from 2 to 5 and click 'Apply'.
4. Save jrnl1.xlsm.
5. Go back to verify the decimal place again for amount fields and it is reverted back to 2.




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.