• Skip to main content
  • Skip to primary sidebar

John 3:30

He Must Increase, I Must Decrease

  • Evangelism Schedule
  • Preaching and Sermons
  • Links
    • OUTREACH GUIDELINES
    • MY TESTIMONY
    • SUPPORT THE MINISTRY
    • THE GOSPEL
    • CONTACT
  • Posts by Category
    • Open Air Preaching
    • Theology
    • Witnessing
    • Just me
    • Memory Verses
    • Creation
    • Movie Reviews
    • Love

How to find which responsibility can run a request in Oracle Apps.

June 10, 2011 by Michael Coughlin

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.

Filed Under: Just me, Technical Tagged With: Oracle

Reader Interactions

Comments

  1. BMJ says

    June 23, 2011 at 3:56 pm

    thanks, this was quite helpful!

  2. Michael says

    June 29, 2011 at 3:44 pm

    You’re welcome!

  3. Mark says

    September 2, 2011 at 4:12 pm

    Awesome. Just what I was looking for.

  4. praveen says

    May 15, 2013 at 2:30 am

    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.

    • Michael says

      May 15, 2013 at 6:06 am

      Praveen – can you send me an error message or can you post the SQL you are running?

  5. RG says

    June 1, 2013 at 8:41 pm

    I love it!!!

  6. Ahmed says

    July 2, 2013 at 4:10 am

    Thanks Just the code I was looking for. Very Helpful

  7. Jamie says

    September 8, 2014 at 5:39 am

    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.

  8. Ed says

    May 20, 2015 at 1:19 pm

    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.

    • Michael says

      May 20, 2015 at 1:29 pm

      Good point, Ed.

Primary Sidebar

My Budgeting App

You Need A Budget

The Bible Memory App I Use

The Bible Memory App - Bible Memory Verses

Recent Posts

  • ESV Preaching Bible, Black Goatskin Leather for Sale
  • More Lies and Clickbait Instead of Reporting Facts About Ohio Protests
  • Stimulating Your Thoughts About the Stimulus
  • Evangelism Schedule
  • New Podcast

Tags

2018 OSU abortion Adam apologetics attributes of God Bible catholicism Christ church Courageous Creation discipline end times evangelism Forgiveness glory gluttony God Gospel Grace Hollywood Holy humility Jesus Joy leadership logic Love Mercy Movies Ohio State Open Air Oracle people power prayer preaching pride programming Righteous savior Scripture self-control sin witchcraft

Recent Comments

  • Rusty on TTUN @ tOSU Ministry Report – Nov 24, 2018
  • A(nother) Surprising Work of God » Things Above Us on Nebraska @ tOSU Ministry Report – Nov 3, 2018
  • Mid-October 2018 Presuppositional Apologetics’ Links | The Domain for Truth on Minnesota @ tOSU Ministry Report – Oct 13, 2018
  • mcoughlin on Indiana @ tOSU Ministry Report – Oct 6, 2018
  • Jeff Mardling on Indiana @ tOSU Ministry Report – Oct 6, 2018

Categories

  • Creation
  • Gospel
  • Just me
  • Love
  • Memory Verses
  • memoryfeedmichael
  • Movie Reviews
  • Open Air Preaching
  • Prayer
  • Technical
  • Theology
  • Uncategorized
  • Witnessing
2018 © MichaelCoughlin.net

Copyright © 2023 · Things Above Us on Genesis Framework · WordPress · Log in