FRM-40654 Record Has Been Updated. Requery Block To See Change (Oracle Fix)

Blank/space characters cause a lot of issues paticularly in Oracle forms.
Most of the times when you try to update a record you get an error message

FRM-40654: Record has been updated. Requery block to see change.

Most of the times this is caused by extra chars in the string columns. There is an Oracle fix issue for this issue. Apply the fix in TEST instance before applying in PROD. The fix is as follows.

Run script $FND_TOP/sql/afchrchk.sql

Option1= fnd_flex_values_tl
Option2= description
Option3 = N
Option4 =Y

Below is the explanation for all the options from the oracle script

--Table Name and Column Name (Always better to work on one table and column if known)
prompt Enter the table and column names to check for leading or trailing
prompt spaces and control characters. Like-style expressions are ok.
prompt Leave either table or column blank to check table/column.
prompt Table name (blank for all):
define tblarg = '&1'
prompt Column name (blank for all):
define colarg = '&2'

--I would recommend to input Y with caution for the newline option as oracle stores data with new lines chars in some cases.
--Ex : Atributes info on valuesets are stored with new lines chars
--Default N checks for only leading/trailing spaces
prompt Newline characters are acceptable in columns never queried in
prompt Forms, on only queried in multi-line items.
prompt Enter Y to also look for newline characters.
prompt Check for newline characters (Y/N)?
define newlinearg = '&3'

--option to fix or just list the errors. recommend to first list and then fix errors.
prompt Enter Y to automatically strip all leading/trailing spaces
prompt and control characters found.
prompt *** WARNING ***
prompt It is highly recommended to run first without stripping
prompt to be sure all detected values really should be fixed!

prompt Automatically fix all errors found (Y/N)?
define fixarg = '&4'