Inactive Applicant Can Login To Candidate Gateway Careers Site After Changing The Status To Inactive (Doc ID 2245443.1)

Last updated on MARCH 17, 2017

Applies to:

PeopleSoft Enterprise HCM Candidate Gateway - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

After changing an applicant status to 030 Inactive, the applicant login table (PS_HRS_APP_LOGIN) is not updated (field HRS_OPRSTATUS). Since the status is still Active, the applicant can still login to the careers site.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
 
1. Create an applicant in Candidate Gateway and apply for any job so he has an active applicant id.
2. Run the following queries to confirm that he is active in both HRS_APP_LOGIN and HRS_APPLICANT tables...
select * from ps_hrs_applicant where hrs_person_id = (Applicant ID)
select * from ps_hrs_app_login where hrs_person_id = (Applicant ID)

3. Set Applicants status to Inactive.
4. Run the following query again to confirm applicant status change in HRS_APPLICANT table…
select * from ps_hrs_applicant where hrs_person_id = (Applicant ID)

5. However if you query the HRS_APP_LOGIN table the applicant is still active in that table and is still able to log in to candidate gateway…
 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms