PROCESS HR_DRPT_BLD IS NOT EXCLUDING STUDENT REFUND RECORDS
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.
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.
HR_DRPT_BLD should exclude job records on PS_JOB when POI_TYPE (Person of Interest Type) = '00006'.
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:
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms