|
0 registered (),
1
Guest and
6
Spiders online. |
|
Key:
Admin,
Global Mod,
Mod
|
|
|
#5713 - 26/08/10 03:02 AM
Migration of terminated Employees
|
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 05:43 AM
Re: Migration of terminated Employees
[Re: bts]
|
hacker
Registered: 08/03/07
Posts: 92
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
|
|
|
|
|
#5728 - 31/08/10 06:43 AM
Re: Migration of terminated Employees
[Re: CT]
|
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
|
|
|
|
|
#5731 - 31/08/10 09:02 AM
Re: Migration of terminated Employees
[Re: PeterP]
|
sitting tennant
Registered: 23/05/08
Posts: 344
Loc: 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.
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 12:25 PM
Re: Migration of terminated Employees
[Re: SBi]
|
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
|
|
|
|
|
#5826 - 21/09/10 12:38 AM
Re: Migration of terminated Employees
[Re: CT]
|
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 01:27 AM
Re: Migration of terminated Employees
[Re: 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
|
|
|
|
|
756 Members
48 Forums
1517 Topics
7287 Posts
Max Online: 63 @ 24/11/10 07:21 AM
|
|
|
|
|
|
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
|
|
|
|
|
|
Previous Topic
Index