Secured Tables PER_PERSON_SECURED_LIST_V does not work as intended in BI

Summary:

Hello Everyone,

I am encountering an issue and wondering if anyone else had a similar issue.

I have a custom role copied from the seeded human resource specialist role.

This role is secured by area of responsibility with a scope Organization hierarchy by Business unit.

The role works fine for end users, there access is correctly restricted as per there business unit.

However the problem i encountered is that if in Analytics, i do a Select * from PER_PERSON_SECURED_LIST_V, only 1 line of data is queried.

i have run all processes to synchronize access, cleared cache, tried on different users with different Business unit and the same behaviour is observed