Apps To Fusion

.......Our Journey from Apps To Fusion

 
  • Increase font size
  • Default font size
  • Decrease font size



Dynamic Triggers in HRMS Payroll - Demo

E-mail
User Rating: / 0
PoorBest 
In previous article we learnt the very basics of creating Dynamic Triggers in Oracle HRMS.
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)add
Implementing Competency model in Oracle HRMS
written by ahanazi , November 24, 2007
Hello their;

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 reqard&#xpe;rformance department.

thanks in advance
report abuse
vote down
vote up
Votes: +0
Good Show !
written by Wahida Kazi , November 27, 2007
Keep it up !
~ Rgds,
Wahida
report abuse
vote down
vote up
Votes: +0
Bank Transfer
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.

report abuse
vote down
vote up
Votes: +0
employee appears twice in self service
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.
report abuse
vote down
vote up
Votes: +0
Hi Anil
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

report abuse
vote down
vote up
Votes: +0
...
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 smilies/sad.gif 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
Votes: +0
Migrating HRMS triggers
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
report abuse
vote down
vote up
Votes: +0
...
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
report abuse
vote down
vote up
Votes: +0
Migrating HRMS triggers
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
report abuse
vote down
vote up
Votes: +0
...
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
report abuse
vote down
vote up
Votes: +0
doubt
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.
report abuse
vote down
vote up
Votes: +0
Job Group
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
report abuse
vote down
vote up
Votes: +0
How to employ "After update of on " logic in a dynamic trigger.
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
report abuse
vote down
vote up
Votes: +0
Write comment
quote
bold
italicize
underline
strike
url
image
quote
quote
smile
wink
laugh
grin
angry
sad
shocked
cool
tongue
kiss
cry
smaller | bigger

security image
Write the displayed characters


busy
Last Updated ( Thursday, 22 November 2007 19:34 )  

Search apps2fusion