Oracle eBS經驗分享

首先，確認你的Profile設定是否是設在Form Level

可使用下列SQL查詢紀錄 

 SELECT   fu.user_name,
              he.full_name,
              fl.start_time,
              fl.end_time,
              fl.pid,
              fl.spid
     FROM fnd_login_resp_forms flrf,
         fnd_logins fl,
         fnd_form ff,
         fnd_user fu,
         hr_employees he
   WHERE ff.form_name = 'ARXAIEXP'
     AND fl.start_time >= TO_DATE ( '20070829', 'yyyymmdd' )
     AND fu.user_id = fl.user_id
     AND flrf.login_id = fl.login_id
     AND ff.form_id = flrf.form_id
     AND he.employee_id(+) = fu.employee_id
ORDER BY start_time;