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!

FND_PROFILE.value(USER_id)

Discussion in 'Oracle Forms and Reports' started by vamsioracle, Aug 30, 2009.

  1. vamsioracle

    vamsioracle Forum Expert

    Messages:
    98
    Likes Received:
    1
    Trophy Points:
    140
    Hi

    What does fnd_profile.value(user_id) return back, in terms of HRMS table values. I mean, is it person_id from perr_all_people_f, or employee_number.

    How can we relate the output of fnd_profile.value(user-id) to per_all_people_f or per_all_assignments_f tables.


    vamsi
     
  2. apps_expert

    apps_expert Forum Expert

    Messages:
    325
    Likes Received:
    28
    Trophy Points:
    330
    Location:
    Chennai, India
    hi the user_id that FND_PROFILE.value(USER_id) will return is present in fnd_user. fnd_user also has employee_id for those users who are also employees. This employee_id you can use to join with your PER tables.