Payroll and OTL - EBS (MOSC)

MOSC Banner

Announcements for Payroll and OTL can now be found in the Announcements - Payroll and OTL - EBS (MOSC) subcategory. Follow to be sure you don't miss a thing!

Re-sequence PERIOD_NUM column in PER_TIME_PERIODS table

edited Dec 16, 2014 4:28PM in Payroll and OTL - EBS (MOSC) 3 commentsAnswered

Hi there!

In PER_TIME_PERIODS table, is there a way to re-sequence the PERIOD_NUM column?  We are on a bi-weekly payroll and we've moved the last payment date from January 1, 2016 to December 31, 2015.  We now have 27 pay periods/payment dates instead of 26 for 2015 year.  We would like to adjust the PERIOD_NUM column for 2015 to have 27 pay periods and 2016 to have 26 pay periods.

We have until year 2016 generated in our Period Dates or PER_TIME_PERIODS table.

Thank you.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center