Oracle Apps: Query to fetch Responsibility associated with Function

SELECT fr.RESPONSIBILITY_NAME
  FROM fnd_responsibility_vl fr,
       fnd_menus fm,
       fnd_compiled_menu_functions fmf,
       fnd_form_functions_vl ff
 WHERE fr.menu_id = fm.menu_id
   AND ff.function_id = fmf.function_id
   AND fmf.menu_id = fm.menu_id
   AND ff.user_function_name = :function_name
   AND nvl(fr.end_date,trunc(sysdate)) >= trunc(sysdate)
   order by responsibility_name

oracleapps

Enable Personalization on OAF Page

Enable following profile options to see Personalization Link for a OAF Page
                                                                                          Value
FND: Personalization Region Link Enabled                   Yes
     
Personalize Self-Service Defn                                          Yes
     
Disable Self-Service Personal                                           No



Tags:
at erp, erp, oracleapps, oracleapps erp, oracle erp, oracle ebusiness, oracle application,   
about oracle, oracle developer