5 Replies Latest reply: May 7, 2013 1:46 AM by sumanth.shenoy RSS

    SQL Query in Custom Security when creating Security Profile

    sumanth.shenoy
      Hello all,

      I've created a security profile with Custom security and provided a simple query in Custom Security tab-
      PERSON.PERSON_ID = FND_GLOBAL.EMPLOYEE_ID

      Custom security option is "Restrict the people visible to each user using this profile"
      I am not able to see the record as expected.

      If I Hardcode the person ID "PERSON.PERSON_ID = 13449" with "Restrict the people visible to each user using this profile", I am able to see the record.

      If I Hardcode the person ID "PERSON.PERSON_ID = 13449" with "Restrict the people visible to this profile", I am able to see the record after running PERSLM and same is in PER_PERSON_LISTS.

      Am I correct in checking with FND_GLOBAL.EMPLOYEE_ID?
      (This was mentioned in system administrator guide :

      "+Oracle HRMS assesses the custom security when the user signs on. In addition, the custom security code can include references to user specific variables, for example, fnd_profile.value() and fnd_global.employee_id.+"

      docs.oracle.com/cd/E18727_01/doc.121/e13509/T2096T2098.htm).

      I have tried with FND_GLOBAL.USER_ID / FND_PROFILE.VALUE('USER_ID') / :ASG_ID (seeded query has a join with this bind variable) - not happening.

      I've given options as below :

      Employees = None
      Contingent Worker = Restricted
      Applicant = None
      Contacts = All
      Candidates = All

      All other options - Defaulted

      Thanks,
      Sumanth