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
Skip to content
  • Register
    • Get Started: AI Resources for Oracle Cloud HCM – Go Here

    Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

    SQL query fetching Duplicate rows for terminated employees with pending worker records

    edited Jun 19, 2019 8:15PM in Reporting and Analytics for HCM 18 comments

    Summary

    SQL query fetching Duplicate rows for terminated employees with pending worker records

    Content

    I created a SQL BI Publisher report to fetch all active employees and terminated employees along with their Manager person numbers in the system. While I am getting the results as expected, there are five terminated records who have duplicate rows due to different managers assigned to the pending worker record and employee record. 

    I am unable to exclude the duplicate records of the pending workers. I tried all the primary flags, system person types, Max Row, R count but nothing seems to be working. 

     

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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