Rate Definitions With Balances As Contributors Gives Incorrect Results (Doc ID 2456568.1)

Last updated on OCTOBER 06, 2020

Applies to:

Symptoms

ACTUAL BEHAVIOR

when the reference date is given as "Payroll Last Period end Date" , the amount computed is as follows:

Annual Salary : 39000
Monthly amount:39000/12=3250
Overtime in Dec-2017:265(11*11+12*12)
Thus the hourly rate will be :((3250+265)*12)/2080=20.27
For 100 hrs of Discretionary disbursement amount is 20.27*100=2027.88

EXPECTED BEHAVIOR


The above computation should have been made with Overtime balance of Jan-2018 which is 20.

STEPS

The issue can be reproduced at will with the following steps:
1.Create an Element "Annual Salary" which is a recurring

2.Create an element "Overtime" which is a non recurring

3.Create a Rate Definition which has Annual salary and Overtime as a rate contributor

4.Create an Absence Element " Holiday Pay" enabling discretionary disbursement and Final Disbursement

5.Create an Absence Plan "Holiday Pay" which has the above rate definition and absence element attached

6.For employee#XXXXXX ,create Overtime element entries of 11*11 and 12*12 in the month of Dec-2017

7.Process QuickPay for Dec-2017.

8.For employee perform absence balance disbursement in the month of Jan-2018 for 100 hours.Add Overtime entry of 5*4

9.Process QuickPay for Jan-2018.



Following are the inferences drawn:

1.It is found that the system computes the discretionary disbursement with Overtime only when reference date is specified as "Payroll Last Period end Date"

2.When no reference date is given , the system ignores the Overtime balance.

3.In the above example , when the reference date is given as "Payroll Last Period end Date" , the amount computed is as follows:

Annual Salary : 39000
Monthly amount:39000/12=3250
Overtime in Dec-2017:265(11*11+12*12)
Thus the hourly rate will be :((3250+265)*12)/2080=20.27
For 100 hrs of Discretionary disbursement amount is 20.27*100=2027.88

Cause

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