ORACLE TIME AND LABOR

1
ORACLE TIME AND LABOR
Without the Utilization of the Oracle Project
Module
2
DEFINITION

• Oracle Time Labor is an intuitive web-enabled
  timecard solution that allows you to reduce costs
  associated with time and attendance record
  keeping by completely automating time record
  keeping.
• For your employees, it offers a simplified way to
  submit, review, track and approve timecards.

3
BENEFIT

• Automated time recording and timekeeping solution
• Self-service capabilities
• Configurable Validations and Approval
• Direct relationship with Oracle HRMS and PA

4
THINGS TO CONSIDER

• Build a functional team of HR, Payroll,
  Timekeeping experts
• Consider business events like (i.e. Payroll
  deadlines, double payroll, yearend, etc.)
• Technical team
• DBAs
• Test, test, testoh, and did I mention testing?

5
SETUPS

• HR
• Elements ? Hours Type on a timecard
• Accrual Plans
• OTL
• Preferences
• Eligibility criteria (s)
• Workflow approval style
• Time Entry Rules
• Alternate Names

6
CUSTOM PIECES

• The Minimal Number of Steps to Configure a
  Timecard Layout
• Use one of the seeded timecard layouts as a basis
• You must rename the timecard layout
• You configure the components of the timecard
• Upload the timecard layout to the database using
  FNDLOAD

7
CUSTOM TIMECARD

• Find one of the delivered layouts which is
  closest to your requirements (example -
  exception layout)
• To avoid overwriting the delivered OTL layouts
  you must give your new timecard layouts new names.

8
CONFIGURED CHOICE LIST
9
SEEDED EXCEPTION TIMECARD

• Oracle Seeded Exception Layout Timecard Entry Page

10
SEEDED EXCEPTION TIMECARD

• Oracle Custom Layout Timecard Entry Page

11
EXAMPLE OF .ldt FILE
12
CONFIGURATION STEPS

• Create OTL custom view HXC_CUI_CUSTOMn_V
• OTL currently delivers ten of these configurable
  view objects

The views must have at least two columns and they
must be called DISPLAY VALUE and VALUE
13
STORING DATA

• In order to store data from our choice list we
  have to create Context and segment in OTL
  Information Types DFF.

14
UPLOADING TIMECARD LAYOUTS

• In order for modified layout to be available in
  the OTL Application Preferences, a DBA will have
  to execute the following command
• FNDLOAD username/password_at_dbname 0 Y UPLOAD HXC
  TOP/patch/115/import/ hxclaytlayoutsld.lct
  ./layout.ldt
• Note Every time you customized a layout, a DBA
  will have to reload your new layout.

15
PROCESS FLOW
16
COMMON ISSUES

• Customizations
• Fast Formulas for OTL Timecards
• Reporting
• Allocate time for Technical and DBAs teams
• Ensure business policies are articulated at the
  time requirements are gathered
• Volume testing earlier in the project

17
Q A