Who's Online
1 registered (SBi), 2 Guests and 1 Spider online.
Key: Admin, Global Mod, Mod
Recent Posts
Defaulting PO Information on assignment screen
by SBi
43 minutes 23 seconds ago
E-Bus Configuration and Management
by PeterP
Today at 01:28 PM
UMX : Oracle User Management Application
by natkins
Today at 12:58 PM
HRMS organization structures
by Geoff_Dixon
Today at 11:53 AM
HR_PF.K RUP4
by bcooper
Yesterday at 06:50 PM
Pay_Action_Parameter
s

by John Akinyode
09/03/10 11:05 AM
Error ORA-01002: fetch out of sequence
by delboy
03/03/10 04:46 PM
Multiple html sessions opening
by MarinaH
03/03/10 12:16 AM
Tories to revamp PAYE system
by Geoff_Dixon
26/02/10 01:48 PM
Employee to Contingent System Person Type
by CT
25/02/10 12:46 PM
Top Posters (30 Days)
CT 21
delboy 19
bcooper 14
MarinaH 14
natkins 14
SBi 10
gaztorres 8
Geoff_Dixon 7
Gus 4
Simon_Mc 3
(Views)Popular Topics
Family Pack K issues thread 5172
Review of my Release 12 laptop 3113
CREATE_GRADE api returns:PLS-00306: wrong number o 3085
Log-on problems for existing users 2997
Creating hr jobs ORA-20001: HR_289477_JOB_GROUP_ID 2340
October UK-OUG? 1956
Viewing Output of another user 1887
uploading bank branches to PAYROLL 1850
Still trying to locate... 1836
Family Pack K 1822
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: 751
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: 751
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
1122 Topics
5226 Posts

Max Online: 15 @ 20/10/09 02:30 PM
Today's Birthdays
No Birthdays
Recent vacancies
Developer - Permanent - based in Bracknell
by Geoff_Dixon
Today at 11:59 AM
Top Posters
bcooper 886
CT 751
Geoff_Dixon 340
delboy 255
SBi 249
vkumar 223
kp_rapolu 200
cbrookes 197
Gavin Harris 101
jhatten 95