Who's Online
0 registered (), 11 Guests and 5 Spiders online.
Key: Admin, Global Mod, Mod
Recent Posts
Search Engine Optimizers
by delboy
Today at 09:09 AM
Function for getting retropay-maintained balances
by delboy
Yesterday at 02:20 PM
Abseces in oracle hrms, super user: how to do I:
by tovia123
04/02/12 09:33 PM
Grade End Date
by Chris
03/02/12 10:46 AM
OLM Mandatory Enrolments
by bcooper
01/02/12 12:23 PM
Retro-Notifs Report missing some ele entries
by CT
01/02/12 06:51 AM
P45 as PDF's
by SBi
30/01/12 11:58 AM
Employer Charges element in SOE
by Sachin
30/01/12 11:31 AM
Skinning SSHR?
by Duncan Casemore
28/01/12 10:49 AM
Time and Labour & Oracle Projects
by SBi
27/01/12 02:23 PM
Top Posters (30 Days)
delboy 24
CT 24
bcooper 17
Gus 14
paulgos 10
christm 5
Sahir 4
Simon_Mc 3
Tim Bailey 3
tovia123 3
(Views)Popular Topics
Family Pack K issues thread 18126
CREATE_GRADE api returns:PLS-00306: wrong number o 13685
Still trying to locate... 12118
Creating hr jobs ORA-20001: HR_289477_JOB_GROUP_ID 10583
Viewing Output of another user 9062
HR_PF.K RUP4 8783
Review of my Release 12 laptop 8453
Adding a taskflow button to a form 7807
Enhanced Retro & Release 12 7597
Family Pack K 7068
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 Offline
Guru
***

Registered: 11/03/05
Posts: 1073
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 Offline
Guru
***

Registered: 11/03/05
Posts: 1073
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
754 Members
48 Forums
1514 Topics
7262 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 1094
CT 1073
delboy 493
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