In continuation with the previous article, please find an audio-visual demo that shows the steps involved in writing triggers on Oracle HRMS and Payroll Tables..
AUDIO-VIDEO DEMO CAN BE ACCESSED BY CLICKING ON THIS LINK
Comments
(13)
Good Show !
written by Wahida Kazi , November 27, 2007
written by Wahida Kazi , November 27, 2007
Keep it up !
~ Rgds,
Wahida
Votes: +0
~ Rgds,
Wahida
report abuse
vote down
vote up
Bank Transfer
written by Nakhla Al-Hawi , December 05, 2007
written by Nakhla Al-Hawi , December 05, 2007
Dear Sir's
I am trying to develop bank transfer as text file after pre payment process,
when I check pay_assignment_actions table the payroll_action_id is null for that my query return 0 rows.
kindly if there is any help to generate that request.
Votes: +0
I am trying to develop bank transfer as text file after pre payment process,
when I check pay_assignment_actions table the payroll_action_id is null for that my query return 0 rows.
kindly if there is any help to generate that request.
report abuse
vote down
vote up
employee appears twice in self service
written by malati , December 14, 2007
written by malati , December 14, 2007
there is an employee ABC who was hired on 21-jan-2001 and was terminated on 1-jun-2007.during this assignment he had assignment number 1001 and supervisor A.he was terminated using the end employment form with final process date left blank.he was rehired on 1-aug-2007 as a contingent worker.this assignment has a number 2001 and supervisor B.now the issue is when the supervisors log intomanagers selfservice responsibility->My employee information :-
the employee is visible under both supervisors A with assignment number 1001 even though he is terminated and under supervisor B with assignment number 2001 whereas the business functionality eants to see him just under supervisor B.Now if I specify the final process date as one day prior to the rehire date will this solve my problem or because he has payroll actions as of today specify the next pay period end date as the final process date and terminate him then will he not be visible under supervisor A after the pay period end date.
Can any one suggest a solution.
Votes: +0
the employee is visible under both supervisors A with assignment number 1001 even though he is terminated and under supervisor B with assignment number 2001 whereas the business functionality eants to see him just under supervisor B.Now if I specify the final process date as one day prior to the rehire date will this solve my problem or because he has payroll actions as of today specify the next pay period end date as the final process date and terminate him then will he not be visible under supervisor A after the pay period end date.
Can any one suggest a solution.
report abuse
vote down
vote up
Hi Anil
written by Lee , December 28, 2007
written by Lee , December 28, 2007
Hi Anil,
Thanks a lot for you Anil, it is realy helpful site, I can lean some of oracle technique.
Beast Regard
sino
Votes: +0
Thanks a lot for you Anil, it is realy helpful site, I can lean some of oracle technique.
Beast Regard
sino
report abuse
vote down
vote up
...
written by sadia , February 29, 2008
written by sadia , February 29, 2008
BMAH
Hi,
Greetings to you from VOLEN SOFTWARE SERVICES. We currently have requirements with KBACE TECHNOLOGIES Leading MNC. Since your profile matches with the requirements from our clients, would like to know your interest for a change currently. If Interested, kindly send me your updated CV and we shall get back to you, share with you the current requirements and process your CV as per your interest. Also since our Clients are having huge requirements currently, would appreciate your references of any of your friends or colleagues who are looking for a change. kindly send us your updated resume if you are interested to work with kbace technologies(U.S BASED) top most company looking for 4 exp on oracle hrms
(techno-functional) .Salary as per expectations.Not applicable if already has worked for kbace.
Job location: Bangalore
Total IT Experience:
Relevant Experience:
Current CTC:
Expected CTC:
Notice period:
Reason for change:
Date of Birth:
Alternate number
Any):
Higher Qualification:
Awaiting for the positive response.
Regards,
This e-mail address is being protected from spambots. You need JavaScript enabled to view it
sadikha ?
Volen Software Services Pvt. Ltd.
( 080-41135761/62/63
#8, Cunningham Road, MSB 3rd Block, 4th floor, K.S.C.M.F.Building, Bangalore-560052
Votes: +0
Hi,
Greetings to you from VOLEN SOFTWARE SERVICES. We currently have requirements with KBACE TECHNOLOGIES Leading MNC. Since your profile matches with the requirements from our clients, would like to know your interest for a change currently. If Interested, kindly send me your updated CV and we shall get back to you, share with you the current requirements and process your CV as per your interest. Also since our Clients are having huge requirements currently, would appreciate your references of any of your friends or colleagues who are looking for a change. kindly send us your updated resume if you are interested to work with kbace technologies(U.S BASED) top most company looking for 4 exp on oracle hrms
(techno-functional) .Salary as per expectations.Not applicable if already has worked for kbace.
Job location: Bangalore
Total IT Experience:
Relevant Experience:
Current CTC:
Expected CTC:
Notice period:
Reason for change:
Date of Birth:
Alternate number
Any): Higher Qualification:
Awaiting for the positive response.
Regards,
This e-mail address is being protected from spambots. You need JavaScript enabled to view it
sadikha ?
Volen Software Services Pvt. Ltd.
( 080-41135761/62/63
#8, Cunningham Road, MSB 3rd Block, 4th floor, K.S.C.M.F.Building, Bangalore-560052
report abuse
vote down
vote up
Migrating HRMS triggers
written by Vijaya , May 06, 2008
written by Vijaya , May 06, 2008
Hi Anil,u
Nice Article. How do we migrate HRMS triggers from one instance to another. Please let me know.
Thanks,
Vijaya
Votes: +0
Nice Article. How do we migrate HRMS triggers from one instance to another. Please let me know.
Thanks,
Vijaya
report abuse
vote down
vote up
...
written by Anil Passi- , May 07, 2008
written by Anil Passi- , May 07, 2008
Hi Vijaya
You should be able to use FNDLOAD, as Oracle uses FNDLOAD too to deliver new triggers in their patches.
Please see FNDLOAD basics article to learn FNDLOAD
Thanks,
Anil
Votes: +0
You should be able to use FNDLOAD, as Oracle uses FNDLOAD too to deliver new triggers in their patches.
Please see FNDLOAD basics article to learn FNDLOAD
Thanks,
Anil
report abuse
vote down
vote up
Migrating HRMS triggers
written by Vijaya , May 08, 2008
written by Vijaya , May 08, 2008
Hi Anil,
Thanks for the quick reply. I couldn't find the exact FNDLOAD script for downlaoding HRMS triggers. Please can you give me the script for the same. Is it fine to call a package which calls workflow using HRMS Dynamic Triggers. Please Advice me.
Thanks,
Vijaya
Votes: +0
Thanks for the quick reply. I couldn't find the exact FNDLOAD script for downlaoding HRMS triggers. Please can you give me the script for the same. Is it fine to call a package which calls workflow using HRMS Dynamic Triggers. Please Advice me.
Thanks,
Vijaya
report abuse
vote down
vote up
...
written by Mazen , May 14, 2008
written by Mazen , May 14, 2008
Hi Anil,
Could you please show me how to capture the "session id" in a dynamic trigger. I am trying to simultate auditing on entries and entry values throught dynamic triggers on each of the two tables. I need to capture the session id and the timestamp.
Thanks
paps
Votes: +0
Could you please show me how to capture the "session id" in a dynamic trigger. I am trying to simultate auditing on entries and entry values throught dynamic triggers on each of the two tables. I need to capture the session id and the timestamp.
Thanks
paps
report abuse
vote down
vote up
doubt
written by raja.sen.250379 , April 23, 2009
written by raja.sen.250379 , April 23, 2009
Hi,
Thanks for the demo. I wanted to know , if there is any error occured (like violation of business logic) then I want to raise an error and want to show the error to PUI user.
Votes: +0
Thanks for the demo. I wanted to know , if there is any error occured (like violation of business logic) then I want to raise an error and want to show the error to PUI user.
report abuse
vote down
vote up
Job Group
written by JPa , February 08, 2010
written by JPa , February 08, 2010
Hi Anil,
I have created a Job Group with my own name and created few jobs under the job group which i have created, but when i go to position it says no job exists, it is not showing in the list of values but it is showing the jobs which i created under the job group which the application creates when we create a Business Group. Can anyone guide me is there any setup where we need to set the job group which i created or how?
Regards,
JP
Votes: +0
I have created a Job Group with my own name and created few jobs under the job group which i have created, but when i go to position it says no job exists, it is not showing in the list of values but it is showing the jobs which i created under the job group which the application creates when we create a Business Group. Can anyone guide me is there any setup where we need to set the job group which i created or how?
Regards,
JP
report abuse
vote down
vote up
How to employ "After update of on " logic in a dynamic trigger.
written by Sandeep.K , June 29, 2011
written by Sandeep.K , June 29, 2011
Hi Anil,
Very good article!
Based on your video tutorial i have created a dynamic trigger to capture the location and position details whenever a supervisor( supervisor_id column in per_all-assignments_f table) is changed for an employee. This dynamic trigger is firing everytime the table gets updated, I want this dynamic trigger to fire only when a supervisor is changed. Is this possible to achieve this, is so how ?
Thanks in advance.
Sandeep
Votes: +0
Very good article!
Based on your video tutorial i have created a dynamic trigger to capture the location and position details whenever a supervisor( supervisor_id column in per_all-assignments_f table) is changed for an employee. This dynamic trigger is firing everytime the table gets updated, I want this dynamic trigger to fire only when a supervisor is changed. Is this possible to achieve this, is so how ?
Thanks in advance.
Sandeep
report abuse
vote down
vote up
| < Prev | Next > |
|---|





thanks a lot for you Anil, it is realy helpful site, i get it by chance.
i would like to ask this question: how can i implement the competency model with multible competenct catalogue ? i mean training department have their own competency which is defer from reqardpe;rformance department.
thanks in advance