ETHNIC_GROUP is Blank After Running Refresh EMPLOYEES Table (PER099) When Employee has More than One ETHNIC_GROUP (Doc ID 1676418.1)

Last updated on JUNE 05, 2017

Applies to:

PeopleSoft Enterprise HRMS Human Resources - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

After running Refresh EMPLOYEES Table (PER099) process, the ETHNIC_GROUP is blank when Employee has more than one ETHNIC_GROUP.

Replication Steps:
-------------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Workforce Administration > Personal Information > Biographical > Modify a Person and enter 'ADCRM1001' in Emplid.
2. Click on 'Regional' tab, Under USA, change the Ethnic Group to 'Asian' from 'White' and click on Primary Check box.
3. Run the below Select statements:

SELECT EMPLID,NAME,ETHNIC_GROUP,COUNTRY FROM PS_EMPLOYEES WHERE EMPLID= 'ADCRM1001';

EMPLID NAME ETHNIC_GROUP COUNTRY
----------- -------------------------------------------------- ------------ -------
ADCRM1001 Savana Miller 1 USA

SELECT * FROM PS_DIVERS_ETHNIC where EMPLID = 'ADCRM1001';

EMPLID REG_REGION ETHNIC_GRP_CD SETID APS_EC_NDS_AUS PRIMARY_INDICATOR
----------- ---------- ------------- ----- -------------- -----------------
ADCRM1001 USA ASIAN USA N Y

4. Now run the Refresh EMPLOYEES Table process under Set Up HRMS > System Administration > Database Processes > Refresh EMPLOYEES Table.

5. Now again run the below stmts. As we can see after running the refresh employee process, it had a correct ethnic group if it has only one ethnic group.

SELECT EMPLID,NAME,ETHNIC_GROUP,COUNTRY FROM PS_EMPLOYEES WHERE EMPLID= 'ADCRM1001';
EMPLID NAME ETHNIC_GROUP COUNTRY
----------- -------------------------------------------------- ------------ -------
ADCRM1001 Savana Miller 4 USA

SELECT * FROM PS_DIVERS_ETHNIC where EMPLID = 'ADCRM1001';
EMPLID REG_REGION ETHNIC_GRP_CD SETID APS_EC_NDS_AUS PRIMARY_INDICATOR
----------- ---------- ------------- ----- -------------- -----------------
ADCRM1001 USA ASIAN USA N Y

6. Navigate to Worforce Administration > Personal Information > Biographical > Modify a Person and enter 'ADCRM1001' in Emplid. Now add one more ethnic group, WHITE.

7. Run Refresh EMPLOYEES Table by navigating to Set Up HRMS > System Administration > Database Processes > Refresh EMPLOYEES Table.

8. Upon running the same select statements, the ETHNIC_GROUP value in PS_EMPLOYEES table is blank.

SELECT EMPLID,NAME,ETHNIC_GROUP,COUNTRY FROM PS_EMPLOYEES WHERE EMPLID= 'ADCRM1001';
EMPLID NAME ETHNIC_GROUP COUNTRY
----------- -------------------------------------------------- ------------ -------
ADCRM1001 Savana Miller USA

SELECT * FROM PS_DIVERS_ETHNIC where EMPLID = 'ADCRM1001';
EMPLID REG_REGION ETHNIC_GRP_CD SETID APS_EC_NDS_AUS PRIMARY_INDICATOR
----------- ---------- ------------- ----- -------------- -----------------
ADCRM1001 USA ASIAN USA N Y
ADCRM1001 USA WHITE USA N N

After running the Refresh Employee process, the ETHNIC_GROUP is empty.

 

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