Who's Online
1 registered (Chris Abraham), 2 Guests and 7 Spiders online.
Key: Admin, Global Mod, Mod
Recent Posts
P11d's
by Chris Abraham
0 seconds ago
Oracle eBsuiness HRMS Trusted Recon Query Help
by CT
Today at 02:24 PM
Concurrent Request - running slow
by CT
Today at 12:48 PM
Pension Auto Enrolment
by delboy
Today at 12:13 PM
Oracle eBsuiness HRMS Trusted Reconcilaition Help
by Mani
Today at 07:35 AM
Element to recover value in balance on leaving
by jkavia
Yesterday at 11:04 AM
Assignment EIT not displaying in Self Service
by CT
Yesterday at 06:45 AM
Vehicle Mileage Setup
by Chris Abraham
21/05/12 12:24 PM
In which table is external learning data stored
by DMC
21/05/12 08:45 AM
Oracle Payroll and Cash Management
by Gus
20/05/12 11:27 AM
Top Posters (30 Days)
CT 40
delboy 39
Vigneswar Battu 15
pat.woodall 10
Mani 6
Gus 4
bcooper 4
Ryan 3
Jan 3
DMC 3
(Views)Popular Topics
Family Pack K issues thread 20170
CREATE_GRADE api returns:PLS-00306: wrong number o 15200
Still trying to locate... 13855
Creating hr jobs ORA-20001: HR_289477_JOB_GROUP_ID 11907
Viewing Output of another user 10324
HR_PF.K RUP4 10298
Review of my Release 12 laptop 9747
Enhanced Retro & Release 12 9402
Adding a taskflow button to a form 9140
Family Pack K 7910
Topic Options
Rate This Topic
#5442 - 12/05/10 09: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 06:05 AM Re: ORA-20001: Cannot rehire a person unless a final p [Re: D508132836]
delboy Offline
veteran

Registered: 15/03/05
Posts: 597
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 08:01 AM Re: ORA-20001: Cannot rehire a person unless a final p [Re: delboy]
CT Offline
Guru
***

Registered: 11/03/05
Posts: 1188
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
792 Members
48 Forums
1584 Topics
7663 Posts

Max Online: 67 @ 14/04/12 05:38 PM
Today's Birthdays
No Birthdays
Recent vacancies
Top Posters
CT 1188
bcooper 1112
delboy 597
Geoff Dixon 369
SBi 356
vkumar 223
kp_rapolu 213
cbrookes 197
Gavin Harris 163
Gus 146
May
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 31