Re-activate Employee
Date: Mon, 04 Oct 1999 10:34:11 EDT
From: "Alison Wilkes" wilkesa@hotmail.com
To: oraapps-l@cpa.qc.ca
Cc: alison.wilkes@mitsuiosk.com
Subject: AP: 10.7 character: Re-activate Employee
Did anyone have the following problem? If so I'd appreciate any comments as
to the completeness of my solution.
We have AP and GL installed.
User inactivated an employee by entering an Inactive Date in the Assignments
zone of the Enter Employee form. User then decided she should not have done
this, but form does not allow update of the Inactive Date.
Oracle says cannot re-active employee in AP 10.7 character. They sent me a
script to do so. Script consisted of 5 sql statements, every one of which
failed (no such table, invalid column name etc).
So I did the following:
1) delete record from per_people_f identifying employee as EX_EMP
2) update per_people_f.effective_end_date to 31-DEC-4712 in record
identifying employee as 'EMP'
3) update per_assignments_f.effective_end_date to 31-DEC-4712 for that
employee
4) update actual_termination_date, final_process_date,
last_standard_process_date to null in per_periods_of_service for that
employee
Thanks
Alison
Date: Fri, 15 Oct 1999 00:09:22 -0400
From: "Farber, Andy" farban@consumer.org
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: 10.7 character: Re-activate Employee
We faced the same issue more than once, as employees who had left were
re-hired. We got a script to fix this problem in Release 9, and they seemed
to work; the scripts for Release 10 didn't. Rather than try to debug them,
we set up a second record for the re-hired employee. I've been assured that
the Inactive Date field is not protected in the GUI forms...
Andrew R. Farber
Consumers Union of U.S., Inc.
914/378-2531