Who's Online
1 registered (spiro), 3 Guests and 3 Spiders online.
Key: Admin, Global Mod, Mod
Recent Posts
Pension Schemes Setup
by kp_rapolu
Today at 03:09 PM
RBAC and Security Profiles
by CT
Today at 02:05 PM
Q: multiple assignments absence processing
by CT
Today at 12:34 PM
How managers initiates SSHR request of employees
by Saqib Rahat
Today at 09:00 AM
French Localizations
by bcooper
Yesterday at 07:11 AM
Setting up budgets in HRMS
by MarinaH
Yesterday at 06:06 AM
Attach documents in the SIT/EIT
by MarinaH
Yesterday at 03:09 AM
Talent management function in self service menu
by EBS_USER
06/09/10 11:23 PM
Basic Setup for CORE HR without Payroll
by EBS_USER
06/09/10 11:17 PM
FYI: P60s to be available in Self Service
by kp_rapolu
01/09/10 03:42 PM
Top Posters (30 Days)
SBi 31
CT 16
bcooper 15
Saqib Rahat 11
PeterP 10
EBS_USER 9
kp_rapolu 8
Geoff Dixon 8
delboy 5
MarinaH 5
(Views)Popular Topics
Family Pack K issues thread 8849
CREATE_GRADE api returns:PLS-00306: wrong number o 6175
Still trying to locate... 4660
Creating hr jobs ORA-20001: HR_289477_JOB_GROUP_ID 4444
Review of my Release 12 laptop 4226
Log-on problems for existing users 3538
Viewing Output of another user 3261
Family Pack K 3128
October UK-OUG? 3090
HR_PF.K RUP4 2908
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: 820
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: 820
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
494 Members
48 Forums
1213 Topics
5734 Posts

Max Online: 51 @ 12/08/10 02:30 AM
Today's Birthdays
No Birthdays
Recent vacancies
Top Posters
bcooper 945
CT 820
Geoff Dixon 354
SBi 291
delboy 291
vkumar 223
kp_rapolu 211
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