Migration of terminated Employees - HRMS Aces

Top Posters (30 Days)

(Views)Popular Topics

Family Pack K issues thread	20167
CREATE_GRADE api returns:PLS-00306: wrong number o	15200
Still trying to locate...	13854
Creating hr jobs ORA-20001: HR_289477_JOB_GROUP_ID	11904
Viewing Output of another user	10320
HR_PF.K RUP4	10295
Review of my Release 12 laptop	9744
Enhanced Retro & Release 12	9402
Adding a taskflow button to a form	9137
Family Pack K	7908

Page 1 of 2

Topic Options

Rate This Topic

#5713 - 26/08/10 04:02 AM Migration of terminated Employees
bts newbie Registered: 25/05/10 Posts: 12	Hi, We're currently doing data migration to HRMS. What's the API used to do migration of terminated employees that are not in the system? Thanks in advance!
Top

#5714 - 26/08/10 06:43 AM Re: Migration of terminated Employees [Re: bts]
PeterP hacker Registered: 08/03/07 Posts: 94 Loc: Manchester, UK	Hello, I think one of the forum's more technically oriented contributors, such as CT can give you a more precise answer, but my 2 pennies worth... As far as I am aware, you migrate terminated personnel using the standard employee API (hr_employee_api.create_gb_employee), and then subsequently terminate them, again this can be done through the terminate employee API (hr_ex_employee_api). If you look at "Publicly Callable Business Process APIs in Oracle HRMS" in "Oracle� Human Resources Management Systems" -- "Configuring, Reporting, and System Administration Guide" -- "Release 11i" -- "Part No. A95418-03", it has extensive documentation of the available API's and their usage. Note that this document is from the 11.5.10.2+ document set. I presume the R12 documentation set will have additional information. Regards, Peter.
Top

#5715 - 26/08/10 07:37 AM Re: Migration of terminated Employees [Re: PeterP]
CT Guru Registered: 11/03/05 Posts: 1186 Loc: Bath	Full marks Peter, we will make a techie of you yet! Bear in mind, also, that there might be other things you need to load for them too - in particular, if you are a payroll site, and you are migrating ex-employees that have received any kind of payments in the current tax year, then you'll need to load their balances too. _________________________ L&K CT Remember: A dog is for life, not just for Christmas... unless you're in Korea
Top

#5728 - 31/08/10 07:43 AM Re: Migration of terminated Employees [Re: CT]
bts newbie Registered: 25/05/10 Posts: 12	Thanks both for the response. For the hr_ex_employee, will that means running these 3 procedures in this sequence: 1. actual_termination_emp 2. update_term_details_emp 3. final_process_emp
Top

#5730 - 31/08/10 08:15 AM Re: Migration of terminated Employees [Re: bts]
CT Guru Registered: 11/03/05 Posts: 1186 Loc: Bath	Yes, that is correct, although you could interchange 2 and 3. But definitely step 1 first! _________________________ L&K CT Remember: A dog is for life, not just for Christmas... unless you're in Korea
Top

#5731 - 31/08/10 10:02 AM Re: Migration of terminated Employees [Re: PeterP]
SBi sitting tennant Registered: 23/05/08 Posts: 356 Loc: UK	Originally Posted By: PeterP Hello, I think one of the forum's more technically oriented contributors, such as CT can give you a more precise answer, but my 2 pennies worth... As far as I am aware, you migrate terminated personnel using the standard employee API (hr_employee_api.create_gb_employee), and then subsequently terminate them, again this can be done through the terminate employee API (hr_ex_employee_api). If you look at "Publicly Callable Business Process APIs in Oracle HRMS" in "Oracle� Human Resources Management Systems" -- "Configuring, Reporting, and System Administration Guide" -- "Release 11i" -- "Part No. A95418-03", it has extensive documentation of the available API's and their usage. Note that this document is from the 11.5.10.2+ document set. I presume the R12 documentation set will have additional information. Regards, Peter. Having done this I would also like to add that you also need to migrate all the assignment related information before you run the "termination" api. i.e. you cannot update all the assignment related information on the Ex-employees.
Top

#5823 - 20/09/10 01:25 PM Re: Migration of terminated Employees [Re: SBi]
bts newbie Registered: 25/05/10 Posts: 12	Hi! I was trying to run the first API but kept on hitting an error 'The Leaving Reason must exist within the HR lookup values'. I already checked the fnd_lookup_values where lookup_type = 'LEAV_REAS', the lookup code that I'm passing is there. please help! /bts
Top

#5825 - 20/09/10 01:31 PM Re: Migration of terminated Employees [Re: bts]
CT Guru Registered: 11/03/05 Posts: 1186 Loc: Bath	Is the code enabled, and is there a start/end date on it? Also, if you do SELECT USERENV('LANG') FROM DUAL; what answer do you get? _________________________ L&K CT Remember: A dog is for life, not just for Christmas... unless you're in Korea
Top

#5826 - 21/09/10 01:38 AM Re: Migration of terminated Employees [Re: CT]
bts newbie Registered: 25/05/10 Posts: 12	The code is enabled but without start/and date. Language is US. I tried front-end and I can see that the item in Leaving Reason is there. /bts
Top

#5828 - 21/09/10 02:27 AM Re: Migration of terminated Employees [Re: bts]
bts newbie Registered: 25/05/10 Posts: 12	Found where the problem is coming. The API is looking at the HR_LOOKUPS while the leaving reason that I'm testing is existing only in FND_LOOKUP_VALUES. Some setup issue. Thanks!
Top

Page 1 of 2

Hop to:

Moderator: bcooper, CT

Forum Stats

791 Members
48 Forums
1584 Topics
7657 Posts

Max Online: 67 @ 14/04/12 05:38 PM

Today's Birthdays

No Birthdays

Recent vacancies