Getting user information

In this forum Oracle Applications DBA's, System Administrators & Developers can share their knowledge/issues.
Post Reply
hamid
Posts: 8
Joined: Fri Jun 15, 2007 2:11 am
Location: Pakistan

Getting user information

Post by hamid »

AOA

i create lot of users i want there name

any one help me in which table it was store.

how can i access all these user name
gmohan
Posts: 13
Joined: Sat Jul 07, 2007 9:18 am
Location: India

Post by gmohan »

hi

Please query up with fnd_user table
I believe this is your expectation

Thanks
Mohan
hamid
Posts: 8
Joined: Fri Jun 15, 2007 2:11 am
Location: Pakistan

Post by hamid »

in which user account this table exit

i check in system acount but it give me error table does not exist
sudhir
Posts: 31
Joined: Sun Sep 02, 2007 9:19 am
Location: Oman

Post by sudhir »

hi

Please query up with fnd_user table
I believe this is your expectation

Thanks
Mohan

<i><div align="right">Originally posted by gmohan - Nov 06 2007 : 02:45:55 AM</div id="right"></i>
hi try this query, this will give you the employee name and responsibilities attached:

select f1.FULL_NAME Employee_Name,f2.USER_NAME User_Name,f4.RESPONSIBILITY_NAME Resp_Name
from per_all_people_f f1,
fnd_user f2,
FND_USER_RESP_GROUPS_DIRECT f3,
FND_RESPONSIBILITY_VL f4
where f1.PERSON_ID = f2.EMPLOYEE_ID
and f2.USER_ID = f3.USER_ID
and f3.RESPONSIBILITY_ID = f4.RESPONSIBILITY_ID
and f2.USER_NAME like '%'

(enter the user name if being specific)
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests