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!

PAY: Need to Calculate OT Hours using FastFormula

edited Apr 30, 2013 2:21AM in Payroll and OTL - EBS (MOSC) 4 commentsAnswered
Hi,

Our system has a custom fastformula that computes for a certain premium amount. The computation is - rate * hours worked * 10%. If for example, the pay period is Jan 1-7, and an employee should earn the premium on Jan 2, the fastformula is called and computes for the premium amount. The computation becomes incorrect, though, when the employee has OT hours on that day since the fastformula does not include the OT hours. My question is, is there a way to include the OT hours? We have OTL in our system by the way.

One solution I tried is I created a formula function that will compute for the OT hours. The problem is, there is no context value that returns all the days of the pay period, date_earned context value only returns the 'date_earned' which is set up to be the last day of the pay period. I need context value/database item that gives all the days of the pay period one at a time.

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