Home » Applications » Oracle Fusion Apps & E-Business Suite » Logon and logoff time and responsibility used (Oracle Database 11g Enterprise Edition Release - 64bit Production)
Logon and logoff time and responsibility used [message #585934] Fri, 31 May 2013 02:27
Messages: 66
Registered: March 2013
Location: delhi
Hello All,

I have Prod Instance .on which i want to make query to find out the logon and logoff time of the particular user ,Assume Devteam's(user name) logon logoff time and want to know the responsibility that is widely used by that user.

by using

SELECT fu.user_id, 
FROM   fnd_user fu, 
       fnd_user_resp_groups fur, 
       fnd_responsibility_vl fr 
WHERE  fu.user_id = fur.user_id 
       AND fr.application_id = fur.responsibility_application_id 
       AND fr.responsibility_id = fur.responsibility_id 
       AND Trunc (sysdate) BETWEEN Trunc (fr.start_date) AND 
                                   Trunc (Nvl (( 
                                   fr.end_date - 1 
                                               ), sysdate)) 
       AND Trunc (sysdate) BETWEEN Trunc (fur.start_date) AND Trunc ( 
                                   Nvl (( 
                                                              fur.end_date - 1 ) 
       AND user_name LIKE 'USHETTY' --- for all user or for particular user 
--AND fur.responsibility_application_id = 155 ?- Check particular resp. 
ORDER  BY user_name  

I am able to find the user id and responsibilty assigned and last logon time.but i want to find the logon and logoff both time for particular months.and also want to know which user is active on which responsibily most.

I am in deillema.

Please help


Previous Topic: P_MODE="USER" in Form Function
Next Topic: Prompt heading problem...
Goto Forum:

Current Time: Tue May 18 00:51:09 CDT 2021