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

Employee Filter LOV not working in performance goals

We are creating a custom role using person security profiles. Employee/Manager filter LOV is not getting populated for it but if i search using department filter data is populating.

Custom Criteria -

EXISTS(
SELECT 1
FROM PER_POSITION_HIERARCHY_F hier
,PER_POSITION_HIERARCHY_F hier1
, PER_ALL_ASSIGNMENTS_M asg
, PER_ALL_ASSIGNMENTS_M asg1
WHERE
TRUNC(SYSDATE) BETWEEN hier.effective_start_date AND hier.effective_end_date
AND hier.position_id = asg.position_id
AND TRUNC(SYSDATE) BETWEEN asg.effective_start_date AND asg.effective_end_date
AND asg.assignment_status_type = 'ACTIVE'
AND asg1.assignment_type = 'E'

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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