Oracle Time and Labor Fundamentals – User Guide

Oracle Time and Labor Fundamentals

Setup User Guide

Table of Contents

Practice 1: Defining Time Entry Rules and Rule Groups 7

Business Scenario 7

Solution 7

Defining Recurring Periods 7

Defining Time Entry Rules – Using Period Maximum Formulas 8

Defining Time Entry Rules – Using Mapping for Approval Style 11

Defining Time Entry Rule Groups 12

Practice 2: Defining Approval Periods 15

Defining Recurring Time Periods 15

Business Scenario 15

Define Approval Periods 15

Practice 3: Defining a Approval Style 18

Approval Styles 18

Business Scenario 18

Defining an Approval Style for Warehouse Employees 18

Defining an Approval Style for Retail Employees 20

Defining an Approval Style for Corporate Employees 22

Practice 4: Using Elements 23

Business Scenario 23

Creating Overtime Pay Earnings 23

Modifying the Element 25

Linking Element 28

Creating Double Time Pay Earnings 31

Modifying Double Time Pay Earning 34

Linking Element 36

Entering Element Time Information 38

Practice 5: Creating Element Sets 42

Business Scenario 42

Creating an Element Set for Retail Employees 42

Creating an Element Set for Corporate Employees 45

Running Generate Flexfield and Mapping Information 46

Verifying Results 49

For Demonstration – Reviewing Mapping and Mapping Components 52

Reviewing Mapping and Mapping Components 52

Viewing Retrieval Processes 55

Viewing Retrieval Rules 56

Practice 6: Defining Alternate Names 58

Business Scenario 58

Defining Alternate Names for Warehouse Employees 58

Defining Alternate Names for Retail Employees 63

Defining Alternate Names for Corporate Employees 66

Practice 7: Defining Employees 68

Business Scenario 68

Create 16Corporate Employee 68

Create 16Retail Employee 73

Create 16Warehouse Employee 75

Practice 7: User Preferences 78

Business Scenario 78

Corporate Employees will need the following 10 preferences: 78

Retail Employees will need the following 9 preferences: 79

Warehouse Employees will need the following 17 preferences: 80

Solution 81

Adding Preferences to a branch 83

Preferences for Warehouse Employees 90

Preferences for Retail Employees 99

Defining Eligibility Criteria – For Warehouse, Retail, Corporate 103

Viewing People Preferences 105

Practice 8: Defining Holiday Calendars 108

Business Scenario 108

Solution 108

Defining a Holiday Calendar for Corporate Employees 108

Defining a Holiday Calendar for Retail Employees 112

Practice 9: Defining Shifts / Work Plans / Rotation Plans 113

Business Scenario 113

Solution 113

Defining Shifts 113

Defining a Work Plan for Retail Employees 115

Defining a Work Plan for Corporate Employees 118

Defining a Rotation Plan for Retail Employees 119

Defining a Rotation Plan for Corporate Employees 122

Practice 10: Defining Earnings Group 123

Business Scenario 123

Practice 11: Defining an Hour Deduction Policy 125

Business Scenario 125

Practice 12: Defining Shift Differential, Premium Eligibility and Premium Interaction Policies 127

Business Scenario 127

Solution 128

Defining Shift Differentials 128

Defining Premium Eligibility Policies 130

Defining Premium Interaction Policies 133

Practice 13: Defining Earning Policies 136

Business Scenario 136

Solution 136

Defining an Earning Policy for Retail Employees 136

Defining an Earning Policy for Corporate Employees 139

Practice 14: Assigning Structures and Policies to an Employee 141

Business Scenario 141

Solution 141

Viewing Employee Assignment Information Folder 144

Practice 15: Automatic Timecard Generation 146

Business Scenario 146

Solution 146

Viewing Auto generated Timecards 148

Validate for BEE 149

Verify the Results 150

Transfer to BEE 153

Transferring Timecards to Element Entries 155

Review Transferred timecards in Element Entries 158

Practice 16: Entering Timecard using Self Service 161

Business Scenario 161

Solution 161

Create Application User for the Corporate Employee 161

Entering time and labor for warehouse employees using the projects/payroll timecard layout 164

Entering time and labor for Retail employees using the work schedule timecard layout 170

Entering time and labor for corporate employees using the exception timecard layout 173

Workflow Background Process 174

Approvals for 16RETAIL and 16WAREHOUSE 176

Transferring Time from OTL to BEE 178

Viewing Batch Status 181

Running the Transaction Import from OTL to Oracle Projects 185

Review the results in Oracle Projects 187

Running the Retrieval Error Handing Report 188

Practice 17: Transfer time for Corporate Employee 191

Business Scenario 191

Solution 191

Transferring Time from OTL to BEE 191

Validating Timecards for BEE 195

Transferring Timecards to BEE 197

Viewing Batch Status 198

Practice 18: Using Oracle Time & Labor Reports 206

Business Scenario 206

Solution 206

Review Report Output 207

Reviewing Employee Time Folder 207

Practice 19: Defining Reason Codes for CLA 208

Business Scenario 208

Tasks 208

Solution 208

Defining Change Audit Reason Codes 208

Defining Late Audit Reason Codes 209

Practice 20: Defining Time Categories for Change and Late Audit 211

Business Scenario 211

Tasks 211

Solution 211

Defining Time Categories for Change and Late Audit 211

Practice 21: Defining Time Entry Rules for Change and Late Audit 213

Business Scenario 213

Tasks 213

Solution 213

Defining Time Entry Rules for Change and Late Audit 213

Defining Time Entry Rule Groups 215

Practice 22: Defining Preferences for Change and Late Audit 217

Business Scenario 217

Tasks 217

Defining Eligibility Criteria 218

Viewing People Preferences 218

Solution 218

Adding Preferences to a branch 219

Create 16CLA Employee 224

Defining Eligibility Criteria for an employee 229

Viewing People Preferences 230

Create Application User for the Corporate Employee 231

Practice 23: Entering a Timecard for Change and Late Audit 233

Business Scenario 233

Tasks 233

Solution 233

Enter a Late Audit Timecard 233

Practice 1: Defining Time Entry Rules and Rule Groups

This demonstration explain how to define time entry rules and time entry rule groups. Time entry rules use formulas to generate warnings or errors at the time of submission, resubmission or both.

Business Scenario

Define a time entry rule using a formula to validate that timecard entries do not exceed 40 hours per week averaged over two-week period for all warehouse employees.

Note: Make sure the validation is at both time of submission and resubmission

Define a time entry rule to ensure that timecards for all employees are sent for approval whenever they enter or change any of the data that is retrieved by Oracle Projects.

Using the formula time entry rule created, define a Time Entry Rule Group. Select Error as the outcome to notify the worker when the time entry rule is broken.

Solution

Defining Recurring Periods

Responsibility : US OTL Application Developer

Navigation : (N) Recurring Periods

Name 16Weekly – Starts Monday
Period Type Week
Start Date 31-Dec-2001

Note: 31-DEC-2001 is a Monday

Defining Time Entry Rules – Using Period Maximum Formulas

Responsibility : US OTL Application Developer

Navigation : (N) Time Entry Rules 🡪 Define Time Entry Rules

Date Track : 01-Jan-2000

