跨AD設定mail group中的成員

在outlook中無法直接跨AD設定mail group成員, 變通作法是執行:

  %SystemRoot%\SYSTEM32\rundll32.exe dsquery,OpenQueryWindow

 

就會有作業畫面可使用, 要先從整個目錄中選取要使用的AD.

目前測試Windows 10可以, 但Windows 7有問題, 無法瀏覽整個目錄.

 

 

 

 

Oracle EBS: 以oe_order_pub.Process_Order新增line, 出現error Invalid Tax Classification Code

問題: 以oe_order_pub.Process_Order新增line, 出現error Invalid Tax Classification Code

 

原因: 比對資料發現, tax code沒問題, 實際上是因為schedule ship date落在過去造成, 修正後已可正常新增line

 

心得: Oracle的error message本身就是個error...

 

 

Ref:

1.Sales Order Line Tax Classification Code

https://support.oracle.com/epmos/faces/CommunityDisplay?resultUrl=https%3A%2F%2Fcommunity.oracle.com%2Fthread%2F4017425&_afrLoop=279615208664052&resultTitle=Sales+Order+Line+Tax+Classification+Code&commId=4017425&displayIndex=1&_afrWindowMode=0&_adf.ctrl-state=kxszdivj3_37

 

 

Oracle EBS: 以alert發送email並加上附檔

在blog上看到有提出可用alert發送email並加上附檔, 於是到Oracle網站搜尋, 有找到方法, 但Oracle稱只是提供方法, 不提供問題排除及支援.

 

作法如下:

1. While defining Oracle alert Action, Select 'Action Level' as 'Summary'.
2. In Action Details, select 'Action Type' as 'Operating System Script'.
3. Select the 'Text' radio button.
4. Write the following code : uuencode <Name of the file along with the path> <Name of the attachment in the mail>|mailx -c &cc_mail_id,&to_mail_id -s "<Subject of the Mailer>" &to_mail_id.
5. One can use mail or sendmail command also instead of mailx command.
6. Save Alert details and test.

 

 

Ref:

1.1.ALERTS Interview Questions and Answers in Oracle Apps
http://appselangovan.blogspot.com/2013/10/alerts-interview-questions-and-answers.html

 

2.How to Send Email Attachments With Oracle Alerts? (Doc ID 1576621.1)