Chuck Oracle Engineer

測試Oracle EBS 11.5.10 Alert message 功能

掛好 Alert message並執行 Check後出現下列訊息

Log

Output

 

1.經過確認後好像是少了些 Patch

查詢 ATG版本確認是否適用 Alert message 功能

SET HEAD OFF LINES 120 PAGES 100
 COL p_num FORMAT A65
 COL bug_number FORMAT A10
 COL patch_name FORMAT A10

SELECT bug_number,
       DECODE(bug_number,
              '3438354', '11i.ATG_PF.H',
              '4017300', '11i.ATG_PF.H.RUP1',
              '4125550', '11i.ATG_PF.H.RUP2',
              '4334965', '11i.ATG_PF.H RUP3',
              '4676589', '11i.ATG_PF.H RUP4',
              '5382500', '11i.ATG_PF.H RUP5 HELP',
              '5473858', '11i.ATG_PF.H.5',
              '5674941', '11i.ATG_PF.H RUP5 SSO Integrat',
              '5903765', '11i.ATG_PF.H RUP6',
              '6117031', '11i.ATG_PF.H RUP6 SSO 10g Integration',
              '6330890', '11i.ATG_PF.H RUP6 HELP',
              '6241631', '11i.ATG_PH.H RUP7') p_num,
       last_update_date
  FROM ad_bugs
 WHERE bug_number IN ('3438354', '4017300', '4125550', '4334965', '4676589',
                      '5382500', '5473858', '5674941', '5903765', '6117031',
                      '6330890', '6241631');

 

2.於測試區測試時，記得把WF_NOTIFICATIONS.mail_status 調整成SENT，避免系統發亂發信

UPDATE WF_NOTIFICATIONS
   SET mail_status = 'SENT'
 WHERE mail_status = 'MAIL';

1. 空白      --> 不會送
2. MAIL      --> 準備送
3. SENT      --> 己送出
4. FAILED --> user preference 被設定為DISABLED,或 SUMMARY
5. ERROR  --> SMTP relay 有問題, email address 錯誤,或未設定

3.架好 Mail server

4.要把下面這兩個服務搞起來

 

參考1

參考2：Workflow Mailer_10.ppt ( 廠商技術文件無法提供)