查詢 Oacle Form 使用記錄

開啟 Oracle EBS 表單使用紀錄，且從DB查詢資料

SELECT ff.form_name,
       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 = 'XXOMF005'
   AND fl.start_time = TO_DATE('20110101', '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;

Notice:

需要將 profile: Sign-On:Audit Level 設成為 FORM , FND_LOGIN_RESP_FORMS 才會有資料
修改 profile Oracle AP 要重新啟動才會生效