Thursday 2 April 2015

EBS : List of users who logged in to EBS application in last 14 days

SELECT DISTINCT user_name,  
  TO_CHAR(last_logon_date,'DD-MON-YYYY HH24:MI:SS') LAST_LOGIN_DATE,
  papf.full_name,
  (select name from hr_organization_units where organization_id = paaf.ORGANIZATION_ID) department_name
FROM fnd_user fu, per_all_people_f papf,per_all_assignments_f paaf
WHERE last_logon_date >=sysdate-14
--and fu.user_name like 'H%'
and paaf.person_id = fu.employee_id
and paaf.person_id = papf.person_id
order by 4,2,1 desc

No comments:

Post a Comment

Oracle : Database Startup Time

 Oracle Instance Startup Time SET LINES 2000 SET PAGES 9999 COLUMN INSTANCE_NAME FOR A20 SELECT     instance_name,     to_char(startup_time,...