My Oracle Support Banner

E-PG: Pivot Grid Number Value Problem With Comma As Decimal Separator (Doc ID 2559720.1)

Last updated on NOVEMBER 30, 2020

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.57 to 8.58 [Release 8.4]
Information in this document applies to any platform.

Symptoms

When using a Comma as Decimal Separator, the numbers with decimals are rounded up like there is no decimal.

For example: 888,99 is turned into 88899. And 55,99900 will become 5599900.
The problem does not occur when using a Dot as the Decimal Separator.

E.g. Using Pivot Grid HGA_EVENT_COST_ADM. 


The issue can be reproduced at will with the following steps:
1. Login to PIA
2. Navigate to Reporting Tools > Pivot Grid > Pivot Grid Viewer
3. Search by a delivered Pivot Grid (e.g. HGA_EVENT_COST_ADM)

*** Test 1 ***

1. Navigate to Personalization > System options: decimal separator to dot, digit group separator to comma.
2. In My Preferences > Regional Settings > decimal separator to dot, digit group separator to comma.
3. Log on in ENG, open Pivot Grid HGA_EVENT_COST_ADM: no problem scrolling through the details list

*** Test 2 ***

Change the Decimal and Digit Group separators.
1. Navigate to Personalization - System options, then set decimal separator to comma, digit group separator to dot.
2. In My Preferences - Regional Settings, then set decimal separator to comma, digit group separator to dot.
3. Log on in ENG, open Pivot Grid HGA_EVENT_COST_ADM: no problem scrolling through details list;

*** Test 3 ***

As a 'normal' number doesn't use a Currency Code Symbol, the following tests are to see how the numbers show without a Currency Code attached.
Remove the CURRENCY_CD field for USD so the value becomes a regular number value and show the output in the Pivot Grid:

1. Navigate to Reporting Tools > Pivot Grid > Pivot Grid Wizard
2. Select HGA_EVENT_COST_ADM;
3. At the Step 3, go to Formatting Options and deselect Field User Currency for 'Cost in User Currency' under the column 'Currency Control Field'
4. Make sure it is not used any more as Currency Control Field for Field Cost in User Currency;
5. Save the Pivot Grid.
6. Log on in ENG, open Pivot Grid HGA_EVENT_COST_ADM: numbers are rounded up.

*** Test 4 ***

Change back the Decimal and Digit Group separators.
1. Navigate to Personalization - System options, then set decimal separator to dot, digit group separator to comma.
2. In My Preferences - Regional Settings set decimal separator to dot, digit group separator to comma.
3. Log on in ENG, open Pivot Grid HGA_EVENT_COST_ADM: numbers are shown as numbers.

Conclusion:
Without a Currency Code Field and using Comma as Decimal Separator, a number is rounded up automatically to the maximum.
Using a Dot as Decimal Separator doesn¿t create the problem.
To prove there is a problem with numbers in the Details and the Charts, a Dummy Currency Code can be created and use that in the Query and Pivot Grid.

*** Test 5 ***

1. Create a Currency Code
   1.1. Navigate to Setup HCM > Foundation Tables > Currency and Market Rates;
   1.2. Create Code PVG.
2. Add the Currency Code to the output of the Query HGA_EVT_COST_ADM
3. Create an expression that refers to the Currency Code PVG and use this as a field instead of the USD that is used as field F.CURRENCY_CD.
4. Add the Currency Code Field 'PVG¿ to Pivot Grid HGA_EVENT_COST_ADM and use this as the Currency Code.
5. Log on in ENG, open Pivot Grid HGA_EVENT_COST_ADM: no problem scrolling through details list;

*** Test 6 ***

Change the Decimal and Digit Group separators.
1. Navigate to Personalization - System options, then set decimal separator to comma, digit group separator to dot.
2. In My Preferences - Regional Settings set decimal separator to comma, digit group separator to dot.
3. Log on in ENG, open Pivot Grid HGA_EVENT_COST_ADM: numbers are again shown as numbers. With a Comma as Decimal Separator.

Conclusion:
For a Dot as Decimal Separator, it doesn't really matter if a Currency Code is used.
A Number value will show as a Number.
For a Comma as Decimal Separator, a Currency Code has to be created to be able to show a Number value as a Number. Otherwise all numbers will be rounded up. Possibly to millions.



Changes

 

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
Changes
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.