In order to find all responsibilities attached to a user you need to fire following query. However, you can directly see them if you have access to System Administrator responsibility in Oracle E-Business Suite. Thanks for stopping by at OracleMine.

Query user granted roles : Roles « User Privilege « Oracle PL/SQL Tutorial

Speaking about my brief introduction, I work for a multinational organisation in Oracle related technologies. Being an avid blogger, I would like to inform you about my productivity and motivational blog XpressPlanet. Speaking of OracleMine. You can also contribute your knowledge on OracleMine by writing to us at hioraclemine gmail. Again I appreciate your visit. Hope to see you again and again! Your email address will not be published.

Yes, add me to your mailing list. Notify me of follow-up comments by email.

User and responsibility Query

Notify me of new posts by email. This site uses Akismet to reduce spam. Learn how your comment data is processed. Skip to content. We highly appreciate comments and feedback. Paras Shah. Hi I am Paras. Like this: Like Loading Leave a Reply Cancel reply Your email address will not be published.With Non-Technical background, having hard time in resolving this.

In Excel:. This query successfully retrieves all the rows where the menu prompt is not null. I was also interested in extracting the menus that have their prompts set to NULL but existent in the tree. Did you get a reply regarding this? Even I am looking for same kind of query. If you have, please send to me or post here.

I think you're looking for something like the following: This combines the menus and its appropriate Functions in a stepped representation.

sql query for user and responsibilities oracle

This query gives me an error: ORA single-row subquery returns more than one row. I see my in my reply the concatenation symbols in the 1st 3 lines were removed for some reason WHERE menu2.

David S. You can use this tab to get a list of all users that have access to a given function like Enter Journals and you can export the results into an Excel worksheet. Perfect for security audits.

Some name 5. Tech Sign In Page. Forgot Password? Don't have an account? Sign up. Some name. Some name 22k Followers. Some name 13k Followers. Your suggestions are really appreciated! Follow Tech Sign In Page. August 29, AM. Something went wrong on our end. Please try again later. Hi, This query successfully retrieves all the rows where the menu prompt is not null. Any help will be greatly appreciated. Thanks, Andy. Anand Kand.Register and Participate in Oracle's online communities. Learn from thousand of experts, get answers to your questions and share knowledge with peers.

Error: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Welcome to Oracle Communities. Please enter a title. You can not post a blank message. Please type your message and try again. This discussion is archived. Ok, I've searched all over this place and I can't quite get what I want.

I can get all responsibilities with a given function, and I can get all responsibilities with a given menu, but I can't get all responsibilities with a given SUBmenu. Specifically, I'm trying to get all responsibilities that have "Desktop Integration Menu" somewhere in their menu tree, whether it be menu or submenu. All I can do is get the ones where it's the menu i. Can anyone give me some assistance with this query?

It's driving me nuts. Below is the SQL query as it stands now. I have the same question Show 1 Likes 1. This content has been marked as final. Show 1 reply. Please see these docs. Re: Currently working on Internal Technical Audit and we have been asked to provide list of Responsibilities and Roles.The purpose of this blogis to do Knowledge sharing with my Followers through my own Experiences. Do your commentsfeedback and your suggestions to keep this going.

Please Check oracleappstechnical. Thank you for sharing your thoughts and knowledge on this topic. This is really helpful and informative, as this gave me more insight to create more ideas and solutions for my plan.

sql query for user and responsibilities oracle

I would love to see more updates from you. Web Development. Magnificent blog I visit this blog it's extremely wonderful. Interestingly, in this blog content composed plainly and reasonable. The substance of data is useful.

sql query for user and responsibilities oracle

Very interesting blog I would like to thank you for the efforts you have made in writing this article. I am hoping the same best work from you in the future as well.

Excellent blog I visit this blog it's really awesome. The important thing is that in this blog content written clearly and understandable. The content of information is very informative. Thank you for sharing such a nice and interesting blog with us. I have seen that all will say the same thing repeatedly. But in your blog, I had a chance to get some useful and unique information.

I would like to thank you for the efforts you have made in writing this article. Awesome post. Thank you for sharing such a nice and interesting blog. Oracle Fusion Financials Online Training. Post a Comment. In CloudWe create Roles and attach these roles to user account to access the oracle Cloud application.The purpose of this blogis to do Knowledge sharing with my Followers through my own Experiences.

