OTL Technical Training
Pune
What we cover ?
OTL Basic functional part
OTL Technical overview
OTL Timecard Table structure and validations
Functional Overview(Setup Related)
OTL Basics
Oracle Time & Labour is an ebusiness suite solution to meet the requirements of:
Time Capture
Time Validation
Time Approval
Oracle Time and Labour
Time Management
OTL Basics
OTL, it is the single point of Time Entry solution available in the Oracle E-
Business Suite.
OTL allows you to capture, validate, approve and store the time information. OTL currently has out of box integration with Oracle Human Resources (HR), Oracle Internet Expenses, Oracle Project Resource Management, Oracle Payroll, Oracle Projects, Oracle Enterprise Asset Management and Oracle Procurement. It provides a set of public API's which can be used for developing custom integration with other products.
OTL Time Structure
Holiday Calendar
Shifts Weekly Roster Shift pattern (Rotation Plan)
Holiday Calendar
This records the paid and unpaid holidays for an employee group. This is attached to an employee group using an Earning Policy. Navigation: OTL Application Developer OTL Time Accounting Table Setup and
Maintenance Holiday Calendar
OTL Shift Plan
This defines the Shifts prevalent across the Organization. The system provides us with an option of entering either duration of Shift or the start & stop timings of the shift.
Navigation:
OTL Application Developer OTL Time Accounting Table Setup and
Maintenance Shift
OTL Work Plan
This is the Weekly Plan for a particular employee. The shifts defined already, will be assigned here.
Navigation: OTL Application Developer OTL Time Accounting Table Setup and
Maintenance Work Plan
OTL Rotation Plan
This is the pattern in which the employee groups move from one work plan to another after every week. Rotation plans identify the dates on which an employee moves from one work plan to another.
Navigation: OTL Application Developer OTL Time Accounting Table Setup and Maintenance Rotation Plan
10
OTL Earning Group
This provides a provision to group earning elements for reporting purpose This is also used in accumulating hours for further calculation
Navigation:
OTL Application Developer OTL Time Accounting Table Setup and
Maintenance Earning Group
11
OTL Time entry Rules and Rule Groups
Time Entry Rules To validate a timecard when it is saved or submitted and display a business message, error or warning. application. Time Entry Groups Once the time entry rules for validation are defined , the rules together can be clubbed and assigned to a person or a group of people via preferences. Navigation: OTL Application Developer Time Entry Rules
To determine which time entries or changes require approval for each
12
OTL Recurring Periods and Approvals
Recurring Periods Number of days or columns appearing in the timecard screen are controlled by Recurring Period. Navigation:
OTL Application Developer Recurring Period
Approvals Periods: To define what all applications will be using these periods
Style: To define the way of approval
Navigation: OTL Application Developer Approvals
13
OTL Preferences
Preferences are set to decide how the timecard will look like, what all validations will be applied on the time card.. This is done once all the set ups are done Preferences are created and attached to certain business group or organization or may be the employee depending on the requirements People can be eligible for more than one hierarchy, so we must define a precedence to each eligibility rule. A predefined eligibility rule links the default preference to all people, with a low precedence so you can override it.
14
OTL Assignment Time Info
Assignment Time Information window, is used to assign an employee to time management structures and policies In the Autogen Hours YN field, select Yes to auto generate this persons timecard or No to prevent auto generation
Navigation:
OTL Application Developer OTL Time Accounting Assignment Time Information
15
Technical Overview
16
OTL Time Building Blocks
When entering time in a time card, we actually create objects (database records) called time building blocks The OTL timecard data-structure is a hierarchical collection of time building blocks
The top time building block (the one without a parent) is the
TIMECARD time building block, and represents the range of time for which this timecard exists, such as a week or a month.
Time building blocks have one or more child blocks and one parent block. You can attach blocks to other blocks, and build the complete timecard for a period of time.
17
OTL Time Card Data Model
The data model reflects the user interface of the timecard page.
Model explanation:
Consider a square split in half. This square represents the screen, and in one half, we render the attributes associated with the TIMECARD time building block, such as the comment text field, in the other half, we render all the child building blocks of this block, the days and entries. Next, the process occurs for these child blocks, namely a square split in half, in one half we render the attributes the other we render the child building blocks of this block, and so on.
18
19
