Oracle Apps User List

[Novice]

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.

[Sadik]

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.

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.

[Sadik]

PER_PEOPLE_F will give a complete list of users with first name, lastname and fullname

[rtagarra]

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'.

[Sandy270783]

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