Name 16Warehouse Rule
Description 16 40 Hours per week over a 2-week period
Usage Submission / Resubmission / Delete
Formula Seeded formula for Period Maximum
Period 16Wekly – Start Monday
Maximum Hours 40
Reference Period 2

Defining Time Entry Rules – Using Mapping for Approval Style

Responsibility : US OTL Application Developer

Navigation : Time Entry Rules 🡪 Define Time Entry Rules

Name 16Warehouse Rule
Description 16 Projects Retrieval Process Mapping
Usage Submission / Resubmission / Delete

Note: This determines approval is required at the initial submission and when the employee change the time and labor data after approval

Blank (not required)
Mapping Projects Retrieval Process Mapping

Defining Time Entry Rule Groups

Responsibility : US OTL Application Developer

Navigation : Time Entry Rules 🡪 Define Time Entry Rule Groups

Date Track to 01-Jan-2000

Name 16Warehouse Group
Name (Time Entry Rule Section) 16Warehouse Rule
Outcome Error

Note: This will produce an error on the timecard and stop the submission process until the error is corrected.

Save and Close Form

Practice 2: Defining Approval Periods

Defining Recurring Time Periods

Recurring time periods determine the frequency of timecard entry and approval. Once a recurring time period has been define, you can associate the period with an application to define periods in the Approval Periods window

Business Scenario

Define a recurring time period for warehouse, retail and corporate employees. This recurring period will be “16Weekly – Start Monday

The approval period for both “Oracle Projects (warehouse employees) and Oracle Payroll (retail employees) can also be set to “16Weekly – Start Monday

Define Approval Periods

Responsibility : US OTL Application Developer

Navigation : (N) Approval 🡪 Define Approval Periods

Name : 16Weekly Period – Start Monday

Application Recurring Periods
Projects 16Weekly – Starts Monday
Payroll 16Weekly – Starts Monday

Note: We already define Recurring Periods “16Weekly – Starts Monday”

Practice 3: Defining a Approval Style

Approval Styles

Approval Styles are used to alert the approver when timecards are waiting to be approved. The approval style define who approves the timecards for each recipient application. The approval style also define which data needs to be approved for each application, and which data changes require resubmission

Business Scenario

Warehouse employees will need an approval style to alert the warehouse supervisor when timecards are waiting to be approved as well as notification of when project, task and or type information has been changes

Retail employees will need an approval style to alert the store manager that timecards are waiting to be approved.

Corporate employees are not required to have timecards approved. To accomplish this, will create an approval style for “Auto Approve” for all corporate employees

Defining an Approval Style for Warehouse Employees

Responsibility : US OTL Application Developer

Navigation : (N) Approval 🡪 Define Approval Styles

Date Track : 01-Jan-2000

Defining an Approval Style for Retail Employees

Name : 16Retail Approval

Description : Approval Rule for Retail Employees

Rule Application
Payroll Data Approval Rule Payroll

Defining an Approval Style for Corporate Employees

Name : 16Corporate Approval

Description : Approval Style for Corporate Employees

Rule Application
Payroll Data Approval Rule Payroll
Application Type Sequence
Payroll Auto Approve 10

Practice 4: Using Elements

Using Elements for time and labor entry and create element sets for payroll retrieval. Elements are essential compensation and benefit components that represent earning types.

Business Scenario

Retail employees require overtime and double time earnings

Creating Overtime Pay Earnings

Responsibility : US Super HRMS Manager

Navigation : (N) Total Compensation 🡪 Basic 🡪 Earnings

Set effective date to 01-Jan-2000

Name : Overtime Pay16.

Reporting Name : OT16

Description : 16 Overtime Pay

Classification : Earnings

Category : Overtime

Modifying the Element

Navigate to Element (N) Total Compensation 🡪 Basic 🡪 Element Description

Set Date to: 01-Jan-2000

Query earning element “Overtime Pay16”

Ensure the “Multiple Entries Allowed” and “Process in Run” checkboxes are enabled/checked

Select “Input Values”

Verify that there are Input Values called Hours, Pay Value, Multiple, Rate and Rate Code. In US, you also require Jurisdiction, ‘Deduction Processing’, and ‘Separate Check’.

Uncheck the Required checkbox for both ‘Deduction Processing’ and ‘Separate Check’ input values if required.

Linking Element

Navigate to the Element Link using “US Super HRMS Manager”

(N) Total Compensation 🡪 Basic 🡪 Link

Set effective date to 01-Jan-2000

Select “overtime Pay16”

Note: check the “Link to All Payrolls” checkbox

Creating Double Time Pay Earnings

Navigate to the Earning window using the US Super HRMS Manager responsibility

Responsibility : US Super HRMS Manager

Navigation : (N) Total Compensation 🡪 Basic 🡪 Earnings

Name Double Time Pay16
Reporting Name DT16
Description 16 Doubletime Pay
Classification Earnings
Category Overtime
Processing Nonrecurring
Calculate Rule Hours * Rate * Factor

Modifying Double Time Pay Earning

Navigation : (N) Total Compensation 🡪 Basic 🡪 Element Description

Effective date : 01-Jan-2000

Query “Double Time Pay16”,

Ensure “Multiple Entries Allowed” and “Process in Run” checkboxes are checked

Select the Input Values

Verify that there are Input Values called Hours, Pay Value, Multiple, Rate and Rate Code. For US legislation, you also require Jurisdiction, ‘Deduction Processing’, and ‘Separate Check’ for Payroll processing

Uncheck the Required checkbox for both ‘Deduction Processing’ and ‘Separate Check’ input values if required

Linking Element

Navigate to the Element Link using “US Super HRMS Manager”

(N) Total Compensation 🡪 Basic 🡪 Link

Select “Link to All Payrolls”

Entering Element Time Information

Responsibility : OTL Application Developer

Navigation : (N) OTL Time Accounting 🡪 Element Time Information

Effective Date : 01-Jan-2000

Element Name Overtime Pay16
Earning Category Overtime Earning
Premium Type Factor/Multiple
Premium Amount 1.5
Processing Order 15

Practice 5: Creating Element Sets

If you have Oracle HR or Payroll retrieval rules, you define Element Sets to specify the elements to be fed to Oracle Time & Labor. You can select individually all the elements you require.

Business Scenario

1st Create an Element Set for Retails Employees and include Overtime Pay and Double Time Pay earning elements.

2nd Element Set for Corporate Employees requires Vacation, Sick Time and Jury Duty earnings.

Creating an Element Set for Retail Employees

Navigate to the Element and Distribution Set window using the US Super HRMS Manager responsibility

Navigation : (N) Payroll 🡪 Element Set

Date Track : 01-Jan-2000

Name : Retail Element Set 16

Type : Run Set

Choose Include Element button to display elements available for selection

Select OTL Regular Pay, Overtime Pay16, Double Time Pay16, OTL Shift Pay

Save and create new element set

Creating an Element Set for Corporate Employees

Name : Corporate Element Set16

Type : Run Set

Elements : OTL Regular Pay, OTL Vacation Pay, OTL Sick Pay, OTL Jury Duty

Running Generate Flexfield and Mapping Information

Navigate to Submit Request using US OTL Application Developer responsibility

Responsibility : US OTL Application Developer

Navigation : (N) Process and Reports 🡪 Submit Requests

