Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
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