Duplicate Manager Data Integrity Report

Summary

Duplicate Manager Data Integrity Report not working

Content

Hi All, 

We have a data integrity report that we would like some help troubleshooting. This report is intended to identify duplicate managers. Here is the SQL we are using:

SELECT
PASF.PERSON_ID,
(SELECT PAPF.PERSON_NUMBER
   FROM PER_ALL_PEOPLE_F PAPF
  WHERE PAPF.PERSON_ID = PASF.PERSON_ID
     AND PAPF.EFFECTIVE_START_DATE =
              (SELECT MAX(PAPF1.EFFECTIVE_START_DATE)
                    FROM PER_ALL_PEOPLE_F PAPF1
                WHERE PAPF1.PERSON_ID = PAPF.PERSON_ID)) AS PERSON_NUMBER,
PASF.MANAGER_TYPE,
PASF.EFFECTIVE_START_DATE,
PASF.ASSIGNMENT_ID
FROM PER_ASSIGNMENT_SUPERVISORS_F PASF