Page 1 of 1
How to make leave calendar in Oracle HRMS
Posted: Fri Nov 28, 2008 9:11 am
by Maria Butt
Does any body know how to make calendar for leaves purpose and also how to make leave paln???
Thanks
Maria
Posted: Tue Dec 02, 2008 1:35 pm
by sayed.najafali
hi maria,
you need to create an UDT and incorporate the UDT values in FF by making use of UDF.
feel free to revert back for any more clarifications
Regards
Sayed
Posted: Wed Dec 03, 2008 2:46 am
by Maria Butt
I have no idea how to create UDT....culd u plz explain step by step
Posted: Wed Dec 03, 2008 9:09 am
by shakir786
I also have the requirement for creating the calendar in HRMS.. Could you please explain step by step..
Posted: Wed Dec 03, 2008 11:44 am
by alruwaished
you need to create payroll piord to use the absent management window to enter all leave type.
Posted: Wed Dec 03, 2008 4:19 pm
by sayed.najafali
dear alruwaished,
Are you sure what are you speaking about. Please do not provide base less replies
dear Maria/shakir,
for creating and UDT you need to follow the following steps.
1. HRMS Manager -> Other Definitions -> Table Structure
a.User Column Key Name
<Col_name> <col name>
b. Sequence Exact User Row Key
10 <Row Name> <Row Name>
2. HRMS Manager -> Other Definitions -> Table Values
query for the table structure you created and then query for the rows and then insert the values.
hope this helps, feel free to revert back for any more clarifications
Regards
Sayed
Posted: Thu Dec 04, 2008 9:34 am
by Maria Butt
Dear Najaf,
I've created the table using Table Structure in Other definitions.
table name is 'leave_calendar' match type is 'MATCH' and key unit of measure is 'Date'.
In columns I have got 1 column that is 'Calendar' and in rows I have '10' in sequence and '04-DEC-2008' in exact.
after creating table structure I put table values using 'table value' in other definitions.
Now please tell me, have i created it correctly and how do can I cal it in Absence form and mark on calendar.
Thanks for your help.
Regards,
Maria
Posted: Sun Dec 07, 2008 12:38 pm
by alruwaished
[quote]dear alruwaished,
Are you sure what are you speaking about. Please do not provide base less replies
dear Maria/shakir,
for creating and UDT you need to follow the following steps.
1. HRMS Manager -> Other Definitions -> Table Structure
a.User Column Key Name
<Col_name> <col name>
b. Sequence Exact User Row Key
10 <Row Name> <Row Name>
2. HRMS Manager -> Other Definitions -> Table Values
query for the table structure you created and then query for the rows and then insert the values.
hope this helps, feel free to revert back for any more clarifications
Regards
Sayed
<i><div align="right">Originally posted by sayed.najafali
Posted: Fri Dec 12, 2008 2:27 am
by Maria Butt
Dear Najaf,
I've created the table using Table Structure in Other definitions.
table name is 'leave_calendar' match type is 'MATCH' and key unit of measure is 'Date'.
In columns I have got 1 column that is 'Calendar' and in rows I have '10' in sequence and '04-DEC-2008' in exact.
after creating table structure I put table values using 'table value' in other definitions.
Now please tell me, have i created it correctly and how do can I cal it in Absence form and mark on calendar.
Thanks for your help.
Regards,
Maria