If this article doesn’t help you, consider dropping me a note with your concern. I have thousands of lines of code for hundreds of Oracle problems I’ve faced and would publish ones that people told me would be helpful.
How many times have you been told by Oracle Support that you should run a concurrent request…only to realize that you have no idea which responsibility to choose to run the request? Or you want to instruct a user to run a request, and you want to be sure they have access?
The query below will help you. It will provide for you the responsibility name and the request group name which can run a concurrent program. You can search by the user_concurrent_program_name or the “short_name”.
SELECT FRT.RESPONSIBILITY_NAME, FRG.REQUEST_GROUP_NAME, FRG.DESCRIPTION FROM FND_REQUEST_GROUPS FRG ,FND_REQUEST_GROUP_UNITS FRGU ,FND_CONCURRENT_PROGRAMS FCP ,FND_CONCURRENT_PROGRAMS_TL FCPT ,FND_RESPONSIBILITY_TL FRT ,FND_RESPONSIBILITY FR WHERE FRGU.UNIT_APPLICATION_ID = FCP.APPLICATION_ID AND FRGU.REQUEST_UNIT_ID = FCP.CONCURRENT_PROGRAM_ID AND FRG.REQUEST_GROUP_ID = FRGU.REQUEST_GROUP_ID AND FRG.APPLICATION_ID = FRGU.APPLICATION_ID AND FCPT.SOURCE_LANG = USERENV('LANG') AND FCP.APPLICATION_ID = FCPT.APPLICATION_ID AND FCP.CONCURRENT_PROGRAM_ID = FCPT.CONCURRENT_PROGRAM_ID AND FR.APPLICATION_ID = FRT.APPLICATION_ID AND FR.RESPONSIBILITY_ID = FRT.RESPONSIBILITY_ID AND FRT.SOURCE_LANG = USERENV('LANG') AND FR.REQUEST_GROUP_ID = FRG.REQUEST_GROUP_ID AND FR.APPLICATION_ID = FRG.APPLICATION_ID -- AND FCP.CONCURRENT_PROGRAM_NAME = 'OPMTMOPG' -- YOU CAN PUT THE SHORTNAME HERE AND FCPT.USER_CONCURRENT_PROGRAM_NAME LIKE 'Purge OPM Txns and Move Order Lines' --OR THE USER CONC PROGRAM NAME HERE ;
If this article doesn’t help you, consider dropping me a note with your concern. I have thousands of lines of code for hundreds of Oracle problems I’ve faced and would publish ones that people told me would be helpful.
thanks, this was quite helpful!
You’re welcome!
Awesome. Just what I was looking for.
This script is not working for me.
I am a APPS DBA and even for any request, i m not able to find the results from this query.
Praveen – can you send me an error message or can you post the SQL you are running?
I love it!!!
Thanks Just the code I was looking for. Very Helpful
Cheers. This sorted my issue.
Somebody had removed the sought-after program from FND_REQUEST_GROUP_UNITS (using The Responsibility Requests Form).
Devious change, exposed by useful SQL.
Mostly helpful. Noticed however that it does not take into account request groups that are assigned through a menu item rather than directly to the responsibility. For example, Accounting request group used in Receivables Manager.
Good point, Ed.