Issue custom criteria in the person security profile
Content
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.
Tagged:
0