My Oracle Support Banner

ERS9.2: Terminated Members Have Been Showing in Express Search Page (Doc ID 2824009.1)

Last updated on JUNE 17, 2022

Applies to:

PeopleSoft Enterprise FIN Resource Management - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Members who have been terminated, will be in unassigned pool, but when doing the express search based on resource pool, these members have been shown.

Expected behavior is that members who have been terminated, will be in unassigned pool and when doing the express search based on resource pool, these members should not be shown up.

REPLICATION STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Resource Management/Express Search - Keywords field populated as Node;
2. Resource Pool field is selected , Pool ID is populated, Personnel Status as All;
3. Results are listing 2 Employee IDs who have Pool status as "Unassigned Pool" and Qual as 0% and the other Empl ID having Pool status as empty and Qual as 100%;
4. When checking table for both emplids, they have EMPL_STATUS as "T":
select * from ps_job where emplid='' order by effdt desc;

For the replication steps, please review Replication_file.

NOTE: In the  attached document, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance).  Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.