This content has been marked as final. Show 5 replies
Resolved this - One cannot see self's employee record in the form for which this is setup.
Hence the below query though correct in syntax did not show any data.
PERSON.PERSON_ID = FND_GLOBAL.EMPLOYEE_ID
My original requirement was that all employees belonging to one's Organization should be displayed, and this is working fine with an updated query for the same.
Result showing up, but inconsistently
But the result appearing is inconsistent.
It appears correctly in my desktop.
But when logged in using same user name in different desktop its not working based on the query - all data gets displayed
Is there any cache issue?
Try running the Security List Maintenance job check the results. Have this job scheduled in background.
But I've given custom option as 'Restrict the people visible to each user using this profile' with fnd_global.employee_id.
The eligible list gets filled in when user logs on; though i've run PERSLM which hasnt helped.