Who's Online Now
0 registered members (), 2 guests, and 16 spiders.
Key: Admin, Global Mod, Mod
Newest Members
MANISH KUMAR, Pallavi Negi, SalomeClara, Steph W, Aflexgis
1263 Registered Users
Recent Posts
RUP10 New Functionality
by delboy. 16/01/18 10:56 AM
EDI Replacement
by delboy. 16/01/18 06:33 AM
Happy New Year 2018
by CT. 02/01/18 08:30 AM
Recover an Advanced Grossup Payment
by Steph W. 21/12/17 11:34 AM
Top Posters(30 Days)
delboy 7
pat 1
CT 1
Popular Topics(Views)
433,897 PAYE RTI
51,502 HR_PF.K RUP4
Previous Thread
Next Thread
Print Thread
Rate This Thread
#12022 - 07/09/17 05:42 AM x-employee data migration andrespective assignment  
Joined: Sep 2017
Posts: 1
ARNISHA Offline
passing stranger
ARNISHA  Offline
passing stranger

Joined: Sep 2017
Posts: 1
KATHAMNDU,NEPAL
Hello Experts,
I have to migrate the x-employee data and its respective assignments data in per_all_people_f and per_all_assignments table.
I have used api 'hr_employee_api.create_employee' but it works for active employee only.If I passed the person_type_id=1123 also it is not inserting.Also for assignments I have used ' hr_assignment_api.update_emp_asg' but error came is: '-20001-ORA-20001: System Error: Procedure per_asg_bus1.dt_update_validate at Step 15'.

So can anyone guide me about right API to migrate X-employee(Terminate employee) and its assignments in HRMS(R12).

With Regards
Arnisha


ARNISHA
#12024 - 07/09/17 07:20 AM Re: x-employee data migration andrespective assignment [Re: ARNISHA]  
Joined: Mar 2005
Posts: 2,088
CT Offline
CT  Offline

****

Joined: Mar 2005
Posts: 2,088
Hi Arnisha,

The usual approach to migrating ex-employees is to first load them as employees using the API you mention, then (optionally) load assignment history, element entries, etc, THEN terminate them using a separate process calling the API hr_ex_employee_api.terminate_employee.

Hope this helps,


CT

Moderated by  bcooper, CT 

Forum Statistics
Forums48
Topics2,200
Posts11,895
Members1,262
Most Online90
Mar 5th, 2017
Today's Birthdays
No Birthdays
Recent vacancies
Top Posters(All Time)
CT 2,088
bcooper 1,285
delboy 1,262
paulgos 431
SBi 425
Gus 252
pat 250
vkumar 223
January
S M T W T F S
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
Powered by UBB.threads™ PHP Forum Software 7.6.0
Page Time: 0.033s Queries: 15 (0.013s) Memory: 2.7287 MB (Peak: 2.8642 MB) Zlib disabled. Server Time: 2018-01-18 12:04:20 UTC