Home » Applications » Oracle Fusion Apps & E-Business Suite » Responsibilities (System Administrator)
Responsibilities [message #432157] Sun, 22 November 2009 05:28 Go to next message
Messages: 1
Registered: November 2009
Junior Member
We are assigning responsibilities to the users. Can we able to know does the user is using the responsibilities. I need a query to find is he using the assigned responsibility. Can anyone please send me the query.


Thanks in advance,

Re: Responsibilities [message #432332 is a reply to message #432157] Mon, 23 November 2009 10:41 Go to previous message
Messages: 19
Registered: March 2009
Junior Member
Try this SQL

       SELECT user_id, user_name, NAME, responsibility_name, responsibility_id,
              application_id, last_resp_accessed, creation_date
       FROM  ( SELECT fu.user_id, fu.user_name, NVL (fu.description, papf.full_name) NAME,
                      frt.responsibility_name, furgd.creation_date,
                      frt.responsibility_id, frt.application_id,
                      (SELECT NVL (TRUNC (MAX (sess.creation_date)),
                                  '01-JAN-1900' ) login_date
                       FROM   icx_sessions sess
                       WHERE  fu.user_id = sess.user_id
                       AND    sess.responsibility_id = fr.responsibility_id) last_resp_accessed
               FROM  fnd_responsibility_tl frt,
                     fnd_responsibility fr,
                     fnd_user fu,
                     fnd_user_resp_groups_direct furgd,
                     per_all_people_f papf
               WHERE frt.responsibility_id = fr.responsibility_id
               AND   fr.application_id = frt.application_id
               AND   frt.responsibility_id = furgd.responsibility_id
               AND   fu.user_id = furgd.user_id
               AND   fu.user_name = papf.employee_number
               AND   (fu.end_date IS NULL OR fu.end_date > SYSDATE)
               AND   (furgd.end_date IS NULL OR furgd.end_date > SYSDATE))
       WHERE LAST_RESP_ACCESSED < SYSDATE - :No_of_Days_user_did_not_Access

Though the above SQL may not give you the exact picture about the system, as there may be users who never log in to the application, but will use e-mail to approve PO's and Invoices.

[Updated on: Mon, 23 November 2009 10:45]

Report message to a moderator

Previous Topic: Window7 (IE8) + + JInitiator
Next Topic: Oracle EAM ERD Technical mapping reference
Goto Forum:

Current Time: Sun Jul 23 22:25:39 CDT 2017

Total time taken to generate the page: 0.08752 seconds