E1: 07: Overtime Rule Set Processing (R186405) Uses Wrong Rate For Regular Hours (Doc ID 2879889.1)

Last updated on APRIL 11, 2024

Applies to:

Symptoms

Overtime Rule Set Processing (R186405) applies the wrong wage rate for regular hours, on a time entry for overtime hours. It selects the lower Union wage rate from the Union Rates table (F069126) instead of the higher wage rate populated in the Employee Basic Compensation (P0801CMP) screen. This ignores the “Assign Highest Pay Rate” processing option set in the Time Entry Master Business Function (P050002A). Consequently, the employee will receive a lower pay amount than they should for a day when they worked overtime.

Steps to duplicate:

1. Time Entry Master Business Function (P050002A) has the following settings
   1. Process Tab Option #1 (Pay Rate Source) is set to "U" (Union Rates table (F069126))
   2. Process Tab Option #2 (Assign Highest Pay Rate) is set to 1 (Use the highest pay rate found)
2. Check the Employee Basic Compensation (P0801CMP) which is 22.00 per hour
   1. Note the employee Union Code, Job Type, and Step
3. Check the Union Rates table (F069126) for the Union Code, Job Type and Step
   1. Hourly Rate for the Union Code, Job Type and Step was 17.00 per hour
4. Use Time Entry by Individual (P051121) to create a time card with four lines
   1. Day 1 10 Hours
   2. Day 2 10 Hours
   3. Day 3, 10 Hours
   4. Day 4, 15 Hours, Hourly Rate = $22.00 (From Employee Master)
   5. Save time card with 45 hours (40 regular + 5 overtime)
5. Run Overtime Generator (P186401) for Overtime Rule OT > 40.
   1. Verify Overtime is set to 150% of Regular Wages and the Rate is applied at greater than 40 hours.
   2. Take the Form Exit to Submit Overtime Generator
   3. Confirmation Box appears to confirm you want to Submit Overtime Rule Set Processing (R186405)- Click OK
6. Three Jobs were processed in the following order
   1. Overtime Rule Set Processing (R186405) 
   2. Overtime Rule Set Batch Review (R186404) 
   3. Review Time Entry Lock Status (R186410)
7. Overtime Rule Set Processing (R186405) PDF had no errors
8. The Overtime Rule Set Batch Review (R186404) Report shows the correct overtime rate but the wrong rate for regular hours as follows;
   1. 10 Hours at 17.00 = 170.00 - this is the lower Union Rate. It should be 22.00.
   2. 5 Hours at 33.00 = 165.00 - this is correct 22.00 x 1.5 = 33.00.
9. Check Time Entry by Individual (P051121)
   1. Hourly Rate on Overtime Day Regular Hours was changed from 22.00 to 17.00 which is incorrect.

Cause

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