Custom Criteria in the person security profile is not working as expected.
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'