Wednesday, February 27, 2013

Responsibility: Menu Exclusion


This query can give details of a Oracle Application Responsibility and list of menus and functions that are excluded from that responsibility.

6 comments:

  1. This apparently filters out the responsibilities that does not have menu exclusions. Is it possible to modify the sql to show all responsibilities irrespective of exclusions.

    Srikanth

    ReplyDelete
    Replies
    1. if you remove table "apps.fnd_resp_functions" from the above query, you should get all the responsibilities.

      Delete
    2. Don't remove the table but do outer joins so that you get those resps which does not have any menus

      Delete
  2. Is there a sql that show only the exclusions?

    ReplyDelete
  3. HI Sanjai ,

    how to add one menu under menu exclusion at bulk responsibilitys at a time ,any update script is there ?

    ReplyDelete