This article is going to cover the steps required to make changes to OTL Timecard Layouts.
Goals of this exercise are:
1. Add a new field on Timecard Entry page which will allow users to select State value while entering the time. This location information should be stored as Attribute1 of the OHUGLOCATION context in OTL Time Store.
2. Cost Center field is to be removed.
3. State location information should be available to the Approver on Mass Timecard Approval screen and the Workflow notification page.
To keep the changes simple, In this entry I will cover only the steps required for the addition of new Context OHUGLOCATION in the OTL Time Store and the further steps to create/add the corresponding mapping component which will allow this value to get stored in proper place in Time Store without any code change. As we are talking about cost center attribute, its clear that it is a Payroll Time Card.
Before we start changes related to Time Card, have a look at the below image and understand the basic parts of a Time Card.
Step 1. Define a new Context, Segment in OTL Information Type Descriptive Flexfield
- Navigate to System Administration -> Application -> Flexfield -> Descriptive -> Segments
- Query for “OTL Information Type” in the Title field.
- Unfreeze Flexfield Definition.
- Create a new Context named OHUGLOCATION.
- Create a segment with values
Column : Attribute1
Step 2. Generate Flexfield and Mapping process
- From OTL Application Developer responsibility, run ‘Generate Flexfield and Mapping Information’ Process with the parameters
- Other parameters are optional.
Step 3. Mapping Components
Create a mapping component with values as shown in the screenshot
Step 4. Add Mapping component to Deposit Process
In case you want to save the new attribute information in the existing context, segment of the OTL Time Store like Dummy Element Context or Cost Context, then above steps are not required. Similarly, the mapping components can be modified to change the storage location of the time attributes.
We will see the Time Card layout related changes in the next blog entry.
10 Responses to Timecard Layout Modification
Hi Shiv,
In Step 3, you entered "P_Location_ID" in the 'Name' and 'Field Name' fields, I read (May be in oracle documentation, Can't recall exactly)that these names should relate or correspond to the names used by the API. can you further elaborate this issue.
Thanks,
Ahmad
Ahmed,
I am not sure in which context you are talking. Here I have just created a new context in OTL information Type DFF and for the segment added, a mapping component is defined to make sure that application knows how to map this context to database table/column.
As for the API context related usage, it will be used in the create_attribute method as the attribute name. You can use this newly created attribute like any other pre existing attributes like Task_Id or Project_id.
Let me know if you still have any doubt.
--Shiv
Hi Shiv,
I followed all your steps to add a new column 'ProjectName' right after 'Project' field in notification page. I already created the column with column heading as 'ProjectName' but I am unable to get the projectname values in the new column. Under 'OTL Information Type', I created PROJECTNAME as context then there I gave 'Project Id' as Name of segment and column as ATTRIBUT1. I also assigned a valueset which is based on below view: create or replace view HXC_CUI_CUSTOM1_V as
select project_NAME display_value,
project_id value from
HXC_BASE_PA_ONLINE_PROJECTS_V. Then I followed all your steps till addition of mapping component (i have taken PA Project1 instead of P_Location_ID) to Deposit Process. Then created Custom1VO where HXC_CUI_CUSTOM1_V is the view as stated above. I have changed the ldt file as below: BEGIN HXC_LAYOUT_COMP_QUALIFIERS "Projects Notification Layout - ProjectName"
OWNER = "CUSTOM"
QUALIFIER_ATTRIBUTE_CATEGORY = "CHOICE_LIST"
QUALIFIER_ATTRIBUTE1 = "Custom1VO"
QUALIFIER_ATTRIBUTE4 = "N"
QUALIFIER_ATTRIBUTE8 = "DisplayValue"
QUALIFIER_ATTRIBUTE9 = "Value#NUMBER"
QUALIFIER_ATTRIBUTE10 = "oracle.apps.hxc.selfservice.timecard.server.Custom1VO"
QUALIFIER_ATTRIBUTE17 = "OraTableCellText"
QUALIFIER_ATTRIBUTE20 = "N"
QUALIFIER_ATTRIBUTE21 = "Y"
QUALIFIER_ATTRIBUTE22 = "L"
QUALIFIER_ATTRIBUTE25 = "FLEX"
QUALIFIER_ATTRIBUTE26 = "PROJECTNAME"
QUALIFIER_ATTRIBUTE27 = "Attribute1"
QUALIFIER_ATTRIBUTE30 = "Y"
LAST_UPDATE_DATE = "2004/05/24"
END HXC_LAYOUT_COMP_QUALIFIERS
And uploaded the ldt. But, the projectname value was not populated.
Can you tell me where I should do the changes to get ProjectName values in the new column. Thanks
hi Shiv
i want to add text field 'Reason' in start time and another one after the stop time in time card and the Supervisor can edit on it
what can i do???
Hi Shiv ,
We currenty have Start and stop times only on Payroll layout timecard and not on Project layout .
I have a requirement which is to include the Start and stop time fields on the Project's layout too . Can you please let me know if this can be achieve through timecard customization , I mean changing the corresponding .ldt files .
Your reply will be helpful in deciding my approach .
Hi Shiv,
I have added a 'Location' package choice list on OTL Timecard page
It is populating data correctlyI followed your blog and created flexfield and mapped the field
I am able to see data in HXC_ATTRIBUTES table
But it is no into PA Tables after I run Transaction Import
Please help
Santosh
santoayeti@gmail.com
Hi Shiv,
I love this article about timecard layout modification. I learned so much from it. we are implement OAM/OTL . the view you are mentioned in this articile I can't get it from Database .Is it that mean this view haven't be used so I can create ?
Secondly, when I Configure the AK attribute are there any standard I have to follow? Can I give any name as Attirbute code &name?
I have never configure the AK area before.
Thank you so much for your help!
Stella
Hi Shiv,
Qualifier Attribute 26 under Hours Type Choice List in Seeded Payroll Timecard Layout is given as OTL_ALIAS_1.
Can you please explain what is this OTL_ALIAS_1 ?
Hi,
I have a requirement like,In the hours section the hours fields must display ZERO if they haven't enter any value or if they delete the hours value and tab out of the field it should display ZERO...
Can anyone help me??????
ANIL
Hi,
I have a requirement like i need to display ZEROs in hours fields in the hours section even if they delete the existing hours it has to show ZERO, It can't leave as blank which is sending null to building block table
Can anyone help me????
ANIL
Something to say?