Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Custom data security profile - Not selecting future dated rows — Cloud Customer Connect
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

Custom data security profile - Not selecting future dated rows

Received Response
25
Views
4
Comments
edited Jul 9, 2020 10:02PM in Applications Security 4 comments

Summary

Custom data security profile - Not selecting future dated rows

Content

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 )

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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