Oracle Analytics Publisher

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Publisher

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Not getting the Manager Person Number

Accepted answer
75
Views
3
Comments
Faizan Rashid
Faizan Rashid Rank 1 - Community Starter
edited Feb 28, 2025 1:31PM in Oracle Analytics Publisher

Hello All,

When I am running a BI Report to get the manager person number, but I am not getting the manager person number. Not sure why.

If suggest something, if someone know anything.

Best Answer

Answers

  • MandeepGupta
    MandeepGupta Rank 8 - Analytics Strategist
    edited Feb 28, 2025 5:20AM
    https://community.oracle.com/products/oracleanalytics/discussion/24748/not-getting-the-manager-person-number

    Hi Faizan,

    Welcome to the Oracle Analytics community.

    You have posted this question under an incorrect category. The "Oracle Analytics Videos" category is a gallery to display the Oracle Analytics community videos of demos, keynotes, events, tutorials, trainings and more!

    You can check all the available categories under 'Forum' tab:

    image.png

    I believe your question is related to Fusion SaaS HCM - BIP report where you are unable to get the manager person number.

    Hi @Gianni Ceresa ,

    Hope you are doing well. Can you please help to move this thread under correct forum?

    Thanks.

  • Hari_Reddy
    Hari_Reddy Rank 1 - Community Starter
    edited Feb 28, 2025 6:07AM

    Try this

    SELECT papf.person_number,
    papf_sup.person_number supervisor_no,
    ppnf.full_name supervisorname
    FROM per_all_people_f papf,
    per_all_assignments_m paam,
    per_assignment_supervisors_f pasf,
    per_all_people_f papf_sup,
    per_person_names_f ppnf

    WHERE papf.person_id = paam.person_id
    AND paam.primary_assignment_flag = 'Y'
    AND paam.assignment_type = 'E'
    and paam.effective_latest_change = 'Y'
    AND papf.person_id = pasf.person_id
    AND pasf.manager_type = 'LINE_MANAGER'
    AND ppnf.person_id = pasf.manager_id
    AND papf_sup.person_id = pasf.manager_id
    AND ppnf.name_type = 'GLOBAL'
    and papf.person_number = nvl(:personnumber,papf.person_number)
    AND TRUNC(SYSDATE) BETWEEN pasf.effective_start_date AND pasf.effective_end_date
    AND TRUNC(SYSDATE) BETWEEN papf_sup.effective_start_date AND papf_sup.effective_end_date
    AND TRUNC(SYSDATE) BETWEEN ppnf.effective_start_date AND ppnf.effective_end_date
    AND TRUNC(SYSDATE) BETWEEN paam.effective_start_date AND paam.effective_end_date
    AND TRUNC(SYSDATE) BETWEEN paam.effective_start_date AND paam.effective_end_date