Duplicate Manager Data Integrity Report — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood: Oracle Cloud SCM and Purchasing

Duplicate Manager Data Integrity Report

edited Dec 18, 2020 11:41PM in Reporting and Analytics for HCM 4 comments

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!