EPY: Job Earnings Distribution and Calculation of Hours on Paysheets Rounding (Doc ID 623181.1)

Last updated on JULY 11, 2017

Applies to:

PeopleSoft Enterprise HCM Payroll for North America - Version 8.3 SP1 and later
Information in this document applies to any platform.

This document was previously published as Customer Connection Solution 200771527




Symptoms

Scenario 1

The original test case was to distribute an employee's regular salary between two departments at a 70%/30% split.  The employee is Hourly and has Standard Hours of 34.75 Weekly.  Pay is biweekly.

Expected results were:
     Dept 1 Hours = 34.75 hours/week * 2 weeks * 70% = 48.65 hours
     Dept 2 Hours = 34.75 hours/week * 2 weeks * 30% = 20.85 hours

Actual results were:
     Dept 1 Hours = 48.64
     Dept 2 Hours = 20.86

Conversely, if we test another employee with the same Job Data but a 30/70 split, we get these results:
     Dept 1 (30%) Hours = 20.84
     Dept 2 (70%) Hours = 48.66

While testing the rounding issue, also discovered that for Hourly employees, if a change is made to the employee's Job Earnings Distribution percentages after Paysheets are created, the changes are not picked up on a Pay Calc (i.e., the original distribution details and percentages are maintained).  However, for Salaried and Exception Hourly employees, the hours are recalculated with the new distribution percentages.


To summarize our findings,
1. Paysheet hours for Salaried employees are:
     A. Calculated correctly with no rounding error.
     B. Recalculated correctly if JED%s are changed after Paysheets are created.

2. Paysheet hours for Hourly employees are:
     A. Calculated incorrectly -- there appears to be a rounding error.
     B. Not updated/recalculated if JED%s are changed after Paysheets are created.

3. Paysheet hours for Exception Hourly employees are:
     A. Calculated incorrectly -- there appears to be a rounding error.
     B. Recalculated but incorrectly (same rounding error) if JED%s are changed after Paysheets are created.

This all occurs only when having odd hours, such as 34.75.

Scenario 2

If three decimal points are used then the hours on the Paysheet may not equal the number of hours needed.  For example, the below employee has 7 lines on the Job Earnings Distribution

Combo Code A - Percent 14.287 hours on Payline, per week, 5.71

Combo Code B - Percent 14.287 hours on Payline, per week, 5.71

Combo Code C - Percent 14.287 hours on Payline, per week, 5.71

Combo Code D - Percent 14.287 hours on Payline, per week, 5.71

Combo Code E - Percent 14.284 hours on Payline, per week, 5.71

Combo Code F - Percent 14.284 hours on Payline, per week, 5.71

Combo Code G - Percent 14.284 hours on Payline, per week, 5.71

 

The system will create 7 lines on the Paysheet for 39.97 hours, instead of 40 hours.  It is recommended that only 2 decimal points.  If 3 decimal points are needed then it will be necessary to adjust some lines so 40 hours is produced.

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