0 Replies Latest reply: Mar 20, 2014 2:27 PM by 2630139 RSS

    How to restrict employees from accessing managers data using custom security profile

    2630139

      Hi,

       

      I am using custom security profile for restricting the employees from accessing supervisors details(PG.SEGMENT2=4). I have written the custom code as below :

      Responsibility :US Super HRMS Manager

       

      ASSIGNMENT.PERSON_ID

      IN

      (SELECT PAF.PERSON_ID FROM PER_ALL_PEOPLE_F PAF,

      PER_ALL_ASSIGNMENTS_F PF,

      PAY_PEOPLE_GROUPS PG,

      PER_PERSON_TYPE_USAGES_F PPU,

      FND_USER FNU

      WHERE PAF.PERSON_ID=PF.PERSON_ID

      AND :EFFECTIVE_DATE BETWEEN PAF.EFFECTIVE_START_DATE

      AND PAF.EFFECTIVE_END_DATE

      AND PF.PEOPLE_GROUP_ID=PG.PEOPLE_GROUP_ID

      AND :EFFECTIVE_DATE BETWEEN PF.EFFECTIVE_START_DATE AND PF.EFFECTIVE_END_DATE

      AND PPU.PERSON_ID=PAF.PERSON_ID

      AND PPU.PERSON_ID=PF.PERSON_ID

      AND :EFFECTIVE_DATE BETWEEN PPU.EFFECTIVE_START_daTE AND PPU.EFFECTIVE_END_DATE

      AND PAF.PERSON_ID=FNU.EMPLOYEE_ID

      AND PAF.PERSON_TYPE_ID =2

      AND PPU.PERSON_TYPE_ID

      IN(2,62)

      and PAF.person_id = FND_PROFILE.value('user_id')

      AND PG.SEGMENT2=8)

       

       

      and using "restrict the people visible to each other using this profile".

       

      I have assigned the security profile to HR user responsibility

      But when I query the supervisor name in HR User responsibility , it is not restricting me from viewing supervisor details.

      When I query for first time, its restricting me to view others details, but when I close that click on torch button and try searching, its allowing me to access manages details.

       

      Can any one please let me know what setups need to be done for restricting employees from viewing supervisors data.

       

       

      I have gone through the document "Understanding and Using HRMS Security in Oracle HRMS" but didn't got any idea.

      Please suggest.

       

       

      Thanks & Regards,

      Anusha.