查詢 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 要重新啟動才會生效