Query to find responsibility assigned to user

Query to find responsibility assigned to user

In this post , We will be discussing about query to find responsibility assigned to user. This Query will help to extract the list of User account having detail responsibility information’s. We will get the complete user responsibility data using this sql query in oracle apps r12.  This query will only extract the active users account having responsibility in r12. Please find below the Important tables for the sql query and the detail query to find responsibility assigned to user.

Most Important Tables used by query to find responsibility assigned to user

1.fnd_user_resp_groups_direct  

2.fnd_user

3.fnd_responsibility_tl

4.fnd_responsibility

5.fnd_application_tl

6.fnd_application            

Detail SQL query to find responsibility assigned to user

SELECT fu.user_name               ,

       frt.responsibility_name   ,

       furg.start_date           ,

       furg.end_date           ,      

       fr.responsibility_key      ,

       fa.application_short_name 

  FROM fnd_user_resp_groups_direct        furg,

       applsys.fnd_user                   fu,

       applsys.fnd_responsibility_tl      frt,

       applsys.fnd_responsibility         fr,

       applsys.fnd_application_tl         fat,

       applsys.fnd_application            fa

 WHERE furg.user_id             =  fu.user_id

   AND furg.responsibility_id   =  frt.responsibility_id

   AND fr.responsibility_id     =  frt.responsibility_id

   AND fa.application_id        =  fat.application_id

   AND fr.application_id        =  fat.application_id

     AND FU.END_DATE is null

   and furg.END_DATE is null

Click To Know More