Select Single Request

Program Name : Generate Flexfield and Mapping Information

Verifying Results

Navigate to the Descriptive Flexfield Segment window using the System Administrator responsibility

(N) Application 🡪 Flexfield 🡪 Descriptive 🡪 Segments

Query 🡪 Title 🡪 OTL Information Types (CTRL + F11)

Title 🡪 OTL Information Types

Note: Input Values (Segments) have not been Enabled.

Important: To Define the Alternate Name will enable these segments

For Demonstration – Reviewing Mapping and Mapping Components

Each deposit and retrieval process refers to a mapping. The mapping defines the set of timecard fields that the process deposits or retrieves, and where these are held in the time store. The fields are defined as mapping components. There are predefined mapping for the predefined processes

Note: We do not need to define new fields to be captured by Oracle Time & Labor. Therefore, we will not need to define new contexts and segments for the OTL Information Types descriptive flexfield

Reviewing Mapping and Mapping Components

Responsibility : US OTL Application Developer

Navigation : (N) Deposit / Retrieval Processes 🡪 Define Mapping Components

Perform an open query on the window (CTRL + F11) to show all mapping components defined.

Review Define Mappings

(N) Deposit / Retrieval Processes 🡪 Define Mappings

Run Open Query (CTRL + F11) to show all the predefined Mappings:

  1. BEE Retrieval Process
  2. OTL Deposit Process
  3. Projects Retrieval Process

Viewing Retrieval Processes

A retrieval process defines the data that a recipient application can retrieve from the time store. There are predefined retrieval processes for Oracle Human Resources, Oracle Projects and Oracle Payroll.

Responsibility : US OTL Application Developer

Navigation : (N) Deposit / Retrieval Processes 🡪 Define Process

Perform an open query on the window and scroll through all the deposit and retrieval process

Viewing Retrieval Rules

Review the retrieval rule – Projects and Payroll – Approved. This rule indicates that Oracle Projects and Oracle Payroll both require data to be approved before it can be retrieved.

For retail and corporate employees, you can review the retrieval rule – Payroll. This rule indicates that Oracle Payroll requires data to be approved before it can be retrieved.

Responsibility : US OTL Application Developer

Navigation : (N) Deposit / Retrieval Processes 🡪 Define Retrieval Rules

Perform an open query (CTRL+F11) to view all the Retrieval Rules

Practice 6: Defining Alternate Names

Using Alternate Names, configure lists of values on timecards. You may wish to change the name of an element, limit the display of values in a list, or derive the value of a filed from the value in another field.

Business Scenario

Warehouse employees will need to use alternate names to derive the expenditure type from the entry of project.

Retail employees do not need to see vacation, sick or jury duty in their list of values because they do not get paid for these hour types. However, they will need to have overtime pay and double time pay elements in their list of values.

Corporate employees should see elements with the name regular pay, sick pay, jury duty and vacation

Defining Alternate Names for Warehouse Employees

Responsibility : US OTL Application Developer

Navigation : (N) Alternate Names 🡪 Alternate Name Definition

Date Track : 01-Jan-2000

Alternate Definition 16Warehouse Employees
Description 16Warehouse Employees
Alternate Name Type OTL Alternate Name DFF Context
Type Name Elements Expenditure System Linkage Function
Prompt 16Hours Type

Select “Alternate Name” section

Alternate Name Regular Pay
Value OTL Alternate Names popup
Payroll Element OTL Regular Pay
Expenditure Type Administrative
System Linkage Function ST

Defining Alternate Names for Retail Employees

Responsibility : US OTL Application Developer

Navigation : (N) Alternate Names 🡪 Alternate Name Definition

Date Track : 01-Jan-2000

Alternate Definition 16Retail Employees
Description 16Retail Employees
Alternate Name Type OTL Alternate Name DFF Context
Type Name Payroll Elements
Prompt 16Hours Type

Select “Alternate Name” section

Alternate Name Regular Pay
Value OTL Alternate Names popup
Payroll Element OTL Regular Pay

Add new record to continue enter the following information

Alternate Name Payroll Element Enabled
Overtime Pay Overtime Pay16 Checked
Double Time Pay Double Time Pay16 Checked
Shift Diff Pay OTL Shift Pay Checked

Defining Alternate Names for Corporate Employees

Responsibility : US OTL Application Developer

Navigation : (N) Alternate Names 🡪 Alternate Name Definition

Date Track : 01-Jan-2000

Alternate Definition 16Corporate Employees
Description 16Corporate Employees
Alternate Name Type OTL Alternate Name DFF Context
Type Name Payroll Elements
Prompt 16Hours Type

Add new record to continue enter the following information

Alternate Name Payroll Element Enabled
Regular Pay OTL Regular Pay Checked
Sick Pay OTL Sick Pay Checked
Jury Duty OTL Jury Duty Checked
Vacation Pay OTL Vacation Pay Checked

Practice 7: Defining Employees

Business Scenario

Business requirement is to define 3 employees, one as s Warehouse Employee, one as a Retail Employee and one as a Corporate Employee.

Note: Choose to make one of these employees as supervisor

Create 16Corporate Employee

Responsibility : US Super HRMS Manager

Navigation : (N) People 🡪 Enter and Maintain

Effective Date : 01-Jan-2000

Select Address

Select Assignment

Select Supervisor Tab

Select Statutory Information

Create 16Retail Employee

(N) People 🡪 Enter and Maintain

Select Supervisor

Create 16Warehouse Employee

(N) People 🡪 Enter and Maintain

Select Address

Select Assignment

Practice 7: User Preferences

Create new preferences hierarchies, linking them to people using eligibility criteria and viewing people’s preferences.

Business Scenario

Define various rules for each group of employees within the corporation. You must assign the rules to the groups of employees via Preferences. Oracle Time & Labor includes default preferences with predefined values. However created various rules for 3 groups of employees. Create a new hierarchy containing the preferences for which specify a different value.

Corporate Employees will need the following 10 preferences:

Name in Tree Preference Preference Values
16C-Application Set Time Store Application Set Application Set = Payroll
16C-Approval Periods Time Store Approval Periods Time Store Approval Periods = 16Weekly Period – Starts Monday
16C-Approval Time Store Approval Style Approval Style = 16Corporate
16C-OTL Rules Evaluation Self Service Preference to Allow Rule Evaluation Evaluate OTL Rules = Yes

Approval Rules for Rules Evaluation = Payroll

Overtime Recurring Period = 16Weekly Period – Start Monday

16C-Retrieval Rule Time Store Retrieval Rule Groups Group Name = Payroll Retrieval Rule Group
16C-Timecard Alternate Name Self Service Timecard Alternate Name Set Defined for a User Timecard Alternate Name 1 = 16Corporate Employees
16C-Timecard Layout Self Service Timecard, Review and Confirmation Layout Pages Timecard Layout = Exception Layout – Timecard Entry Page

Review Layout = Exception OTLR Details Review Layout

Confirmation Layout = Exception Layout – Timecard Confirmation Page

Notification Layout = Exception OTLR Details Notification Layout

