Security Profile- Custom Criteria help needed — 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

Security Profile- Custom Criteria help needed

edited Dec 16, 2014 10:26AM in Human Capital Management 7 comments

Content

Hello,

we have to use the custom criteria ('person security profile') in order to restrict the user from seeing employees who have grade >= 70. The code I have is preventing from the user to see future hire dates. I tried to change its still not working. if someone can assist writing the code better in order to fix the issue with future hire dates?

very appreciate!

The code:

&TABLE_ALIAS.PERSON_ID IN(
 SELECT  DISTINCT ASG.PERSON_ID FROM FUSION.PER_ALL_ASSIGNMENTS_M ASG
   WHERE (ASG.ASSIGNMENT_TYPE = 'E' OR ASG.ASSIGNMENT_TYPE = 'C')
  AND TRUNC(SYSDATE) BETWEEN ASG.EFFECTIVE_START_DATE AND ASG.EFFECTIVE_END_DATE

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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