1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

r12- system profile values

Discussion in 'Oracle Financials' started by inbarn, Dec 27, 2012.

  1. inbarn

    inbarn Guest

    Hello
    I want to know which user got some profile.
    for example- which users have the Profile Option Name "Session Timeout"?
    thank you
     
  2. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi ,

    Please go through the following query to get the profiles which have been set for user level.

    Code (Text):

    SQL> Select distinct
            FPOT.USER_PROFILE_OPTION_NAME as "USER_PROFILE_OPTION_NAME",
            decode(LEVEL_ID,'10001','Site','10002','Applic ation','10003','Responsibility
             ','10004','User') as "LEVEL",
            FPOV.Profile_option_value as "Value",
            FPO.PROFILE_OPTION_NAME,
            FAT.Application_name as "Application"
            from FND_PROFILE_OPTIONS FPO , FND_PROFILE_OPTIONS_TL
                   FPOT,FND_APPLICATION_TL FAT,FND_PROFILE_OPTION_VALUES FPOV
            where FPO.Application_id=FAT.application_id
               and FPOV.application_id=FAT.Application_id
               and FPOV.profile_option_id = FPO.profile_option_id
               and FPO.profile_option_name = FPOT.profile_option_name
               and level_id = 10004
               AND LEVEL_VALUE  = &User_id;

     
    Here in the above query pass the user id as parameter. By that we can see what are the profiles set and values of those profiles for that user.