Saturday, July 17, 2010

Form error while trying to update Projects 'FRM-40654: Record has been updated. Requery block to see change'

While trying to update a Project we were getting the following error:

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

On investigation we found that the issue is due to trailing or leading spaces in attribute columns for the project. Oracle has provided a fix for this:

Refer to the Metalink DOC ID 362800.1

Run this script with the 'Automatically Fix all the errors Found' parameter as 'N' initially to determine the columns with the trailing or leading spaces. Once you analyze the data and everything looks good then we can run the script again with 'Automatically Fix all the errors Found' parameter as 'Y'.

No comments: