平凡的幸福(備站）

如果在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 --是否自動俢復