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 MARCH 25, 2017

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.
****Checked for Currency on 25th Mar 2017****

Symptoms

Issue:
---------------
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.


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