Issue with creating Person Security Profile using AoR (Location)

Content

Hi Gurus!

We are trying to restrict HR users' data access to employee records based on the location of employees in their Area of Responsibility using 2 different methods (Custom SQL and Areas of Responsibility) but neither is working. We have 16 locations and each location has its own HR representatives who should only be able to see the details of employees for their location when they log in. When I preview the profile for a selected HR user, the number of records returned is correct but when logging in as the user, they see employee records that do not fit the criteria