Hi @Victor H , so your issue got resolved by completely removing the data roles from the groups assigned to the users, right? I'm understanding that if any user have groups without data roles assigned to any of these groups, then the user will be able to see entire data irrespective of their data access in Fusion. Please…

Hi @Sathyaprakash M , so are you saying that if we don't assign the data roles to the groups, the users will be able to see all the data irrespective of their data access in Fusion? @Conor Murnane , can you please confirm if it worked in your case?

Thanks Arjun.

Hi Sumanth, Thanks for your response. I already tried using pivot view but the output didn't make sense while looking at multiple employees at the same time, because different employees have different assignments. Also, when using the case-based logic, output isn't coming as expected, please refer below. I don't want to…

Is this functionality enabled yet or are there any plans in implementing it in future releases?

The HCM Departments and HCM Country values which are missing in the security assignments is the issue here. The user is now able to see data once the appropriate departments and country is assigned to her. Thank you.

I already added the HCM View All Data Security, but still there was no data showing up for the user. I checked the sub query in the session log and in the query, it was considering some details like SEC_OBJ_CODE for SEC_HCM_DEPARTMENT_LIST, SEC_HCM_LEGAL_EMPLOYER_LIST, SEC_HCM_COUNTRY_LIST, SEC_HCM_BUSINESSUNIT_LIST from a…

Also all the required HCM business units, HCM ledgers, HCM legal employers etc security context values are added to the user.