BI Report: Restrict Line manager access to only his/her reportees in BI Report in Fusion HCM

Summary

BI Report: Restrict Line manager access to only his/her reportees in BI Report in Fusion HCM

Content

Hi All,

Please find below URL;

This video demonstrates how to restrict Line manager access to only his/her reportees in BI Report in Fusion HCM with a live example.

Below is the executed query;

SELECT
PPL.PERSON_NUMBER                                                            PERSON_NUMBER,
PERNAMES.LAST_NAME  ||' , '|| PERNAMES.FIRST_NAME                               EMPLOYEE_NAME,
LEG_TL.NAME                                                             LEGAL_EMPLOYER,
DEPT_TL.NAME                                                                 DEPARTMENT,
PER_EXTRACT_UTILITY.GET_DECODED_LOOKUP('REGULAR_TEMPORARY', ASG.PERMANENT_TEMPORARY_FLAG) PERMANENT_TEMPORARY_FLAG,
JOB.NAME                                              SYSTEM_ROLE,
ASG.ASSIGNMENT_NAME                                   WORKING_TITLE,