This document provides an overview and agenda for a presentation on customizing Oracle Time and Labor timecards. It discusses time entry basics, configuring timecards, common customizations like adding text fields, choice lists, and list of value regions. It provides details on customizing layout files, view objects, and application modules to add new functionality to timecards.
This document provides an overview and agenda for a presentation on customizing Oracle Time and Labor timecards. It discusses time entry basics, configuring timecards, common customizations like adding text fields, choice lists, and list of value regions. It provides details on customizing layout files, view objects, and application modules to add new functionality to timecards.
This document provides an overview and agenda for a presentation on customizing Oracle Time and Labor timecards. It discusses time entry basics, configuring timecards, common customizations like adding text fields, choice lists, and list of value regions. It provides details on customizing layout files, view objects, and application modules to add new functionality to timecards.
This document provides an overview and agenda for a presentation on customizing Oracle Time and Labor timecards. It discusses time entry basics, configuring timecards, common customizations like adding text fields, choice lists, and list of value regions. It provides details on customizing layout files, view objects, and application modules to add new functionality to timecards.
Download as PPT, PDF, TXT or read online from Scribd
Download as ppt, pdf, or txt
You are on page 1of 26
At a glance
Powered by AI
The key takeaways are understanding timecard basics, configuration, customizations, rules and personalization in Oracle Time and Labor.
The main components of an OTL timecard are time entry basics, timecard configuration, common customizations, time entry rules and OA framework personalization.
The different types of layouts in OTL are timecard, review, confirmation, details, export, notification and fragment layouts.
1
Understanding OTL Timecard Customizations
February 22, 2008 08:30 AM 09:10 AM Presented By Venu Bijumalla vbijumal@astcorporation.com
2 Agenda Time Entry Basics Timecard Configuration Common Customizations Time Entry Rules OA Framework Personalization Questions and Answers
3 Time Entry Basics Submit Save Review Timecard Review Confirmation OTL Single Point of Time Entry for use by multiple applications Time Store Central Repository for Time Data Modes of Time Entry Self Service Screens Line Manager Timekeeper Form Preferences Rules as how individuals or group of people can use the application
Process Flow
4 Vanilla Payroll Timecard
5 Time Building Blocks Range Entry of Time exists for a range of time (9:00 AM 05:00 PM) Measure Entry of Time that is a specific amount of time (8 hrs) User Interface Component Hierarchy Message components to show error, warning or confirmation messages Top Level Building Block Header table layout Header field table layout Inter-period navigation control Comments Component Timecard Matrix building block Measure field, Start & Stop time Template Save table layout Save template name field Save Template submit control
Timecard Page
6 Layout File Set of User Interface Components and associated qualifier descriptions Layout Type Timecard (Time Entry Page) Review (Timecard Review Page) Confirmation (Timecard Confirmation Page) Details (Timecard Details Page where applicable) Export (Template used for Timecard Export Functionality) Notification (Timecard Review page as seen by Timecard Approver) Fragment (Timecard Review page as seen by Timecard Approver but only those time entries for which the approver can approve the time) Audit (The Page on which audit entries, also known as reasons, are made)
Timecard Layout
7 Oracle delivers seeded layouts supported in OTL like Payroll, Projects, Projects and Payroll etc
Use one of the seeded layout closest to the requirements as the starting point for customization Copy the seeded layout file Change the layout name and description in the custom layout file Timecard Layout Customization Layout Name Layout Type File Name Payroll Timecard Layout TIMECARD hxczzhxclayt0000.ldt Payroll Review Layout REVIEW hxczzhxclayt0005.ldt Payroll Confirmation CONFIRMATION hxczzhxclayt0001.ldt
8 Change the top section in the layout file Change BEGIN HXC_LAYOUTS "PAYROLL-TIMECARD" "HXC" OWNER = "ORACLE" DISPLAY_LAYOUT_NAME = "Payroll Timecard Layout" LAYOUT_TYPE = "TIMECARD"
Upload Timecard Layout's Use FNDLOAD from the command line Example: FNDLOAD apps/apps@ebsdb 0 Y UPLOAD HXC_TOP/patch/115/import/hxclaytlayoutsld.lct ./ast_payroll.ldt
Timecard Layout Changes
9 View Objects A View Object is a standard BC4J object and the primary method to query data into Self-Service applications Application Modules An Application Module is a BC4J object which can be considered as a container for View Objects Apache/Jserv Server Changes to BC4J objects requires Apache Server bounce Delivered Configurable Objects OTL delivers a number of configurable
Configuration Concepts View Object Name View Object Class Configurable View Name Custom1VO oracle.apps.hxc.selfservice.timecard.server.Custom1VO HXC_CUI_CUSTOM1_V .. Custom10VO oracle.apps.hxc.selfservice.timecard.server.Custom10VO HXC_CUI_CUSTOM10_V
10 Add Text Field Component to the layout file Modify the Qualifiers in the Layout file
Adding Text Field
11 Use either Oracle delivered view objects or create custom view objects Modify the qualifier in the layout file
Adding Choice List
12 Create custom view objects Create LOV Attributes using AK Developer Create LOV Region Migrate LOV region from AK to MDS repository Add the LOV component and its qualifiers to the Custom layout file Copy/FTP the Custom View Objects/Application Modules to the Web Server Upload the custom layout file Bounce Apache Server
Adding LOV
13 Using JDeveloper create view objects Add view objects to Application Module
LOV View Objects
14 Switch to AK Developer Responsibility Navigate to Define Attributes
LOV Attributes Attribute ID Attribute Name Application Data Type Value Length Label CUS_TASK_ID Custom Task ID Time and Labor Engine Number 15 Task ID CUS_TASK_NAME Custom Task Name Time and Labor Engine Varchar2 50 Task Name CUS_TASK_NUMBER Custom Task Number Time and Labor Engine Varchar2 15 Task Number
15 LOV Attributes
16 Switch to AK Developer responsibility Navigate to Define Regions
LOV Region Region ID Region Name Application Name Object Name Region Style Application Module Definition Controller Object Type CUS_TASKS_LOV Custom Tasks LOV Time and Labor Engine ICX_PROMPTS List Of Values ast.oracle.app s.hxc.otl.custl ov.server.Ast AM oracle.apps.hxc .selfservice.con figui.webui.Lov CO ast.oracle.apps.hxc.otl.custlov.server.AstAM oracle.apps.hxc.selfservice.configui.webui.LovCO
17 LOV Region
18 Click on Region Items button LOV Region Items Attribute Name Queryable Item Name View Usage Name View Attribute Name Custom Task ID N CusTaskId TasksVO Taskid Custom Task Number Y CusTaskNumber TasksVO Tasknumber Custom Task Name Y CusTaskName TasksVO Taskname
19 LOV Region Items
20 Execute the following code snippet and commit the changes
23 Time Entry Rules Validate a Timecard when it is saved or submitted and display a business message, error or warning. Time Entry Rule Groups Group the Time Entry Rules and assign to a person or group of people via preferences. Time Categories Reporting purposes and identify the time to be analyzed by time entry rule formulas. Recurring Time Periods Frequency of timecard entry and approval Time Entry Rules
24 Time Entry Rules
25 Page rendered with Oracle Time and Labor timecard configuration utility, no UI components can be Personalized using the standard Oracle Applications Framework (OAF) functionality OAF Personalization functionality can be used to personalize LOV windows OA Personalization
26 Questions and Answers Questions and Open Discussions