Tuesday, May 19, 2015

Navigation Path for Oracle Form/OAF Page (Query#2)

This is another query, probably slightly better query to find out responsibility and navigation path for a particular Form or OAF Page. This query takes advantage of CONNECT_BY_ROOT to get responsibility associated with top level menu. The other query uses SYS_CONNECT_BY_PATH(menu_id,' --> ') to join with fnd_responsibilities_vl. Although that worked but i am little apprehensive of that kind of trick.

No comments:

Post a Comment