Transaction Workbench Error: FRM-40654: Record has been updated requery block to see changes

We had imported invoices from one instance to another instance using standard Autoinvoice. For some invoices, when queried from Transaction Workbench, we would get following error

FRM-40654: Record has been updated requery block to see changes

We checked all the locked objects and locks but could not find any reason for the error. The invoice was not giving any error in source instance, it was giving error only in target instance. In source instance, form ARXTWMAI version and last modified date were

Form Version : 12.0.129.12010000.20 Form Last Modified : $Date: 2010/05/04 03:13 $

In target instance, form version were

Form Version : 12.0.129.12010000.26 Form Last Modified : $Date: 2010/09/21 22:38 $

Difference in form version was not much. Then i searched metalink and found following note.

Transactions Workbench Error: Listing of FRM Errors (Doc ID 1321612.1)

Search for FRM-40654 and click to see the cause of error. In our case we found that transactions that were giving error had one extra space at the end of ra_customer_trx_all.comments. By updating ra_customer_trx_all table and setting comments to trim(comments) fixed our issue. I noticed that space the beginning of comments column were not causing any issue, it was only trailing spaces not the leading spaces.