My Oracle Support Banner

US Payroll: There is a Mismatch of TIME_PERIOD_ ID Between PER_TIME_PERIODS and PAY_PAYROLL_ACTIONS Tables. (Doc ID 3020259.1)

Last updated on MAY 02, 2024

Applies to:

Oracle HRMS (US) - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

There is a mismatch of TIME_PERIOD_ ID between PER_TIME_PERIODS and PAY_PAYROLL_ACTIONS tables. This is causing some reports to fetch incorrect data.

For example, if '7 2024 Bi-week' is entered in a report as pay period Parameter, the report fetches data for the '6 2024 Bi-Week' pay period.

You can see the mismatch in the tables like below:

1. Query PER_TIME_PERIODS table to check Time Period ID  for periods 6 2024 and 7 2024 Bi-Week period

PER_TIME_PERIODS
TIME_PERIOD_ID PERIOD_NAME START_DATE END_DATE REGULAR_PAYMENT_DATE
6553 6 2024 Bi-Week 24-FEB-24 08-MAR-24 15-MAR-24
6554 7 2024 Bi-Week 09-MAR-24 22-MAR-24 29-MAR-24

 

 

 



 

2. Query PAY_PAYROLL_ACTIONS table to find payroll actions with Time Period ID = 6554 (7 2024 Bi-Week from Query 1)

Results show Date Earned (End date) is 08-Mar-2024 which is from Time Period ID 6553 in Query 1

PAY_PAYROLL_ACTIONS
PAYROLL_ACTION_ID PAYROLL_ID EFFECTIVE_DATE DATE_EARNED TIME_PERIOD_ID
2258652 82 15-MAR-24 08-MAR-24 6554

   

  

 

 

3. Payroll Processes form shows payroll run data:

DATE               PERIOD
29-MAR-2024    7 2024 Bi-Weekly
15-MAR-2024    6 2024 Bi-Weekly <== in the database, the time_period_id is 6554 which is for period 7
01-MAR-2024    5 2024 Bi-Weekly

(Navigation from US HRMS Manager responsibility: View > Payroll Process Results)



The issue can be reproduced at will with the following steps:

In US HRMS Manager responsibility (or equivalent)

1. Run a US report with a pay period date parameter (example "State Quarterly Wage Listing")

   Navigate: Processes and Reports > Submit Processes and Reports > Single Request

2. Review report output and find the data is for a different period.



Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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