EBS 11i INV或PO排除FRM-40654

如果在ITEM的Description最後有一個空白或特殊字元時,當要儲存時會出現同時使用同一筆資料的錯誤:
FRM-40654 Record Has Been Updated. Requery Block To See Change

上述的FRM-40654也會發生在PO模組上,但是原因一樣的,有部份的列值包含了空白。

在$FND_TOP中,有一支腳本程式afchrck.sql可以檢查,以apps登入後執行
SQL> connect apps/appsc
Connected.
SQL> @afchrchk.sql

PL/SQL procedure successfully completed.

*** INSTRUCTIONS ***
Enter the table and column names to check for leading or trailing
spaces and control characters.  Like-style expressions are ok.
Leave either table or column blank to check table/column.

Table name (blank for all):
Enter value for 1: MTL_SYSTEM_ITEMS_B  --表格名稱
Column name (blank for all):
Enter value for 2: DESCRIPTION  --檢查的欄位名稱

Newline characters are acceptable in columns never queried in
Forms, on only queried in multi-line items.
Enter Y to also look for newline characters.
Check for newline characters (Y/N)?
Enter value for 3: Y

Enter Y to automatically strip all leading/trailing spaces
and control characters found.
*** WARNING ***
It is highly recommended to run first without stripping
to be sure all detected values really should be fixed!

Automatically fix all errors found (Y/N)?
Enter value for 4: N   --是否自動俢復

Oracle DB的listener.log清理