Do your commentsfeedback and your suggestions to keep this going. Post a Comment. Wednesday, 8 April Query to get list of responsibilities for a user in oracle apps.

sql query for user and responsibilities oracle

Query to get list of responsibilities for a user in oracle apps In this postWe will be discuss about Query to get list of responsibilities for a user in oracle apps. This query will help to extract the list of responsibility for a user in oracle apps.

We will get the complete details of responsibility for a user in oracle apps r This is one of the important sql query to fetch the list of responsibilities for a user in oracle apps. Query to get list of responsibilities for a user in oracle apps. Newer Post Older Post Home. Query to get accounted ar invoices in oracle apps api to create supplier bank account in r12 how to find source system id in Oracle Fusion How to find source system owner in fusion hcm Create lov using oaf personalization How to submit request set from backend in oracle a Difference between request set and request group i Query to find profile option values at user and re Query to find security profile attached to respons Query to get request group for responsibility SQL query to find concurrent program attached to r How to hold concurrent program in oracle apps from Query to find concurrent request details Query to check concurrent program assigned to conc Query to find function attached to menu in oracle Query to get menu and submenu in oracle apps Active users and their active responsibilities ora Query to find active responsibilities in oracle ap Query to get list of responsibilities for a user i Assign responsibility to multiple user in oracle a How to create user in oracle apps from backend How to check last dml statement executed on a tabl How to find ddl changes in oracle How to find last ddl on a table in oracle How to find the last modified date of a table in o How to find who updated a table in oracle SQL query to retrieve users last login date in ora Supplier Audit table in oracle fusion Sales order attachments in oracle apps query Query to find po attachments in oracle apps fnd attachments tables in oracle apps Query to find Concurrent request history Concurrent program last run date query Query to find incompatible program of a concurrent Query to find long running concurrent request in o Query to find child concurrent requests Query to find pending concurrent requests Query to find concurrent requests on hold Query to find concurrent requests submitted by a p Query to find concurrent program run time Query to get concurrent program run details in ora Query to get request set run details Query to get concurrent program schedule details Query to find parameters of a concurrent request Query to check concurrent request status from back Query to find the concurrent program details with Query to find concurrent program short name in ora Query to find responsibility assigned to user in oWith the help of below query, a programmer can find concurrent program responsibilities attached to it in Oracle E-Business Suite.

Mention the topics of queries in comments you think will be handy and available in a single page. Thanks for stopping by at OracleMine. Speaking about my brief introduction, I work for a multinational organisation in Oracle related technologies. Being an avid blogger, I would like to inform you about my productivity and motivational blog XpressPlanet.

Speaking of OracleMine. You can also contribute your knowledge on OracleMine by writing to us at hioraclemine gmail. Again I appreciate your visit. Hope to see you again and again! Your email address will not be published. Yes, add me to your mailing list.

SQL Query To Get ALL The Responsibilities And Attached Functions With Them

Notify me of follow-up comments by email. Notify me of new posts by email. This site uses Akismet to reduce spam. Learn how your comment data is processed. Skip to content. I hope you like the page and find it useful. We highly appreciate comments and feedback. Paras Shah. Hi I am Paras. Like this: Like Loading Leave a Reply Cancel reply Your email address will not be published.Register and Participate in Oracle's online communities. Learn from thousand of experts, get answers to your questions and share knowledge with peers.

Error: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Welcome to Oracle Communities.

Please enter a title. You can not post a blank message. Please type your message and try again. This discussion is archived. Does anyone have a SQL query for r12 to list all responsibilities assigned to all users? Would prefer a query as opposed to a report. This content has been marked as final. Show 4 replies. Hi; Please review: responsibilities-List all responsibilities List all responsibilities Regard Helios. I dont want to limit it by username, I want one single report of all users and all responsibilities assigned to all users.

From what I understand if I went down the users of a responsibility report, and we had 50 responsibilities, thats 50 reports we'd have to run which would take forever.

Join the world’s largest interactive community dedicated to Oracle technologies.

Run "Active Users" concurrent program. Thanks, Hussein. Go to original post.