目前日期文章:200805 (2)

瀏覽方式: 標題列表 簡短摘要

Credit Hold 在 OM 大部份的情況都會是自動產生, 所以 Comments 可以讓我們了解它是為了什麼而被 Credit Hold, 例如, Over Credit, 有 Overdue 的 Invoice 等.

原本我一直以為 Hold Comments 是 "必定" 存在的, 結果也如往常, 並不是, 我是有發現一個例子 :

1. 先找一個已經 Over Credit Limit 的客戶
2. 產生一張有值訂單, 並且 Book Order
3. 因為該客戶 Credit 已經滿了, 所以 Booking 時會提醒你訂單將會被 Credit Hold
4. 使用 Additional Line Information 就可以看到 Credit Hold Comments
5. Release Credit Hold
6. 提高 Line Total and Save Order
7. 因為 Order Status = 'Booked', 所以系統只會給一個 MsgBox 告知會被 Credit Hold

"Some Lines are placed on credit check hold. Please see the Additional line information window for hold details"


8. 由上訊息可以知道, Oracle 也是請 User 使用 Additional Line Information 查詢 Hold 的原因, 但這時候可以發現, Hold Comments 並沒有值

我相信這個只是其中一個 Scenario, 所以我就 Log TAR.........


Oracle 的印度"朋友"給我一個蠻有趣的回應: 用 View Open Message (Process Messages) 去看, 但是我去看 Table, 這邊只會記錄 Open 的訊息, 如果該 Credit Hold 被 Release, Hold Comments 就會不見, 所以這個"建議"就被我否決了


(2008/07/01)
有 patch 囉....^O^

SOLUTION / ACTION PLAN
=======================
To implement the solution, please execute the following steps:

1. Download and review the readme and pre-requisites for Patch 6856362 , when released.

ETA for this patch is 31-July-2008

Beginning September 1, 2006, Order Management Suite Development is introducing the release of regular and scheduled rollup patches in a number of pro
duct areas.

You may refer Note 396910.1 -- Order Management Suite Patching Strategy For One-Off Requests and RUPs

2. Ensure that you have taken a backup of your system before applying
the recommended patch.

3. Apply the patch in a test environment.

4. Confirm the following file versions:

OEXVCRLB.pls 115.48.11510.18

You can use the commands like the following:

strings -a $ONT_TOP/patch/115/sql/OEXVCRLB.pls |grep '$Header'

5. Retest the issue.

6. Migrate the solution as appropriate to other environments.

Aloz 發表在 痞客邦 PIXNET 留言(0) 人氣()

Subject: How to purge e-mail notifications from the workflow queue so the e-mail is not sent
  Doc ID: Note:372933.1 Type: HOWTO
  Last Revision Date: 03-JUL-2006 Status: PUBLISHED

In this Document
  Goal
  Solution


Applies to:

Oracle Workflow Cartridge - Version: 11.5.10
Information in this document applies to any platform.

Goal

The Workflow mailer has not been running. There are a large number of e-mail notifications accumulating in the queue.  How do we prevent these from being sent when the mailer is started.

Solution

Please take a backup before making any of these changes and try this on a Test instance first.

1. You need update the notifications you do not want sent, in the WF_NOTIFICATIONS table. 

Check the WF_NOTIFICATIONS table. Records where status = 'OPEN' and mail_status = 'MAIL' are notifications
that will have an e-mail notification sent.

SQL> select notification_id, status, mail_status, begin_date
from WF_NOTIFICATIONS
where status = 'OPEN' and mail_status = 'MAIL';

This should show you which notifications are waiting to be e-mailed.

You can use the BEGIN_DATE column to help narrow down the ones you do not want sent, if you only want to stop the e-mails from a specific date range.

To update a notification so that it will not get e-mailed. Set the MAIL_STATUS = 'SENT'. The
mailer will think the e-mail has already been sent and it will not send it again.. (Users can
still reply to the notification from the worklist page in the applications).

e.g. SQL> update WF_NOTIFICATIONS set mail_status = 'SENT' where mail_status = 'MAIL';
This will update all notifications waiting to be sent by the mailer.


2. Then run the script wfntfqup.sql to purge the WF_NOTIFICATION_OUT queue and rebuild it with
data currently in the WF_NOTIFICATIONS table. This is what purges all notifications waiting in the queue to be sent.
It will then populate the queue with the current data in the wf_notifications table.

Since you have changed the mail_status = 'SENT" it will not enqueue
these messages again.. Only the ones where mail_status = 'MAIL' and status = 'OPEN' will be
placed in the WF_NOTIFICATION_OUT queue and sent by the mailer.


wfntfqup.sql是在 $FND_TOP/patch/115/sql 之下

Aloz 發表在 痞客邦 PIXNET 留言(0) 人氣()

找更多相關文章與討論

您尚未登入,將以訪客身份留言。亦可以上方服務帳號登入留言

請輸入暱稱 ( 最多顯示 6 個中文字元 )

請輸入標題 ( 最多顯示 9 個中文字元 )

請輸入內容 ( 最多 140 個中文字元 )

請輸入左方認證碼:

看不懂,換張圖

請輸入驗證碼