Data Secuirty in BI using different data secuitry on role configurations

Hello,

Am having this case here, Am using Secure View in my query (PER_ASSIGNMENT_SECURED_LIST_V) and am having 2 different data security on roles

1st Person Security Profile ( Secure by AOR - Legal Employer type)

2nd Person Security Profile (View all)

the 1st configuration sometimes it returns correct data - 2nd configuration non of them return correct data.

At the same time I checked that the assigned employees have got the correct AOR on there assignment.

Please advice.

Regards,

Yomna