Leave Accrual Processing Results Are Not As Expected For Changes to Earning Code Configuration (Doc ID 2296911.1)

Last updated on SEPTEMBER 01, 2023

Applies to:

Symptoms

If the hours for a prior pay period is entered prior to the current pay period hours and the effective date of the change to the Earnings Code to check Service Hours for the Sick Leave Plan Type on the Special Process Tab, is after the earnings end date of the prior pay period, no hours are posted to the LEAVE_ACCRUAL Unprocessed service hours. As well, if the hours for the current pay period is entered prior to hours in a prior pay period, All hours are posted.

If the effective date on the Earnings Code is 1/1/2013 all is well, however, should the code to obtain the earnings code configuration use the earnings end date or the Payroll Pay End Date? If it should be the Earnings End Date, should it not obtain the configuration for each earnings row to ensure the correct configuration is obtained for that row's earnings end date?

Replication example:
1. Pay End Date is 9/30/2014
2. Change to the Earnings Code to select Service Hours for Sick Leave Plan is 9/1/2014
3. Earnings from Prior Pay Period used earnings end date of 8/21/2014
4. Employee A earnings for Prior Pay Period was entered first and then earnings for current pay period
5. Employee B earnings for current pay period was entered first and then earnings for prior pay period

Results:
1. Employee A had no hours posted to LEAVE_ACCRUAL unprocessed service hours
2. Employee B had all hours posted to LEAVE_ACCRUAL unprocessed service hours

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.