Who's Online
1 registered (SBi), 1 Guest and 2 Spiders online.
Key: Admin, Global Mod, Mod
Recent Posts
Attach documents in the SIT/EIT
by SBi
Today at 09:31 AM
How managers initiates SSHR request of employees
by Saqib Rahat
Today at 04:29 AM
French Localizations
by jmoyano
03/09/10 09:20 AM
FYI: P60s to be available in Self Service
by kp_rapolu
01/09/10 03:42 PM
SSHR Personalization requirement
by kp_rapolu
01/09/10 03:41 PM
Request for responsibility in ESS
by SBi
01/09/10 05:49 AM
Nominate for peers/subordinat for reward
by bcooper
31/08/10 07:46 PM
UK HCM Sig - 29th September
by andy.fisher
31/08/10 10:05 AM
Migration of terminated Employees
by SBi
31/08/10 10:02 AM
Worldwide Bank Details Validation
by SBi
27/08/10 02:33 PM
Top Posters (30 Days)
SBi 29
bcooper 14
CT 12
PeterP 10
Geoff Dixon 8
Saqib Rahat 8
EBS_USER 6
kp_rapolu 5
delboy 5
MarinaH 3
(Views)Popular Topics
Family Pack K issues thread 8784
CREATE_GRADE api returns:PLS-00306: wrong number o 6108
Still trying to locate... 4621
Creating hr jobs ORA-20001: HR_289477_JOB_GROUP_ID 4401
Review of my Release 12 laptop 4221
Log-on problems for existing users 3530
Viewing Output of another user 3238
Family Pack K 3105
October UK-OUG? 3074
uploading bank branches to PAYROLL 2895
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: 816
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: 816
Loc: Back at Fort Apache, Gosport!
Thanks for letting us know - very useful little snippet there.
_________________________
L&K
CT

Top


Moderator:  bcooper, CT 
Oracle R12.1.1 on your existing computer
Get up and running with Oracle on your existing computer in 5 minutes

Get up and running with Oracle on your existing computer in 5 minutes!

Alard Consulting Ltd are pleased to offer Oracle R12.1.1 on your existing computer.

Connect to Oracle R12 from your computer to do client demonstrations, your own development work, or test functional setup on a Vision environment without having to install and maintain Oracle.

Backup your work before making changes in case things go wrong. Just copy the files to a new directory before making the changes. If it doesn't work, copy the files back again, all from Windows. No other skills needed.

As everything is contained on a single external hard drive, you can take it with you to use wherever you need it.

For each sale from HCMAces a portion of the price will go to the running costs of this forum.

For more information see www.alard.net/products.html.

Forum Stats
492 Members
48 Forums
1208 Topics
5712 Posts

Max Online: 51 @ 12/08/10 02:30 AM
Today's Birthdays
whi5tler (34)
Recent vacancies
Top Posters
bcooper 944
CT 816
Geoff Dixon 354
delboy 291
SBi 289
vkumar 223
kp_rapolu 208
cbrookes 197
Gavin Harris 111
jmoyano 96
September
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