Time entry rule fast formula — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood: Oracle Cloud SCM and Purchasing

Time entry rule fast formula

edited Jul 14, 2020 2:17PM in Workforce Management 2 comments

Content

Hello,

I am trying to create some time entry rules that limit the number of overtime hours entered. The requirement is to cap the number of overtime hours at 128 hours with a reference period of 4 months. In 4 months you cannot log more than 128 hours.

I have used a seeded Oracle formula (attached) and created new time category that include only overtime. I have set a limit number of hours and it worked. If overtime time types were more than that limit the system threw the error. But I don't know how to reference this to a 4 month period. I have only per day or per time card option. Do you know what and how can I modify the formula to apply this maximum limit of hours for a 4 month period reference and throw an error only if in the last 4 months

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!