Custom data security profile - Not selecting future dated rows
Summary
Custom data security profile - Not selecting future dated rowsContent
Hi All,
I really need some help on the below. I created new person data security profile. For test purpose, I created one current date, Future dated persons and tried to preview the data. My custom person data profile is not returning the future dated rows. Could you please advise?
I used the below command.
&TABLE_ALIAS.PERSON_ID IN (select b.person_id from per_all_assignments_m b where b.person_id in (300000016961874,300000016964172))
The SQL Predicate for Person Access as shown below.
EXISTS ((SELECT 1 from PER_PERSONS P WHERE P.PERSON_ID=&TABLE_ALIAS.PERSON_ID AND ( P.PERSON_ID=(SELECT NVL(HRC_SESSION_UTIL.GET_USER_PERSONID,-1) FROM DUAL) OR (( P.PERSON_ID IS NOT NULL AND ( P.PERSON_ID IN (select b.person_id from per_all_assignments_m b where b.person_id in (300000016961874,300000016964172)) ) ))))UNION ALL SELECT 1 FROM PER_SHARE_INFORMATION SI WHERE SI.GRANTEE_PERSON_ID = (SELECT NVL(HRC_SESSION_UTIL.GET_USER_PERSONID,-1) FROM DUAL) AND SI.PERSON_ID = &TABLE_ALIAS.PERSON_ID )