PROCESS HR_DRPT_BLD IS NOT EXCLUDING STUDENT REFUND RECORDS (Doc ID 2154074.1)

Last updated on OCTOBER 17, 2016

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Process HR_DRPT_BLD is not excluding "student refund" job records. Therefore, when querying records like PS_HR_DIRECT_REP_5, erroneous rows are appearing.

"Student Refunds" are POIs that were created on Job Data by Campus Solutions to issue tuition refunds via Payroll for North America. Student Refunds are not considered employees, do not have careers, and cannot be managers.

PeopleSoft delivered Person of Interest Type 00006, so other non-higher education clients shouldn't be using this POI type.

While no new POI Types 00006 will be created (since HCM and CS have split), it is still an issue for data created before split.


EXPECTED BEHAVIOR
-----------------------
HR_DRPT_BLD should exclude job records on PS_JOB when POI_TYPE (Person of Interest Type) = '00006'.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. When querying records like PS_HR_DIRECT_REP_5, erroneous rows are appearing.

2. Other records which will return Student Refund information:

PS_HR_DIRECT_REP_2,

PS_HR_DIRECT_REP_3,

PS_HR_DIRECT_REP_4,

PS_HR_DIRECT_REP_6.


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