Custom Search

Friday 31 May 2013

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

This error usually comes up when the base form modifies and saves it to the database without cosing the form through personalization. If the this change is not due to personalization then mostly it could be due to trailing spaces in the underlying table values, and Oracle has identified this issue advising the users to run the Applications DBA Diagnostics script under ‘Trailing and Leading Spaces’ to identify the trailing spaces, which are not visible from the application screen.

Navigation to run the script from Oracle Applications:
Oracle Diagnostics Tool(Responsibility) - > Applications DBA (Application) -> Trailing and Leading Spaces

Also you can update the Comments, Description fields of the underlying table with the trim of the text.


Print This Post

2 comments:

  1. Hi,

    I am getting the same error but i am using personalization . Can you pls provide me any solution for this.....

    Regards,

    Vinoth

    ReplyDelete
    Replies
    1. Vinoth,
      You need to remove trailing spaces in the underlying columns to resolve this.

      Delete