Custom Criteria in the person security profile is not working as expected. — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Custom Criteria in the person security profile is not working as expected.

edited Jan 24, 2025 8:40AM in Human Capital Management 1 comment

Summary:

Hi Everyone

We have created a person security profile with custom criteria. It is giving expected result when previewing in the security profile but when Data role attached to the user and user logins, goes to person management, it is not giving the expected. I would like to know whether the written query is valid. When i validated the query at the person security profile page, it was valid.

&TABLE_ALIAS.PERSON_ID IN (select paam.PERSON_ID
from  per_all_assignments_m paam,
      hr_organization_information_f hoif
where 1=1
and   paam.effective_latest_change='Y'
and   paam.assignment_type = 'E'

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!