Friday, November 9, 2018

How do you Stop Users from Entering More Than 24 Hours in a Day in OTL

How do you Stop Users from Entering More Than 24 Hours in a Day in OTL

Our users are able to enter more than 24 hours worked in a day. This happens both in Self Service and Timekeeper form. How can we stop this from happening?

Solution:

Create a Time Entry Rule (TER) to handle the validation following these steps:

1) Create a Time Category with all the elements to which you want this TER to be applicable

2) Create a Daily Rule (need to setup a new Recurring Period of 1 day)

     Nav: US OTL Application Developer > Recurring Periods

    Create a new Recurring Period called Daily with Duration in Days = 1 and Start Date of 01-Jan-
    2000

3) Create a Time Entry Rule which uses the seeded formula 'Seeded formula for Period Maximum'  
    with the following Formula Inputs:
    Period = Daily
    Time Category - Time Category you just set up
    Maximum Hours = 24
    Reference Period = 1

4) Create a Time Entry Rule Group with the TER you just created in it
5) Assign the Time Entry Rule Group to the employee(s) via the Time Entry Rule Group preference

Reference Metalink Note - 276678.1

No comments:

Post a Comment

SQL Important Queries

  How to delete rows with no where clause The following example deletes  all rows  from the  Person.Person  the table in the AdventureWork...