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!

Oracle Apps User List

Discussion in 'Oracle HRMS & Payroll' started by Novice, Oct 28, 2008.

  1. Novice

    Novice Guest

    Is it possible to generate a list of users from Oracle apps 11i.

    I have very limited experience of the application but have been asked to generate a list for the purposes of a SOX audit.

    Any help is appreciated.

    Best regards,
    Nov.
     
  2. Sadik

    Sadik Community Moderator Forum Guru

    Messages:
    1,906
    Likes Received:
    252
    Trophy Points:
    1,455
    Do you mean is there a report or u want to know about a table?

    you can look at PER_ALL_PEOPLE_F table or PER_PEOPLE_F view. I can give you a more detailed answer tomorrow from office.
     
  3. Sadik

    Sadik Community Moderator Forum Guru

    Messages:
    1,906
    Likes Received:
    252
    Trophy Points:
    1,455
    PER_PEOPLE_F will give a complete list of users with first name, lastname and fullname
     
  4. rtagarra

    rtagarra Active Member

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    75
    i think u want to get list of apps user ie from fnd_user....if so there is already a seeded concurrent program something like 'Active user'.
     
  5. Sandy270783

    Sandy270783 Active Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    55
    Option1:
    Go to the resposibility: System Administrator
    Run the request : 'Active Uses'
    Option 2:
    write the following query:
    select * from fnd_user

    If you want to know basic details of ur users then write:

    select papf.employee_number,papf.full_name
    from per_all_people_f papf,fnd_user fu
    where papf.person_id=fu.employee_id
    and trunc(sysdate) between papf.effective_start_date and papf.effective_end_date

    Sandy