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


/ Published in: PL/SQL
Save to your folder(s)

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


Copy this code and paste it in your HTML
  1. SELECT r.responsibility_name,r.responsibility_key, fa.APPLICATION_SHORT_NAME, r.version, u.user_name, u.description, ur.start_date, ur.end_date
  2. FROM apps_fnd.fnd_user_v u,
  3. apps_fnd.fnd_user_resp_groups_direct ur,
  4. fnd_responsibility_vl r,
  5. fnd_application_tl a,
  6. fnd_application fa
  7. ur .responsibility_id = r.responsibility_id
  8. AND u.user_id = ur.user_id
  9. AND fa.APPLICATION_ID = a.APPLICATION_ID
  10. AND r.application_id = a.application_id
  11. AND ( u.user_name = UPPER (:user_name) OR UPPER(u.description) LIKE UPPER('%'||:user_name||'%'))
  12. ORDER BY 5,3,2,1;

URL: http://forums.oracle.com/forums/thread.jspa?threadID=953780

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.