E1: 07: Payroll Rounding Issue For Hourly Employees. (Doc ID 2735255.1)

Last updated on SEPTEMBER 05, 2024

Applies to:

Symptoms

Pay rate calculation per time card vs pay stub is different.

On the surface, this doesn't seem like a large issue, but when you have 400 employees doing this, it starts to add up.  The bigger issue is what will appear on the pay advice. As more time cards are included, it has the potential to get larger or smaller.

STEPS TO REPRODUCE
==================
For five of the time cards, totaling 31.5 hours, working at 15.550 per hour.
The other three timecard entries, totaling 8.5 hours, working at 18.770 per
hour.  If you do the math, the following shows:

 Time card 1 -> 7.5 hours * 15.550 = 116.625 (which would concat to 116.63)

Time card 2 -> 7.5 hours * 15.550 = 116.625 (which would round to 116.63)

Time card 3 -> 4.5 hours * 15.550 = 69.975 (which would round to 69.98)

Time card 4 -> 6.5 hours * 15.550 = 101.075 (which would round to 101.08)

Time card 5 -> 5.5 hours * 15.550 = 85.525 (which would round to 85.53)

Time card 6 -> 2.5 hours * 18.770 = 46.925 (which would round to 46.93)

Time card 7 -> 3.5 hours * 18.770 = 65.695 (which would round to 65.70)

Time card 8 -> 2.5 hours * 18.770 = 46.925 (which would round to 46.93)
 

This would total to (actual) 649.37 and (rounding) 649.41.  

On the surface, this doesn't seem like a large issue, but when you have 400 employees doing this, it starts to add up.  The bigger issue is what will appear on the pay advice.  Our pay advice shows the hourly employees (from R07231):

Hourly Rate        Total Hours       Total Pay at that Rate

So for this one, Joe would see:
 
15.550                       31.5             489.85
18.770                        8.5              159.56

You can see, however, that these numbers don't foot.  

15.550 * 31.5 =  489.825 -> 489.83
18.77 * 8.5 = 159.545 -> 159.55

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.