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
Oracle Gold Partners, our very popular training packages, training schedule is listed here
Designed by Five Star Rated Oracle Press Authors & Oracle ACE's.
AUDIO-VIDEO DEMO CAN BE ACCESSED BY CLICKING ON THIS LINK
Apps2Fusion are passionate about Fusion Cloud E-Learning and classroom trainings. Training is our core business and we have been doing this for many many years. We work hard to advise trainees with right career paths. We have published various five star rated Oracle Press Books each was best sellers in its category. We have helped many and could help you as well.
Comments
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%performa nce department.
th anks in advance
~ Rgds,
Wahida
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.
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.
Thanks a lot for you Anil, it is realy helpful site, I can lean some of oracle technique.
Bea st Regard
sino
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-functio nal) .Salary as per expectations.No t applicable if already has worked for kbace.
Job location: Bangalore
Total IT Experience:
Re levant Experience:
Cu rrent CTC:
Expected CTC:
Notice period:
Reason for change:
Date of Birth:
Alterna te number :( Any):
Higher Qualification:
Awaiting for the positive response.
Regards,
Sadikhavolensoftware.com
sadikha ?
Volen Software Services Pvt. Ltd.
( 080-41135761/62 /63
#8, Cunningham Road, MSB 3rd Block, 4th floor, K.S.C.M.F.Build ing, Bangalore-56005 2
Nice Article. How do we migrate HRMS triggers from one instance to another. Please let me know.
Thanks,
Vijaya
You should be able to use FNDLOAD, as Oracle uses FNDLOAD too to deliver new triggers in their patches.
Pleas e see FNDLOAD basics article to learn FNDLOAD
Thanks,
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,
Vi jaya
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
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.
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
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-assignm ents_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.
Sandee p
T he primary business need is to populate the adjusted service date field with an accurate service date based on the business rule for the country of hire or rehire.
The adjusted service date has to be updated as soon as the record is updated in HRMS and not on a delay. This is to avoid any data discrepancy that may arise if the update is delayed as the adjusted service date could potentially be picked up in reports or sent to other systems through interfaces.
US/Canada
In the US and Canada, we have the following rules when an associate rehires as per the hire/rehire policy:
1.The adjusted service date for rehired associates will be calculated as follows:
1.1.If an associate is rehired prior to incurring a one-month break in service, the adjusted service date will be the original date of hire
1.2.If an associate is rehired after a one-month break but prior to a one-year break in service, an adjusted service date will be calculated giving credit for the associate’s prior service time, subtracting the time off between payroll separation and rehire
1.3.If an associate is rehired after a one-year break in service, the adjusted service date will be the new date of hire
1.4.If an associate is administrativel y separated and rehired following a determination that the hiring process for this associate was not strictly adhered to (e.g. new hire testing), the adjusted service date will be the new date of hire. Compensation and legal will review any and all exceptions, including superseding state regulations
2.T he pay rate will be the progression interval rate corresponding to the calculated adjusted service date (see examples in Table 1).
TABLE 1Orig Hire DateSeparation DateRehire DateAdjusted Service DateNew Pay RateNext Increase Date
1.1
(30;1 year)
4/8/024/ 11/045/1/05
5/1 /05Start rateFollows regular
progression
The CEMLI should be setup to apply these rules when calculating the adjusted service date for rehires.
Mexic o
In Mexico, rehires are not granted any service credit, so the adjusted service date is always set to latest hire date when an employee is rehired or hired. It also launches the new hire notification program.
Brazi l
In Brazil, the adjusted service date field is only used when an employee transfers to the Supply Chain group from a sister company. The adjusted service date field is left blank for all hires and rehires.
------ --------------- --------------- --------------- --------------- --------------- ------
I am thinking of calling an API which will update the adjusted_svc_da te ,in the package which gets called when the dynamic trigger fires.
Please suggest whether I am right or wrong.
Could you please help me on the below concern.
Can you please tell me what triggers for Hiredate and/or rehiredate to be picked up by the payroll interface.
Regards,
Jp
RSS feed for comments to this post