16C-Timecard Periods Self Service Timecard Period for Worker Timecard Period = 16Weekly Period – Starts Monday
16C-Timekeeper Layout Timekeeper Layout Attributes Timekeeper Layout Item 1 = 16Corporate Employees
16C-Timekeeper Misc Timekeeper Misc Setup Items Display In/Out Time Entries = Yes

Display Person Name = Yes

Display Person Number = Yes

Retail Employees will need the following 9 preferences:

Name in Tree Preference Preference Values
16R-Application Set Time Store Application Set Application Set = Payroll
16R-Approval Periods Time Store Approval Periods Time Store Approval Period = 16Weekly Period – Starts Monday
16R-Approval Style Time Store Approval Style Approval Style = 16Retail Approval
16R-OTL Rules Evaluation Self Service Preference to Allow Rules Evaluation Evaluate OTL Rules = Yes

Approval Rules for Rules Evaluation = Payroll

Overtime Recurring Period = 16Weekly Period – Starts Monday

16R-Retrieval Rule Time Store Retrieval Rule Groups Group Name = Payroll Retrieval Rule Group
16R-Timecard Alternate Name Self Service Timecard Alternate Name Set Define for a User Timecard Alternate Name 1 = 16Retail Employees
16R-Timecard Layout Self Service Timecard, Review and Confirmation Layout Pages Timecard Layout = Payroll Timecard Layout

Review Layout = Payroll OTLR Details Review Layout

Confirmation Layout = Payroll Confirmation Layout

Notification Layout = Payroll OTLR Details Notification Layout

16R-Timecard Periods Self Service Timecard Period for Worker Timecard Period = 16Weekly – Starts Monday
16R-UOM Self Service Unit of Measure to be Used on a Timecard Timecard Unit of Measure = Hours

Unit of Measure Format = HH:mm

Note: HH:mm – display military time 13:45

Hh:mm aa – display non-military time 1:45 pm

Warehouse Employees will need the following 17 preferences:

Name in Tree Preference Preference Values
16W-Append Template Self Service Functionality to Append Templates on the Timecard Allow Append Functionality = Yes
16W-Application Set Time Store Application Set Application Set = Payroll and Projects
16W-Approval Periods Time Store Approval Periods Time Store Approval Periods = 16Weekly Period – Starts Monday
16W-Approval Style Time Store Approval Style Approval Style = 16Warehouse Approval
16W-Create Personal Template Self Service Create Template Functionality Create Template = Yes
16W-Disconnect Mode Self Service Disconnected Entry Option for Worker Disconnected Entry = Upload / Download
16W-Edit Status Allowed Self Service Timecard Status that Allows User Edit Status Allowing Edits = NEW WORKING REJECTED
16W-Empty Rows Self Service Number of Empty Rows on the Timecard Number of Empty Rows = 3
16W-Negative Hours Self Service Ability to Enter Negative Hours Allowed Negative Entries = Yes
16W-OTL Rules Evaluation Self Service Preference to Allow Rules Evaluation Evaluate OTL Rule = No

Approval Rules for Rules Evaluation = Projects and Payroll

Overtime Recurring Period = 16Weekly Period – Starts Monday

16W-Retrieval Rule Time Store Retrieval Rule Groups Group Name = Projects and Payroll Retrieval Rule Group
16W-Save Template Functionality Self Service Save as Template Functionality on Timecard Save as Template on Timecard = Yes
16W-Template Functionality Self Service Template Functionality for a Worker Template Functionality for a Worker = Yes
16W-Time Entry Rule Time Store Time Entry Rules Time Entry Rule = 16Warehouse Group
16W-Timecard Alternate Name Self Service Timecard Alternate Name Set Defined for a User Timecard Alternate Name 1 = 16Warehouse Employees
16W-Timecard Layout Self Service Timecard, Review and Confirmation Layout Pages Timecard Layout = Projects and Payroll Timecard Layout

Review Layout = Projects and Payroll Review Layout

Confirmation Layout = Projects and Payroll Confirmation Layout

Detail Layout = Projects and Payroll Details Layout

Export Layout = Projects and Payroll Export Layout

Notification Layout = Projects and Payroll Notification Layout

16W-Timecard Periods Self Service Timecard Period for Worker Timecard Period = 16Weekly – Starts Monday

Solution

Responsibility : US OTL Application Developer

Navigation : (N) Preferences

Note: Click on the + sign to open the Preference Tree note.

Highlight (or select) the Preference Tree node, then right mouse click on the Preference Tree node and select New

Enter 16Warehouse Employees in the name in Tree field and save

Collapse the Preference Tree node and select +sign to re-open the Preference Tree node, view new branch, 16Warehouse Employees

Adding Preferences to a branch

  • Select + sign to open the 16Warehouse Employee node
  • Highlight or select the 16Warehouse Employees node, Make sure 16Warehouse Employees is defaulted in the “Name in Tree” field.
  • Right click on 16Warehouse Employees node and select New.
  • In the Name in Tree field, enter 16W-Append Template for the preference. At this time, the Preference filed is not data-enterable
  • Save and verify the results as follows:
  • Preference Tree
    • 16Warehouse Employees
      • +16W-Append Template

Allow Append Functionality = Yes

Note: Check “Editable by user” if you wish to allow employees to edit the preferences

To create the next preference for the 16Warehouse Employees branch, highlight (or select) the 16Warehouse Employees node. Make sure 16Warehouse Employee is default in the “Name in Tree” field. Right click and select New.

In the Name in Tree field, enter 16W-Applicatoin Set for the preference. At this time, the Preference field is not data-enterable.

Save and verify results

Preferences for Warehouse Employees

Note: Setup all preferences for Warehouse employees

Preferences for Retail Employees

Defining Eligibility Criteria – For Warehouse, Retail, Corporate

  1. Choose the Eligibility Criteria TAB.
  2. Enter the following Information:
Name of Rule Name of Branch Link By Linked To Precedence Start Date
16Warehouse Eligibility 16Warehouse Employees Person 16Warehouse employee name 01-Jan-2000
16Retail Eligibility 16Retail Employees Person 16Retail employee name 01-Jan-2000
16Corporate Eligibility 16Corporate Employees Person 16Corporate employee name 01-Jan-2000

The Precedence field determines which hierarchy the application uses when a person is eligible for more than one set of Preferences

Note: Link by has multiple options

Viewing People Preferences

  1. Select People Tab
  2. Expand the Employees Tree by clicking on the + icon
  3. Use the Find icon to select your employees to view

Practice 8: Defining Holiday Calendars

Holiday Calendars as a reference tool to determine paid and unpaid holidays, as well as the automatically generate a detail time entry line item with the correct number of hours. Holiday Calendars also validate that the hours taken for a specific holiday are correct.

Business Scenario

Corporate employees are paid for Public Holidays. To accomplish this, create a holiday calendar and define the public holidays observed. The observed holidays for demo are:

Corporate Employee Holiday Calendar
Holiday Name Holiday Date Number of Hours
New Year’s Day 2002 01-Jan-2002 8.5
Good Friday 2002 29-Mar-2002 8.5
Memorial Day 2002 27-May-2002 8.5
Independence Day 2002 04-Jul-2002 8.5
Thanksgiving Day 2002 28-Nov-2002 8.5
Thanksgiving Friday 2002 29-Nov-2002 8.5
Christmas Day 2002 25-Dec-2002 8.5
New Year’s Day 2003 01-Jan-2003 8.5
Good Friday 2003 28-Mar-2003 8.5
Memorial Day 2003 26-May-2003 8.5
Independence Day 2003 04-Jul-2004 8.5
Thanksgiving Day 2003 27-Nov-2003 8.5
Thanksgiving Friday 2003 28-Nov-2003 8.5
Christmas Day 2003 25-Dec-2003 8.5

