/ Oracle EBS

PL SQL 呼叫 concurrent

注意重點:
1. 由開發工具, ex. toad、pl sql developer 呼叫 concurrent 時, 需要定義 fnd_global.apps_initialize

2. concurrent 引用參數, 除固定宣告用的五個參數之外, 可額外接收 100 個參數, 結束時必須要用 chr (0) 來終止, 否則後續參數無法接受時, 會有錯誤訊息

(閱讀全文…)

Continue Reading
/ Windows

更新完Windows 7後不必重開機

[轉貼]更新完Windows 7後不必重開機

想要解決Windows的bug及漏洞，一定要勤於線上更新系統檔案，但是有時更新之後會要求你一定要重新開機，更新後的系統元件才會生效。

雖然可以延後重新開機對話盒的跳出時間，但是有時明明就正在工作無法關機，偏偏一段時間就要提醒你重開機一次，真的很煩！

其實在Windows 7中，可以完全關閉Windows Update以後需要重新開機的窘境，讓你一路順暢地把該做的工作做完，再從容的重新啟動電腦喔～～

(閱讀全文…)

Continue Reading
/ Oracle EBS

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

/ Oracle EBS

監控 concurrent異常記錄

監控 Concurrent 異常記錄

SELECT TO_CHAR(r.request_id) req_id,
       DECODE(r.status_code, 'E', 'Error', 'Warning') status,
       SUBSTR(pt.user_concurrent_program_name, 1, 30) program_name,
       TO_CHAR(r.actual_start_date, 'yyyy/mm/dd hh24:mi') start_date,
       TO_CHAR(r.actual_completion_date, 'yyyy/mm/dd hh24:mi') end_date,
       (SELECT UPPER(host_name) FROM v$instance) host_name
  INTO &request_id,
       &status,
       &concurrent_name,
       &start_date,
       &comp_date,
       &host_name
  FROM fnd_concurrent_requests r, fnd_concurrent_programs_tl pt
 WHERE (r.status_code = 'G' OR r.status_code = 'E')
   AND (r.actual_start_date < SYSDATE - 1 / 2 OR
       r.actual_completion_date < SYSDATE - 1 / 2)
   AND (SELECT COUNT(r.status_code) err_cnt
          FROM fnd_concurrent_requests r
         WHERE (r.status_code = 'G' OR r.status_code = 'E')
           AND (r.actual_start_date < SYSDATE - 1 / 2 OR
               r.actual_completion_date < SYSDATE - 1 / 2)) < 2
   AND pt.concurrent_program_id = r.concurrent_program_id
   AND pt.application_id = r.program_application_id
 ORDER BY request_id DESC