Who's Online
0 registered (), 5 Guests and 5 Spiders online.
Key: Admin, Global Mod, Mod
Recent Posts
Abseces in oracle hrms, super user: how to do I:
by tovia123
01:18 PM
Update EIT in SSHR
by Sahir
03:45 PM
End of Year Legislation Patch for 11i
by delboy
01:35 PM
Interfacing iRec and external sites
by DanC
09/02/12 11:42 PM
Capturing, Storing, & Paying Banked Overtime
by Paul
09/02/12 08:51 PM
Time and Labour & Oracle Projects
by Paul
09/02/12 07:34 PM
Search Engine Optimizers
by delboy
09/02/12 01:30 PM
Function for getting retropay-maintained balances
by CT
08/02/12 12:21 PM
Grade End Date
by Chris
03/02/12 10:46 AM
OLM Mandatory Enrolments
by bcooper
01/02/12 12:23 PM
Top Posters (30 Days)
CT 26
delboy 24
bcooper 14
tovia123 5
Sahir 5
Gus 5
Tim Bailey 3
SBi 3
christm 3
Simon_Mc 3
(Views)Popular Topics
Family Pack K issues thread 18240
CREATE_GRADE api returns:PLS-00306: wrong number o 13774
Still trying to locate... 12214
Creating hr jobs ORA-20001: HR_289477_JOB_GROUP_ID 10659
Viewing Output of another user 9140
HR_PF.K RUP4 8852
Review of my Release 12 laptop 8501
Adding a taskflow button to a form 7865
Enhanced Retro & Release 12 7689
Family Pack K 7127
Topic Options
Rate This Topic
#5139 - 08/02/10 09:53 AM Employee to Contingent System Person Type
MAL Offline
regular

Registered: 02/11/07
Posts: 25
Loc: Manchester
Hi,

We have 144 employees who have been created incorrectly with a system person type of Employee, I need to change these to a system person type of Contingent worker.

If there is a way to change the existing records or is it best to terminate the employee record and then create a new contingent worker period of placement from the next day?

Manually we can do this by terminating the employee record and creating a new placement from the next day, but the hr_period_of_services_api and hr_period_of_placement_api don't seem to have the correct functionality regarding terminations to work properly to do this at database level.

Has anyone ever done this before and could you please help me with the processes you used to make the change?

Many thanks

Martin

Top
#5140 - 10/02/10 09:29 AM Re: Employee to Contingent System Person Type [Re: MAL]
CT Online   content
Guru
***

Registered: 11/03/05
Posts: 1080
Loc: Bath
Hello Martin

I've never tried it myself, but on a nearby 11.5.10 instance I note with interest that there is an API called hr_contingent_worker_api.convert_to_cwk - might be worth experimenting with that as a start?
_________________________
L&K
CT

Remember: A dog is for life, not just for Christmas... unless you're in Korea

Top
#5240 - 25/02/10 09:40 AM Re: Employee to Contingent System Person Type [Re: CT]
MAL Offline
regular

Registered: 02/11/07
Posts: 25
Loc: Manchester
Thanks CT,

This seems to have worked for me, I had to terminate the employee record first using:

hr_ex_employee_api.actual_termination_emp
hr_ex_employee_api.final_process_emp

I then ran the

hr_contingent_worker_api.convert_to_cwk

and the employee is now a contingent worker.

Thanks again

Martin

Top
#5243 - 25/02/10 12:46 PM Re: Employee to Contingent System Person Type [Re: MAL]
CT Online   content
Guru
***

Registered: 11/03/05
Posts: 1080
Loc: Bath
Thanks for letting us know - very useful little snippet there.
_________________________
L&K
CT

Remember: A dog is for life, not just for Christmas... unless you're in Korea

Top



Moderator:  bcooper, CT 
Forum Stats
756 Members
48 Forums
1517 Topics
7287 Posts

Max Online: 63 @ 24/11/10 07:21 AM
Today's Birthdays
No Birthdays
Recent vacancies
Tea boy available 4 basic chores & some! services
by Simon_Mc
19/01/12 03:59 PM
Top Posters
bcooper 1095
CT 1080
delboy 500
Geoff Dixon 369
SBi 344
vkumar 223
kp_rapolu 213
cbrookes 197
Gavin Harris 160
Gus 132
February
Su M Tu W Th F Sa
1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29