Solution

Defining a Holiday Calendar for Corporate Employees

Responsibility : US OTL Application Developer

Navigation : (N) OTL Time Accounting 🡪 Table Setup and Maintenance 🡪 Holiday Calendar

Date Track : 01-Jan-2000

Note: Organization is optional. Calendars can be associated with organizations. If this field is left blank, the entire business group can use the calendar.

Defining a Holiday Calendar for Retail Employees

Retail employees do not receive holiday pay for public holidays. However, you will need to create a holiday calendar with zero hours for all retail employees. Create the holiday calendar for retail employees as follows:

Responsibility : US OTL Application Developer

Navigation : (N) OTL Time Accounting 🡪 Table Setup and Maintenance 🡪 Holiday Calendar

Date Track : 01-Jan-2000

Retail Employee Holiday Calendar
Holiday Name Holiday Date Number of Hours
New Year’s Day 2002 01-Jan-2002 0
Good Friday 2002 29-Mar-2002 0
Memorial Day 2002 27-May-2002 0
Independence Day 2002 04-Jul-2002 0
Thanksgiving Day 2002 28-Nov-2002 0
Thanksgiving Friday 2002 29-Nov-2002 0
Christmas Day 2002 25-Dec-2002 0
New Year’s Day 2003 01-Jan-2003 0
Good Friday 2003 28-Mar-2003 0
Memorial Day 2003 26-May-2003 0
Independence Day 2003 04-Jul-2004 0
Thanksgiving Day 2003 27-Nov-2003 0
Thanksgiving Friday 2003 28-Nov-2003 0
Christmas Day 2003 25-Dec-2003 0

Practice 9: Defining Shifts / Work Plans / Rotation Plans

Setup Shifts, Work Plans, and Rotation Plans for time and labor entry. Shifts define periodic work schedule based upon schedule start and stop times or a specific number of hours. We can define shifts before define work plans and rotation plans

Work plans are used in the auto-generation of hours for employees and for the calculation of Day Premium and Shift Differential Premium overrides. Once your shifts have been defined, you can use them to define a work plan for each group of employees.

Rotation plans link various Work Plans together on a rotating basis. We can schedule dates when a person moves from one work plan to another. With the shifts assigned to a work plan, we can create rotation plans.

Business Scenario

Retail employees can work one of two shifts. Corporate employees are scheduled to work from 8:00AM to 5:30PM, it will need 9.5 hour work day for all corporate employees. The shift should be defined as follows:

Shift Name Start Time Stop Time Hours
Shift 1 0900 1800
Shift 2 1200 2100
Day Schedule 9.5

For Retail employees we need to define 2 work plans. One work plan will be for Shift 1 and the second is for Shift 2. Retail employees will rotate between the shifts every 2 weeks.

The Corporate employees will have only one work plan and will not need to rotate their work schedule.

Solution

Defining Shifts

Responsibility : US OTL Application Developer

Navigation : (N) OTL Time Accounting 🡪 Table Setup and Maintenance 🡪 Shift

Date Track : 01-Jan-2000

Name Description Start Stop Hours
16Shift 1 16Morning Shift 1 0900 1800
16Shift 2 16Afternoon Shift 1200 2100
16Day Schedule 16Corporate Shift 9.5

The Early Start and Late Stop fields are optional. These fields are generally entered if you wish recognize a period prior to and after the start and stop times to allow all people working that shift to clock in and clock out with no additional time being generated

Defining a Work Plan for Retail Employees

Responsibility : US OTL Application Developer

Navigation : (N) OTL Time Accounting 🡪 Table Setup and Maintenance 🡪 Work Plan

Date Track : 01-Jan-2000

The Work Shifts region of the forms will automatically be populated within the 7 days of the wrrk with US OFF as the Shift

Replace the Values of US OFF for Monday to Friday:

Note: The Day Premium and Shift Diff Override fields are optional. The Day Premium is used if your company pays a premium to persons working on a specific day. The Shift Diff Override is used to pay premiums for working hours other than the regular assigned shift. If you enter a policy in this field, it will override the shift differential policy assigned to the person at the assignment level.

Defining a Work Plan for Corporate Employees

Responsibility : US OTL Application Developer

Navigation : (N) OTL Time Accounting 🡪 Table Setup and Maintenance 🡪 Work Plan

Date Track : 01-Jan-2000

Note: Work Shifts Name define as per “Shifts

Defining a Rotation Plan for Retail Employees

Responsibility : US OTL Application Developer

Navigation : (N) OTL Time Accounting 🡪 Table Setup and Maintenance 🡪 Rotation Plan

Date Track : 01-Jan-2000

In the Next Start Date field, enter 22-Jan-2001

  • This field determines when you wish to begin the next rotation between the work plans

Number of Rotations determines the number of rotations to calculate for the rotating work plans.

Select “Autogenerate” to calculate rotation plans based upon the 2 work plans entered, and the number of rotations.

Defining a Rotation Plan for Corporate Employees

Responsibility : US OTL Application Developer

Navigation : (N) OTL Time Accounting 🡪 Table Setup and Maintenance 🡪 Rotation Plan

Date Track : 01-Jan-2000

You can review the work plans assigned to the rotation plan by placing the cursor in the Work Plan Name field and choosing the Work Plan button. To return the focus to the Rotation Plan region, choose the Rotation Plan button.

Practice 10: Defining Earnings Group

Earning groups identify various earning types that are included in accumulation of hours used for calculating week overtime limits defined on the Earning Policy. When a defined number of hours is met for an earning group, overtime hours will be created.

Business Scenario

Create a one Earning Groups have only regular pay as the earnings.

Responsibility : US OTL Application Developer

Navigation : (N) OTL Time Accounting 🡪 Table Setup and Maintenance 🡪 Earning Group

Date Track : 01-Jan-2000

Practice 11: Defining an Hour Deduction Policy

Defining an Hour Deduction Policy for Time and Labor Entry define hour deduction policies establish how much time, if any should be automatically deducted as unpaid time from employees recorded hours. We can identify criteria of specific hours worked that must be met before the deduction is taken.

Business Scenario

Retail Employees clock in and out for meals, there is no need to create an hour deduction policy for this group of employees.

Corporate Employees get a one-hour break without clocking in and out during the day. To achieve this, we can create an Hour Deduction Policy for all Corporate Employees.

Define the hour deduction policy to deduct 1 hour for a meal after 8 hours have elapsed.

Responsibility : US OTL Application Developer

Navigation : (N) OTL Time Accounting 🡪 Policies 🡪 Hour Deduction

Date Track : 01-Jan-2000

Select “Global” so this policy may be used across all business groups

Practice 12: Defining Shift Differential, Premium Eligibility and Premium Interaction Policies

Setup Shift Differential, Premium Eligibility and Premium Interaction Policies. Shift Differential policies identify when a shift premium is calculated and what premiums are to be paid based upon shift start and stop times.

