BIP Report- Need to Create Report based on User Access or Security Access.
Summary:
Need to Create BIP Report for performance , Which shows data based on User Access.
Content (required):
I need to create report for performance Module which show based on User access like Manager, Business partners . So If manager or HR run the report it should only able to see the employee details based on Roles/Security.
We have already used PER_PERSON_SECURED_LIST_V table in report but still many employee data are coming which are not part for Business Unit or Department. Employees are earlier part of business unit or department but now they moved to other department/Business unit but still they are coming in report.