Setting Up and Configuring Working Hours

The Hours Worked report, and the Employee Hours Worked Trend Analytics Workbook, enable you to investigate the number of regular hours and overtime hours worked by employees in your enterprise.

Within Oracle Human Resources you use elements to record the number of regular and overtime hours worked. You can set up different elements to represent overtime bands and regular hours. This gives you the freedom to record and pay employees exactly how you want.

To use the Hours Worked report or workbook, you need to set up information about how you are recording regular and overtime hours. To do this you use Oracle FastFormula. You first need to create database items for the input values of the elements that record regular and overtime hours.

  1. Create Database Items

    Create a database items for the input values of the elements that record regular hours and overtime hours.

    See: Creating Database Items for Working Hours Input Values

  2. Regular Hours Formula

    You first need to create a formula to calculate the regular hours recorded for your employees.

    You must name the regular hours formula BIS_REG_HOURS. This is the formula that the Hours Worked reports look for when calculating the regular hours.

    The formula type must be QuickPaint.

    Set up your formula as follows to display regular hours on the Hours Worked reports:

    default for <element name>_<input name>_entry_value is 0.00
hours_worked = 
<element name>_<input name>_entry_value
Return hours_worked

    In the above code <element name>_<input name>_entry_value represents the database item you created for the input value of the element that records regular hours. Replace the following:

    See: Writing or Editing a Formula

  3. Overtime Band formula

    Most enterprises have more than one overtime band set up. For example, you may have an overtime band for double time, time and a half, triple time and so on.

    You need to create a formula for each overtime band you use. You must name your formulas:

    The number at the end of the formula name should change with each overtime band.

    Set up the formula type as QuickPaint.

    You can set up the elements that record overtime in different ways:

    Whichever method you use, you need to set up one formula for each overtime band. Base your formulas on the following code:

    default for <element name>_<input name>_entry_value is 0.00
hours_worked = to_number(<element name>_<input name>_entry_value)
return hours_worked

    In the above code <element name>_<input name>_entry_value represents the database items you created for the input value of each element that record overtime hours. Replace the following:

    The Hours Worked report shows up to 10 overtime bands, therefore, for this report, you can write up to 10 formulas. The Employee Hours Worked Trend Analytics Workbook displays one overtime band as default, but you can customize this workbook to display however many overtime bands you use in your enterprise.

    The Hours Worked report uses the description you enter in the Description field of the Oracle Human Resources Formula window to label each overtime bar on the chart. It only uses the first 20 characters of the description.

    See: Writing or Editing a Formula

  4. Overtime Band Formulas in the United States

    If you are using Oracle Human Resources in the United States and you use the predefined Overtime element to record information about overtime, writing the formula is simple. Oracle Human Resources provides a predefined example of the formula you need to write. The example formula is called EXAMPLE_BIS_OT_BAND1 and you can view it using the Formula window.

    The sample formula is shown below:

    /******************************************************
FORMULA NAME: EXAMPLE_BIS_OT_BAND1
FORMULA TYPE: Quickpaint
DESCRIPTION: This is an example of the syntax required for the
	 formula you need to set up for use with
	 the Hours Worked Report. The function
	 get_hours_worked calculates total hours worked from
	 the Overtime element predefined with US Payroll.
INPUTS: None
DBI Required: None
Change History
10 Sep 98 jmay Created
*******************************************************/
/* Defaults Section */
/* Inputs Section */
/* Main Body of Formula */
hours_worked = get_hours_worked(1.5)
RETURN hours_worked

    Note: This example only works if you use the predefined US Overtime element.

    For each overtime band your enterprise uses, set up a formula based on the example. You must name your formulas:

    The number at the end of the formula name should change with each overtime band.