Premium Eligibility policies list all premiums associated with the base hours that specific employees or groups of employees are eligible to receive. Calculations are based upon time ranges, actual time worked and applicable pay rules.

Premium Interaction policies define sequencing rules when calculation of one type of premium is based upon results of a previously calculated premium.

Business Scenario

Retail employees may be eligible for shift differential premium when they work the second shift and all type of overtime. We can create a shift differential policy to pay this premium for this group of employees.

As we create a shift differential policy for retail employees, we need to create a premium eligibility policy to determine when these employees are eligible to receive this pay.

With the creation of the shift differential policy and premium eligibility policy for retail employees, we must also create a premium interaction policy to determine the calculation of pay between the Shift Diff Pay and all types of overtime premium.

Solution

Defining Shift Differentials

Responsibility : US OTL Application Developer

Navigation : (N) OTL Time Accounting 🡪 Policies 🡪 Shift Differential

Date Track : 01-Jan-2000

Note: If time is entered in the Carryover field, it is an indication that the assigned shift differential premium is to be paid for the carryover time when an employee continues to work.

Defining Premium Eligibility Policies

Responsibility : US OTL Application Developer

Navigation : (N) OTL Time Accounting 🡪 Policies 🡪 Premium Eligibility

Date Track : 01-Jan-2000

Defining Premium Interaction Policies

Responsibility : US OTL Application Developer

Navigation : (N) OTL Time Accounting 🡪 Policies 🡪 Premium Interaction

Date Track : 01-Jan-2000

Interactive Premium Include / Exclude
Overtime Pay16 Include
Double Time Pay16 Include

Practice 13: Defining Earning Policies

Earning Policies consolidate many previously defined structures and policies go generate the various pay rules enforced for an assignment. Earning Policies must be defined for each of the different pay policies within the organization.

Business Scenario

Retail employees are eligible to receive overtime pay and premium while corporate and warehouse employees are not. We will need to create an earning policy for the retail employees to generate the overtime pay for hours worked in excess of 8 hours a day. Also, need to create an earning policy for corporate employees to receive Holiday Pay.

Solution

Defining an Earning Policy for Retail Employees

Responsibility : US OTL Application Developer

Navigation : (N) OTL Time Accounting 🡪 Policies 🡪 Earning

Date Track : 01-Jan-2000

Minimum T/C Interval: This field represents the interval (in minutes) that time entry hours will be rounded up or down.

Round Up At: This field represents the minute at which the time would be rounded to the nearest interval entered in the previous step.

Name Type Earning Type Hours
Daily Base Daily Earning Rule OTL Regular Pay 8
Overtime over 8 Hours Daily Earning Rule Overtime Pay16 10
Double time Over 10 Hours Daily Earning Rule Double Time Pay16 999
Holiday Premium (Worked) Holiday Earning Rule OTL Holiday Premium 999

Defining an Earning Policy for Corporate Employees

Responsibility : US OTL Application Developer

Navigation : (N) OTL Time Accounting 🡪 Policies 🡪 Earning

Date Track : 01-Jan-2000

Minimum T/C Interval: This field represents the interval (in minutes) that time entry hours will be rounded up or down.

Round Up At: This field represents the minute at which the time would be rounded to the nearest interval entered in the previous step.

Name Type Earning Type Hours
Daily Base Weekly Earning Rule OTL Regular Pay 999
Holiday Premium (Worked) Holiday Earning Rule OTL Holiday Premium 999

Practice 14: Assigning Structures and Policies to an Employee

Assign structures and policies to workers and view the assignment information in the Employee Assignment Information Folder.

Business Scenario

Associate the rules to the retail and corporate employees. Both groups of employees will need to have auto generation flag set to YES.

Corporate employees will have the ability to enter timesheet using self-service timecard page and enter exceptions if needed from the Time Accounting Timecard window.

Retail employees will have their timecard automatically generated using the OTL Time & Labor Rules defined. Time Entries can be reviewed directly from the Time Accounting Timecard window and enter exceptions as necessary.

Solution

Responsibility : US OTL Application Developer

Navigation : (N) OTL Time Accounting 🡪 Assignment Time Information

Date Track : 01-Jan-2000

Assignment Number : 16Retail Employee

Autogen Hours (YN) : “Y” 🡪 If select “No” user will manually enter time and labor data.

Rotation Plan : 16Retail Rotation Plan

Earning Policy : 16Retail Earning Policy

Shift Differential Policy : 16Second Shift Differential

Select Assignment Number for Retail Employee

Note: If you select No, you will manually enter time and labor data.

Viewing Employee Assignment Information Folder

Responsibility : US Time and Labor Rules Manager

Navigation : (N) View 🡪 List 🡪 Assignment Time Detail Folder

Date Track : 01-Jan-2000

Practice 15: Automatic Timecard Generation

Business Scenario

Auto Timecard Generation for the Corporate and Retail employees at the beginning of the pay period.

Solution

Responsibility : US OTL Application Developer

Navigation : Process and Reports 🡪 Submit Requests

Select single Request 🡪 Automatic Time Card Generation

Viewing Auto generated Timecards

Responsibility : US OTL Application Developer

Navigation : (N) OTL Time Accounting 🡪 Time Accounting 🡪 Entry/Validation/Approval

Date Track : Date of Auto Generation

Note: Notice that the timecard source field will reflect “Autogen”.

Batch status should reflect “Hold” or “Error” if errors exist.

Validate for BEE

Responsibility : US OTL Application Developer

Navigation : (N) Processes and Reports 🡪 Submit Requests

Select 🡪 Validate for BEE

Verify the Results

Responsibility : US OTL Application Developer

Navigation : (N) OTL Time Accounting 🡪 Time Accounting 🡪 Entry/Validation/Approval

Date Track : Current Date

Batch Status: Validated with Warnings

Note: Notice that the Batch status should reflect “Validate With Warning” due to missing Timecard Approver in the Timecard window.

Transfer to BEE

(N) Process and Reports 🡪 Submit Requests

View Results

Note: Notice that the Batch status should reflect “Transferred to BEE”.

Transferring Timecards to Element Entries

Responsibility : US Super HRMS Manager

Navigation : (N) Mass Info. eXchange:MIX 🡪 Batch Element Entry

Make sure “Create New Entry” checkbox enabled and Press “Process”

Note: The Batch Header window will repopulate indicating the Batch Status as “Transferred”

Review Transferred timecards in Element Entries

Responsibility : US Super HRMS Manager

Navigation : (N) People 🡪 Enter and Maintain

Date Track : Pay period end date

Practice 16: Entering Timecard using Self Service

Enter timecards and run the processes to transfer timecards to BEE and Projects, and run the Error Retrieval Handling Report.

Business Scenario

One timesheet entry for warehouse employee and one for retail employee, and one for corporate employee. In order to achieve this, we need to login using appropriate employee in order to receive the correct timecard layout.

Once the time and labor data has been entered and submitted, we will need to sign on as the Supervisor for the warehouse and retail employees and approve the timecards.

For warehouse employees, once the timecard has been approved, we will run the process to transfer from OTL to BEE, and then to Oracle Projects.

Retail and corporate employees will enter time in Self Service. In the next section, we will run the process to transfer time from OTL to BEE and the Transfer and Validate for BEE process.

