Oracle Time and Labor is very flexible when it comes to time entry methods. It has a solution for almost all the different scenarios you can think of. Lets go through them one by one:
Employee Self Service: A very straight forward and simple web based interface to enter timecard. Superb example of a custom rendering engine on top of the OA components which renders timecards based on the layout LDT flat files. Adding, modifying a component on the timecard is very simple and can be achieved through the modification of layout LDT file.
Authorized Delegate Self Service: A new feature added recently to imitate the timekeeper functionality in Self Service. It is based on HRMS security profile and provides a mechanism where a person can enter timecard for a set of people assigned to him. It is not an alternate solution to timekeeper functionality and is recommended to be used for scenarios where smaller number of subordinates is required to be handled through an Authorized Delegate.
Time Keeper: The perfect solution for scenarios like shop floor where you need a timekeeper to maintain and enter time for large number of people. It is a PUI form based interface and provides a mechanism for fast mass timecard entry and edit functionality. It is one of the most complex forms in the whole Oracle Apps where each and every component of the form is determined and created at runtime which is completely configurable based on OTL preferences. Literally saying, the static form is empty and the runtime form is having one of the most complex structures among all the Apps forms.
Disconnected Time Entry aka Spreadsheet: One of the features of OTL which allows to create timecard based on the provided spreadsheet (excel file) and a very important one where you get timecard data in the form of spreadsheets from the users who don’t have access to EBiz Application.
PUI Form based Timecard: The only interface where timecard data directly goes to HXT schema i.e. it has to have the OTLR rules enabled and the corresponding time management policies setup properly. This is the interface where you can see the exploded timecard data and corresponding rate values as per the rules setup.
PDA: Oracle Time & Labor also has functionality to let users enter time information with the use of a mobile phone or a Personal Digital Assistant (PDA).
Punch Machine / Time Capture Devices: OTL provides a set of PUBLIC APIs which enables to write interface for any Punching Machine or Time Capture Device. hxctsdp.pkb is the package which contains public API for timecard creation/manipulation. The API provide the functionality to add individual Time Building Blocks off any scope (DAY or DETAIL, including their associated attributes), to an existing timecard, to update existing Time Building Blocks with their associated attributes, to delete a complete timecard or a specific Time Building Block and its attributes from a timecard.
Apart from these time entry methods, a generic data flow and related processes is shown in the above diagram.
7 Responses to Time Entry methods and Data Flow in Oracle Time and Labor
Hi Shiv,
First of all I would like to thank you for sharing your experience generously with everyone. I've seen the active user you are on Oracle Forums - actually this where I came across your Blog address- I would like to thank you for that too.
Please let me know if I can share with you some of the issues I am facing with OTL; I might need your e-mail address to discuss things briefly with you. However I understand you might not have such time; hence I won't burden you with such detail; Ur blog and Oracle forums would be fine.
Either way Thank You so much.
Regards,
Ahmad
Thanks Ahmed.
You can put down your queries here or on the forum though I'm am not regular on forums due to time constraint. For urgent issues you can mail me at shiv.saroj@gmail.com
--Shiv
Hi Shiv,
Regarding the time Timekeeper Functionality, in case public API can't be used, is it possible to import timecards into OTL using a csv template for the whole timekeeper group (Sort of disconnected entry but for a group of users rather than single user).
Thanks,
Ahmad
No, you can't use csv files with timekeeper. Disconnected time entry is only for a single employee through his self service login.
In case you don't want to use the Timekeeper for mass time entry, then the only option is to use API and create timecards programmatically.
--Shiv
Hi Shiv,
Is there technical reference manual for OTL which gives table structures, there linkages etc.
Thanks.
Hi Shiv,
One of my client wants to use time attendance capture machine just as a device to record in and out times of employees.
Client do not want to maintain a third party database like SQL Server or Access and store the entered data directly into OTL tables? Can you please throw your suggestion on this?
Thanks & Regards,
Fayaz Ahamed Badubhai.
fayazahamed.badubhai@gmail.com
Hi Shiv,
My time card details for all employees are coming from the third party system in form of excel in a particular format. I would like to automate the process of loading the timecard data. Please suggest me.
Thanks
Praneeth
Something to say?