Skip to Main Content

Security Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

User list lookup

User_GLOGRFeb 23 2010 — edited Feb 23 2010
Hi

Is there a way to generate a list of users the admin user of an Organization can see? This would be the same list of users shown if the "Manage User" menu permission was give to the Org admin user

I have a requirement to assign a RO to the users that belong to a certain organization. This task must be initiated by a member of the admin group for that organization. The RO has a field to put in the user ID for the user the RO is being assigned. The problem is populating the users' list the admin user can access. In my case, the admin user belongs to the same organization

I tried with a Lookup field with a query like:
Column Names = usr_key,usr_first_name,usr_last_name
Lookup Column Name = usr_key
Lookup Query = Select usr_key, usr_first_name, usr_last_name from usr //(where act_key=123)
Column Captions = User Key,First Name,Last Name
Column Widths = 10,100,100

I ran into a problem with this approach since I don't know of a way to get the admin user's act_key into the query

thanks
This post has been answered by Rajiv Dewan on Feb 23 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 23 2010
Added on Feb 23 2010
2 comments
716 views