E1: 08W: Work With Retroactive Pay Rules (P186701) Testing Formula Results In Incorrect Calculation When The Decimal Format Character Is Set With A Comma. (Doc ID 2604779.1)

Last updated on JANUARY 24, 2022

Applies to:

Symptoms

In P186701 (Work with Retroactive Pay Rules) when testing the formula, the system is incorrectly calculating the Hours Worked when the user has the Decimal Format Character in My System Options _ User Profile Revisions set to a comma.
The hours worked are calculated correctly when the Decimal Format Character is set to a period or is blank.

STEPS:

1- Setup User profile revisions with a comma in the Decimal Format Character field.
2- Fast path to P186701 (Work With Retroactive Pay Rules) select into your rule.  
    Now use the Visual Assist on the New Hours Worked field, select your function with your formula then go to Form exit and select Test
    search for and select a Timecard Transaction No and click on the  Calculate Formula button.
    Notice the Hours worked is calculated incorrectly.
3- Repeat the same test after changing the  Decimal Format Character to a period.
    Notice the hours worked is correct.  Same correct result when using a blank in the Decimal Format Character field.

Changes

Cause

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