Who's Online
0 registered (), 0 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Recent Posts
Irecruitment
by spiro
Today at 03:21 PM
Appraisal Session Timeout
by spiro
Yesterday at 07:48 PM
Heres a simple question on Workflow then ..
by bcooper
Yesterday at 09:54 AM
Defaulting PO Information on assignment screen
by bcooper
Yesterday at 09:52 AM
Creating an Attachment Table or Attachment Link
by Sahir
16/03/10 02:35 PM
OLM - Custom Role based on the 'Data Security'
by Geoff_Dixon
15/03/10 03:28 PM
E-Bus Configuration and Management
by PeterP
11/03/10 01:28 PM
UMX : Oracle User Management Application
by natkins
11/03/10 12:58 PM
HRMS organization structures
by Geoff_Dixon
11/03/10 11:53 AM
HR_PF.K RUP4
by bcooper
10/03/10 06:50 PM
Top Posters (30 Days)
CT 20
delboy 19
bcooper 18
natkins 16
MarinaH 14
SBi 10
gaztorres 8
Geoff_Dixon 8
kp_rapolu 4
Gus 4
(Views)Popular Topics
Family Pack K issues thread 5207
Review of my Release 12 laptop 3134
CREATE_GRADE api returns:PLS-00306: wrong number o 3123
Log-on problems for existing users 3014
Creating hr jobs ORA-20001: HR_289477_JOB_GROUP_ID 2392
October UK-OUG? 1998
Viewing Output of another user 1924
uploading bank branches to PAYROLL 1877
Still trying to locate... 1855
Family Pack K 1841
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: 23
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
veteran
*****

Registered: 11/03/05
Posts: 752
Loc: Back at Fort Apache, Gosport!
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

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: 23
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
veteran
*****

Registered: 11/03/05
Posts: 752
Loc: Back at Fort Apache, Gosport!
Thanks for letting us know - very useful little snippet there.
_________________________
L&K
CT

Top


Moderator:  bcooper, CT 
March
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 30 31
Forum Stats
421 Members
48 Forums
1129 Topics
5248 Posts

Max Online: 15 @ 20/10/09 02:30 PM
Today's Birthdays
Administrator (110), bcooper (43)
Recent vacancies
Oracle HRMS Consultants needed! Perm £70k!
by Shaylan
Today at 11:33 AM
Developer - Permanent - based in Bracknell
by Geoff_Dixon
11/03/10 11:59 AM
Perm Positions 1 x HR and 1 x Payroll
by bfrost
10/03/10 05:35 PM
Top Posters
bcooper 890
CT 752
Geoff_Dixon 343
delboy 255
SBi 249
vkumar 223
kp_rapolu 203
cbrookes 197
Gavin Harris 101
jhatten 95