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 to get Manager Hierarchy

    edited Oct 10, 2023 4:48PM in Workforce Management 3 comments

    Summary:

    SQL to get Manager Hierarchy

    Content (required):

    SQL to get Manager Hierarchy

    Version (include the version you are using, if applicable):

    23C

    Code Snippet (add any code snippets that support your topic, if applicable):

    SELECT 

    DISTINCT

    papf_sup.person_number as "Line_Manager_Person_Number",

    ppnf_sup.first_name as "Line_Manager_First_Name",

    ppnf_sup.Last_name as "Line_Manager_Last_Name",

    pmhd.manager_level as "Line_Manager_Level",

    (SELECT PU.USERNAME FROM PER_USERS PU 

    WHERE PU.PERSON_ID = papf_sup.PERSON_ID

    AND PU.ACTIVE_FLAG = 'Y') AS "Line_Manager_Username",

    decode(pmhd.manager_level, '1', 'Direct Reportee', 'Indirect Reportee') Direct_Indirect,

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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