This is the blog dedicated to Oracle Applications users. Here I will be posting information on Oracle Application which will have technical, functional and Administration related topics. Although the site may be more beneficial to technial junkies.
Please remember to visit site regularly as it will be updated quite often and do remember to encourage me by posting your valuable comments.
Thanks,
Suresh Vaishya
Based on a request from one of the reader here is the query which he was looking for.
He needed query that can list all the responsibilities attached to a user.
select fu.user_name, fr.responsibility_name, furg.START_DATE, furg.END_DATE
from fnd_user_resp_groups_direct furg, fnd_user fu, fnd_responsibility_tl fr
where fu.user_user_name = :user_name
and furg.user_id = fu.user_id
and furg.responsibility_id = fr.responsibility_id
and fr.language = userenv('LANG')
Posted by Suresh Vaishya at 9:47 AM
Labels: Query, System Administrator
Copyright (c) All rights reserved. Presented by Suresh Vaishya
View Suresh Vaishya's profile
7 Comments:
Hi Suresh,
My requirment is, i want all users information under perticular organization/operating unit
What kind of information are you looking for.
i want all user names under perticular operating unit
Users are not tied at operating unit level. One user can have responsibilities of several operating units. If you follow any nomenclature for naming responsibility by operating unit then may be you can use that in the query to find all users having that responsibility using like condition.
Thanks,
Suresh
HI Suresh,
Thank you for giving information.
I am having one more issue here.
I want to pass multiple values in report parameter.
While running report through SRS window, its possible to select multiple vlaues (from LOV of parameter).its possible ..How..?
You can select multiple values in LOV in discoverer. Through SRS window it is not possible to do that.
Suresh
How to list users having only one responsibility (GL Super User). The query should display those Users having GL Super User Resp, that's all.
Thanks
Uday
Post a Comment