Need to know what form is attached to a responsibility
There is a need to know what responsibility in Oracle has access to a given form. All seeded Oracle Reports that I am aware of (Function Security Function Report, Function Security Menu Report, Function Security Navigator Report) require a responsibility be inputted into a parameter in order to run. This is not a feasible option as we have hundreds of responsibilities and we would need to manually review each output for a specific function or form. Does a report or other SQL exist where I do not have to specify a responsibility?
I have attempted different ways for a custom sql but the difficulty always lies in the exclusions because you need to look in every single menu that has been excluded whether or not a function is attached (need to look at all the submenus). This is difficult because you need to go down the entire menu tree of each excluded menu and I haven't been able to do this.