Solution

Create Application User for the Corporate Employee

Responsibility : System Administrator

Navigation : (N) Security 🡪 User 🡪 Define

User Name : 16CORPORATE

Employees : 16Corporate

Add following Responsibilities

OTL Self Service US Super HRMS Manager
System Administrator Projects, Vision Services (USA)
Manager Self-Service Workflow User Web (New)
Mass Timecard Approval US OTL Application Developer
US OTL Administrator OTL Super Timekeeper

Responsibility : System Administrator

Navigation : (N) Security 🡪 User 🡪 Define

User Name : 16RETAIL

Employees : 16Retail

Assign Responsibility : OTL Self Service

Responsibility : System Administrator

Navigation : (N) Security 🡪 User 🡪 Define

User Name : 16WAREHOUSE

Employees : 16Warehouse

Assign Responsibility : OTL, Vision Services (USA)

Note: Only need to assign “Self Service Responsibility” to warehouse and retail employees. Both, “OTL, Vision Services (USA) and OTL Service are self-service responsibilities

There is a MO: Operating Unit with value Vision Services assigned to “OTL, Vision Services (USA)” responsibility for projects purpose.

Test application user sign-on

User : 16CORPORATE

Entering time and labor for warehouse employees using the projects/payroll timecard layout

  1. Log on to Self Service using 16WAREHOUSE application sign on and choose the OTL, Vision Services (USA) responsibility
  2. (N) Time 🡪 Time Entry
  3. On the Recent Timecards page, choose Create Timecard button

Validate Project and tasks status

Sub Task has an end-date of 31-MAR-2012 therefore not allow new transactions

Note: Review an error displayed due to the setup of the 16Warehouse Rule.

Change Friday to 0 hours and continue

All issues are now resolved

Review timecard, then choose Submit button

Entering time and labor for Retail employees using the work schedule timecard layout

  1. Log on to Self Service using 16RETAIL application sign on and choose the OTL Self Service responsibility
  2. (N) Time 🡪 Time Entry
  3. On the Recent Timecards page, choose Create Timecard button

Select “Regular Pay” as Hours Type

Enter the time for each day of the week Monday through Friday as follows:

Monday Tuesday Wednesday Thursday Friday
09:00 09:00 09:00 09:00 09:00
18:00 21:00 21:00 23:00 23:00

Review timecard before submitting. Once review time entries, choose Submit button, Confirmation page indicating the time and labor data entered and the Time Details exploded based on OTLR.

Entering time and labor for corporate employees using the exception timecard layout

  1. Log on to Self Service using 16CORPORATE application user sign on and choose the OTL Self Service responsibility
  2. (N) Time 🡪 Time Entry
  3. On the Recent Timecards page, choose Create Timecard button
  4. Enter the Regular Pay hours for each day of the week Monday through Friday as follows:
Monday Tuesday Wednesday Thursday Friday
9.5 9.5 9.5 9.5 9.5

Review timecard and Submit

Workflow Background Process

Run Background Process for OTL Workflows for Employees item Type

(N) Requests 🡪 Run

Select Workflow Background Process

Approvals for 16RETAIL and 16WAREHOUSE

1. Log on to Self Service using 16CORPORATE application sign on, and chose Workflow User Web (New) responsibility

2. (N) Notifications

3. Click on the link from the Subject field for 16Retail

4. Optionally, choose the Timecard link to review both the Entered and exploded timecard.

5. Choose the Approve button

Note: You can also use Mass Timecard Approval responsibility to approve timecards.

Transferring Time from OTL to BEE

The Transfer Time from OTL to BEE process works in 2 ways. If the Rules Evaluation Preference is set to “Yes” then the process transfers the timecard data from SS to PUI Timecard form, eg: Retail and Corporate employees. If the Rules Evaluation Preference is set to “NO”, the batches get transferred directly to BEE bypassing the PUI Timecard from eg: Warehouse Employees.

Responsibility : US Super HRMS Manager

Navigation : (N) Processes and Reports 🡪 Submit Processes and Reports

Select Single Request and choose OK

Select “Transfer Time from OTL to BEE”

Retrieval Transaction Code – Enter 10016 in the Retrieval Transaction Code field to identify all timecards that will be retrieved in this process run. You can use this code to identify this run when you submit Oracle Time Retrieval Error Handing Report.

Viewing Batch Status

Responsibility : US OTL Application Developer

Navigation : (N) OTL Time Accounting 🡪 Mass Info. eXchange:MIX🡪 Batch Element Entry

Perform Query (F11) 🡪 In Reference field enter “16BATCH1%”

Select “Element Lines”

Note: If the Batch Status is “Unprocessed”. Choose the Process button, select “Transfer” as the Process Mode, and choose the Start button.

Running the Transaction Import from OTL to Oracle Projects

Responsibility : Projects, Vision Services (USA)

Navigation : (N) Other 🡪 Requests 🡪 Run

Select : Single Request PRC: Transaction Import

Select Transaction Source “Oracle Time and Labor”

Batch Name Leave Blank

Review the results in Oracle Projects

Responsibility : Projects, Vision Services (USA)

Navigation : Expenditures 🡪 Expenditure Inquiry 🡪 Project

Running the Retrieval Error Handing Report

Responsibility : US OTL Application Developer

Navigation : (N) Process and Reports 🡪 Submit Requests

Report Name : Retrieval Error Handing

Practice 17: Transfer time for Corporate Employee

Business Scenario

Run the OTL process for retail and corporate employees, this process will transfer the time and labor data entered in self service to the professional timecard window. Also, make exception entry in the professional timecard window.

Solution

Transferring Time from OTL to BEE

The Transfer Time from OTL to BEE process works in 2 ways. If the Rules Evaluation Preference is set to “Yes” then the process transfers the timecard data from SS to PUI Timecard form, eg. Retail and Corporate employees. If the Rules Evaluation Preference is set to “NO”, the batches get transferred directly to BEE bypassing the PUI Timecard form eg. Warehouse Employees.

Sign-on as 16Corproate, navigate to the Submit Request windows using the US Super HRMS Manager responsibility

Responsibility : US Super HRMS Manager

Navigation : (N) Processes and Reports 🡪 Submit Processes and Reports

Report : Select Transfer Time from OTL to BEE

Employee Name 16Corporate, User1
Retrieval Transaction Code 20016
Batch Selection New
New Batch Reference 16BATCH2
Status in BEE Unprocessed

Repeat the same steps to transfer time from OTL to BEE for the 16Retail Employee with following parameters:

Validating Timecards for BEE

Responsibility : US OTL Application Developer

Navigation : (N) Process and Reports 🡪 Submit Requests

Program : Validate for BEE

Transferring Timecards to BEE

Responsibility : US OTL Application Developer

Navigation : (N) Process and Reports 🡪 Submit Requests

Program : Transfer to BEE

Viewing Batch Status

Navigation : (N) OTL Time Accounting 🡪 Mass Info. eXchange:MIX🡪Batch Element Entry

Perform Query : 16BATCH2%

Note: If the Batch Status is “Unprocessed”, choose the Process button, select “Transfer” as the Process Mode, choose the Start Button.

Note: Review the Batch Status, it should now display “Transferred”

