Who's Online
0 registered (), 1 Guest and 6 Spiders online.
Key: Admin, Global Mod, Mod
Recent Posts
Abseces in oracle hrms, super user: how to do I:
by tovia123
Today at 01:18 PM
Update EIT in SSHR
by Sahir
Yesterday at 03:45 PM
End of Year Legislation Patch for 11i
by delboy
Yesterday at 01:35 PM
Interfacing iRec and external sites
by DanC
09/02/12 11:42 PM
Capturing, Storing, & Paying Banked Overtime
by Paul
09/02/12 08:51 PM
Time and Labour & Oracle Projects
by Paul
09/02/12 07:34 PM
Search Engine Optimizers
by delboy
09/02/12 01:30 PM
Function for getting retropay-maintained balances
by CT
08/02/12 12:21 PM
Grade End Date
by Chris
03/02/12 10:46 AM
OLM Mandatory Enrolments
by bcooper
01/02/12 12:23 PM
Top Posters (30 Days)
CT 26
delboy 24
bcooper 14
Sahir 5
Gus 5
tovia123 5
Tim Bailey 3
SBi 3
christm 3
Simon_Mc 3
(Views)Popular Topics
Family Pack K issues thread 18240
CREATE_GRADE api returns:PLS-00306: wrong number o 13772
Still trying to locate... 12214
Creating hr jobs ORA-20001: HR_289477_JOB_GROUP_ID 10658
Viewing Output of another user 9137
HR_PF.K RUP4 8851
Review of my Release 12 laptop 8500
Adding a taskflow button to a form 7861
Enhanced Retro & Release 12 7689
Family Pack K 7127
Topic Options
Rate This Topic
#5442 - 12/05/10 08:36 PM ORA-20001: Cannot rehire a person unless a final p
D508132836 Offline
passing stranger

Registered: 12/05/10
Posts: 1
Hello

When ever i am trying re-hire the employee using the API "hr_employee_api.re_hire_ex_employee" i am getting the below error message -any pointers on this error?

ORA-20001: Cannot rehire a person unless a final processing date exists for their previous period of service

Current status of the employee assignment is 'Terminate Assignment' and teh employee status is 'Ex employee'

Top
#5443 - 13/05/10 05:05 AM Re: ORA-20001: Cannot rehire a person unless a final p [Re: D508132836]
delboy Offline
veteran

Registered: 15/03/05
Posts: 500
Loc: Somewhere in Berkshire
You probably have terminated person records with no Final Process Date set on the Termination Record.

Cheers,

Delboy

Top
#5444 - 13/05/10 07:01 AM Re: ORA-20001: Cannot rehire a person unless a final p [Re: delboy]
CT Offline
Guru
***

Registered: 11/03/05
Posts: 1080
Loc: Bath
I would second Delboy's assertion - to which I would add, if you need to programatically set the final process date before re-hiring you could use the package procedure:

hr_ex_employee_api.final_process_emp
_________________________
L&K
CT

Remember: A dog is for life, not just for Christmas... unless you're in Korea

Top
#6209 - 22/12/10 03:47 PM Re: ORA-20001: Cannot rehire a person unless a final p [Re: D508132836]
Teena Offline
lurker

Registered: 07/12/10
Posts: 6
Hi

From front end you can go to people screen and then to end employment screen enter the final process date for the employee.

second way is to handle the same in your custom package in which api is called to hire the applicant.
you can check fot the employees data in per period of service table and all the date column are their in the table .once an exit is logged for the employee the actual termination date,notified date and last standard process date populates.
check in ur pckg if the final process date is null then pass the same value in final proces date as that of last standard process date and after which call the api and the issue would be sorted out.check for these conditions in code before caling api this will surely work.

please let me know if you have any queries.

--teena

Top



Moderator:  bcooper, CT 
Forum Stats
756 Members
48 Forums
1517 Topics
7287 Posts

Max Online: 63 @ 24/11/10 07:21 AM
Today's Birthdays
No Birthdays
Recent vacancies
Tea boy available 4 basic chores & some! services
by Simon_Mc
19/01/12 03:59 PM
Top Posters
bcooper 1095
CT 1080
delboy 500
Geoff Dixon 369
SBi 344
vkumar 223
kp_rapolu 213
cbrookes 197
Gavin Harris 160
Gus 132
February
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