Oracle Activity on FND LOGINS FND USER My client asked me to write a quick SQL to find out the load on the Production system, in terms of User activity. This was required for be broken down by External Logins(iSourcing, Students etc) and Internal Employees. Use the SQL below =============== SELECT COUNT(fl.login_id) count_of_logins ,trunc(fl.start_time) start_date ,COUNT(DISTINCT fl.user_id) count_users ,decode(fu.employee_id ,NULL ,'EXTERNAL' ,'INTERNAL') AS emp_type FROM fnd_user fu, fnd_logins fl WHERE fl.start_time > SYSDATE - 10 AND fl.user_id NOT IN (6, 0, -1) AND fu.user_id = fl.user_id GROUP BY trunc(start_time) ,decode(fu.employee_id ,NULL ,'EXTERNAL' ,'INTERNAL') ORDER BY 2 In fact after running this, I discovered that OAM gives a better breakdown, i.e. it will list the breakdown at Module level. That list will be available from Sitemap Tab, after having logged into OAM ( Oracle Applications Manager ).