Home » Applications » Oracle Fusion Apps & E-Business Suite » Logon and logoff time and responsibility used (Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production)
Logon and logoff time and responsibility used [message #585934] Fri, 31 May 2013 02:27
bhawnakaamra
Messages: 66
Registered: March 2013
Location: delhi
Member
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, 
       fu.last_logon_date, 
       fu.user_name, 
       fur.responsibility_id, 
       fr.responsibility_name 
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 ) 
                                   , 
                                   sysdate) 
                                                              ) 
       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

Bhawna

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


Current Time: Thu Mar 28 06:31:38 CDT 2024