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

Issue custom criteria in the person security profile

Received Response
edited Jun 9, 2020 10:00AM in Human Resources 3 comments


Hello Everyone,


I have created the following SQL query to be entered into custom criteria (person security profile).

&TABLE_ALIAS.PERSON_ID IN (select distinct paam.person_id
from per_all_assignments_m paam

JOIN PER_ASG_RESPONSIBILITIES ast on ast.person_id=300000004331847
JOIN per_departments dep on dep.organization_id=paam.organization_id
JOIN per_dept_tree_node_v alb on dep.organization_id=alb.organization_id

start with dep.organization_id = ast.top_department_id
connect by prior dep.organization_id=alb.PARENT_ORGANIZATION_ID


Unfortunately, it is not working. Do you know if the problem is the JOIN function? The system alerts that using JOIN the performances will be affected.

Howdy, Stranger!

Log In

To view full details, sign in.


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