Aloz 的 Oracle ERP 天地

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.