I have an interesting issue...
In 2013 - there should be 27 Bi-weekly pay periods. This occurs every 40 years. The per_time_periods table has the last pay in 2013 as the first pay in 2014. Therefore 2014 has 27 pays.
Any idea on how to fix this? As Oracle hasnt been around for 40 years i cant find a solution.
The pay periods are decided based on the regular_payment_date column on per_time_periods table
select * from per_time_periods -- regular_payment_date
where period_num = 27
and period_type = 'Bi-Week';
Basically if the payment date is within the current year, you would see the period in the current year.
It is normal to have 27 periods in a year. This happens every 11 years.
You can go to the payroll definition screen --> period dates , and amend the period number,name and dates if those are not correct and you want to move them to the next year(but then the next year would have 27 periods)
Hope that helps,
Thank you for the replies.
Having 27 Bi weekly pays is a normal occurence however my issue is with the last pay in 2013 and the first pay in 2014. For tax/salary/benefits etc purpose - the pay needs to appear as the 27th pay in 2013. Currently is shows as the first pay in 2014.
I will try the payroll definition screen.