ETL9.1: Time Admin Creates Wrong Rounding Of Payable Time On TL_TA000900.ROUNDDAY.Step120 (SQL) (Doc ID 1529375.1)

Last updated on OCTOBER 29, 2015

Applies to:

PeopleSoft Enterprise HRMS Time and Labor - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

On : 9.1 version, Time Administration

Time Admin creates wrong rounding of payable time on TL_TA000900.ROUNDDAY.Step120 (SQL)

The rounding should be done according to workgroup setup.

The issue can be reproduced at will with the following steps:


1. Enter -5.75 as Holiday on 8 hours holiday scheduled day, so the Total should be: 8.00 - 5.75 => 2.25.
2. Run TimeAdmin. After the Holiday Template071 rule processing the TL_QUANTITY was 2.25 (which is correct) and then it goes in to TL_TA000900.ROUNDDAY.Step120 (SQL) and rounding the TL_QUANTITY as 2.00 (which is wrong).


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