Google+ Tools
Make Google+ profile picture
Make Google plus banners for profile
Create and share your Google Plus profile banners.

Profile image for mrk studios theonlyalterego on May 26, 2011

I found this today and it's very useful for finding the responsibility key when trying ot run OAF from JDev.

Language
PL/SQL
Tags

Oracle Application - List Responsibilities and Responsibility Keys that are assigned to a user


SELECT r.responsibility_key, fa.APPLICATION_SHORT_NAME
    FROM fnd_user u,
         fnd_user_resp_groups ur,
         fnd_responsibility r,
         fnd_application_tl a,
         fnd_application fa
   WHERE     r.version = 'W'
         AND ur.responsibility_id = r.responsibility_id
         AND u.user_id = ur.user_id
         AND fa.APPLICATION_ID = a.APPLICATION_ID
         AND r.application_id = a.application_id
         AND u.user_name = UPPER (:user_name)
ORDER BY 1

Comments

blog comments powered by Disqus