Aloz 的 Oracle ERP 天地

我們對於訂單資料需要做很多的控管，尤其在 Book 之後更是重要。

Oracle OM 有提供一種功能：Audit History

IT 可以幫助 User 很快很直接的設定要控管的欄位，可在 OM > Setup > Rules > Security > Processing Constraints 中設定。

但是，看似完美的功能，卻發現了一個 BUG (BUG# 5735404)
這個功能對於「日期」欄位會發生 SQL Error，經過Log TAR之後，Oracle 告訴我這是一個 Internal BUG，也有一個對應的 Internal Patch，所以，直接在 Metalink 上找不到。

Patch Number：5853601

以下為 Oracle SR 回應，原文貼上：

PROPOSED SOLUTION(S)
======================
Apply Patch. 5853601 Jan 2007, Order Management (11.5.10) Cumulative Patch

PROPOSED SOLUTION JUSTIFICATION(S)
====================================
The issue is resolved by upgrading to file <filename> and version <Version number> or higher.
The following bug outlines this solution:
Bug.Bug 5735404 AUDIT HISTORY CONSOLIDATOR NOT FUNCTIONING PROPERLY WITH DATE PROCESSING CONSTRA
The patch will do the following:
1. make Audit History Consolidator functioning properly for DATE attribute

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

1. Download and review the readme and pre-requisites for Patch. 5853601

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:
OEXPPCHB.pls
You can use the commands like the following:
strings -a $ONT_TOP/patch/115/sql/OEXPPCHB.pls |grep '$Header'

5. Retest the issue.

6. Migrate the solution as appropriate to other environments.