Practice 18: Using Oracle Time & Labor Reports

This section will explain ability to run the Missing Timecard Report, and the Approval report, also ability to access the Employee Time folder.

Business Scenario

Run the missing timecard report for the period other than submitted time and review employee’s time using the Review Employee Time Folder

Solution

Responsibility : US OTL Application Developer

Navigation : (N) Process and Reports 🡪 Submit Requests

Report : Missing Timecard Report (Application is Oracle Time and Labor)

Review Report Output

Reviewing Employee Time Folder

Responsibility : US OTL Administrator

Navigation : (N) View 🡪 List 🡪 Review Employee Timecards

Select employee’s name in the name field

Practice 19: Defining Reason Codes for CLA

Business Scenario

Define reason codes for change and late entries using the Reason Code Lookups. Reason codes are used when making changes to timecards, or late entries. Each reason code has a definition that will be displayed on the Change and Late Audit timecard entry.

Tasks

Define a Change Reason of Manager’s Request with a code equal to MGR.

Define a Late Reason of Sick Leave with a code equal to SL.

Solution

Defining Change Audit Reason Codes

Responsibility : US Super HRMS Manager

Navigation : (N) Other Definitions 🡪 Lookup Tables

Query “HXC_CHANGE_AUDIT_REASONS

Note: Leave the Enabled check box is selected. If you do not select this check box, the code will not display in the list of values.

Defining Late Audit Reason Codes

Query “HXC_LATE_AUDIT_REASONS”

Practice 20: Defining Time Categories for Change and Late Audit

Business Scenario

Time categories can be used within time entry rules to determine what fields to audit for change and late entries. We can define time categories to audit specific line items on the timecard.

Tasks

Define time categories to audit line items on a timecard and use this time category in the creation of time entry rules for change and late audit

Using the operator of “OR” you will ensure if changes, or late entries are made you will be initiating the change and late audit rules.

Solution

Defining Time Categories for Change and Late Audit

Responsibility : US OTL Application Developer

Navigation : (N) Time Categories

Name : 16CLA Time Categories

Operator : Select “OR”

Select “PA Project Id”

Practice 21: Defining Time Entry Rules for Change and Late Audit

Business Scenario

Time entry rules use formulas to control what is defined as Late and what fields you wish to monitor when a change is made. Once we define our time entry rules, we can group rules together using Time Entry Rule Groups. Time Entry Rule Groups are assigned to a person or group of people using preferences.

Tasks

  1. Define a change rule using time category same as defined in last step. Also, create a late time entry rule also using the late time category defined previously. Both time entry rules with use Audit as the usage, to activate the change and late audit rule when the worker selects the next button from timecard page.
  2. Once define time entry rules for change and late audit, will need to group rules using Time Entry Rule Groups window and make the Outcome equal to Reason to indicate Change and Late Audit

Solution

Defining Time Entry Rules for Change and Late Audit

Responsibility : US OTL Application Developer

Navigation : (N) Time Entry Rules 🡪 Define Time Entry Rules

Name : 16Change Rule

Note: This determines when the validation will take place by selecting Audit, the validation will be performed when you select the next button from the timecard page.

Defining Time Entry Rule Groups

Responsibility : US OTL Application Developer

Navigation : (N) Time Entry Rules 🡪 Define Time Entry Rule Groups

Name : 16CLA Audit Rule Group

Name Outcome
16Change Rule Reason
16Late Rule Reason

Note: The Reason outcome enables the worker to enter a reason when the audit rule is activates

Practice 22: Defining Preferences for Change and Late Audit

Business Scenario

Preferences define many rules about how individuals or groups of workers use the application. Preferences hold rules for the time store and about Self Service timecard. While Oracle Time & Labor deliver predefined preferences you cannot change these rules. However, we can create as many new hierarchies as needed for our business requirements.

Tasks

  1. Create a new preference hierarchy for Time Entry Rule Groups, and other required preferences in order to successfully enter a timecard using Change and Late Audit rules.

Batch Name is 16CLA Preferences (10 Preferences)

Name in Tree Preference Preference Value
16CLA-Application Set Time Store Application Set Application Set = Projects
16CLA-Approval Period Time Store Approval Periods Time Store Approval Periods = 16Weekly – Starts Monday
16CLA-Approval Style Time Store Approval Style Approval Style = Projects Approver
16CLA-Audit Req Time Store Audit Requirements Audit Requirements = 16CLA Audit Rule Group
16CLA-Delete Allowed Timecard Delete Allowed Timecard Delete Allowed = No
16CLA-Retrieval Group Time Store Retrieval Rule Groups Group Name = Projects

Retrieval Rule Group

16CLA-Self Service Flow Self Service Flow Self Service Flow = Audit
16CLA-Timecard Alternate Name Self Service Timecard Alternate Name Set Defined for a User Timecard Alternate Name1 = 16Warehouse Employees
16CLA-Timecard Layout Self Service Timecard, Review and Confirmation Layout Pages Timecard Layout = Projects Timecard Layout

Review Layout = Projects Change and Late Review Layout

Confirmation Layout = Project Change and Late Confirmation Layout

Detail Layout = Projects Detail Layout

Audit Layout = Projects Change and Late Audit Entry Layout

Notification Layout = Project Change and Late Audit Notification Layout

16CLA-Timecard Period Self Service Timecard Period for Worker Timecard Period = 16Weekly – Starts Monday

Defining Eligibility Criteria

Once completed setting preference link new preferences to an employee using eligibility criteria

Viewing People Preferences

View workers preferences using the People Tab within the Preference window.

Solution

Responsibility : US OTL Application Developer

Navigation : (N) Preferences

Click on the + Sign to open the Preference Tree Node

Right-click on the Preference Tree node and select “NEW”

Adding Preferences to a branch

Select “16CLA Preferences” node, right-click and select New.

Add all Preferences as per Table

Create 16CLA Employee

Responsibility : US Super HRMS Manager

Navigation : (N) People 🡪 Enter and Maintain

Defining Eligibility Criteria for an employee

Responsibility : US OTL Application Developer

Navigation : (N) Preferences

Select “Eligibility Criteria” Tab

Viewing People Preferences

  1. Choose the People Tab
  2. Expand the Employee Tree by clicking on the + icon
  3. Select 16CLA to view.
  4. Close the form

Create Application User for the Corporate Employee

Responsibility : System Administrator

Navigation : (N) Security 🡪 User 🡪 Define

Name : 16CLA as the User Name

Practice 23: Entering a Timecard for Change and Late Audit

Business Scenario

Change and Late Audit enables to track all changes to new timecard, as well as previously saved and submitted timecards

Tasks

  1. Enter a timecard to activate late rules. Enter a reason code to Sick Leave, and enter any additional comments as require
  2. Enter timecard to activate change rules. Enter a reason code of Manager’s Request and enter any additional comments as require

Solution

Enter a Late Audit Timecard

  1. Logon to Self Service using 16CLA sign on, and choose the OTL, Vision Services (USA) responsibility
  2. Navigation (N) Time 🡪 Time Entry
  3. On the Recent Timecard page, select Create Timecard button

 

 

Facebook
Twitter
LinkedIn
Email

Newsletter

Signup our newsletter to get update information, news, insight or promotions.