Duplicate Manager Data Integrity Report
Summary
Duplicate Manager Data Integrity Report not workingContent
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