Home › Discussions › Questions & Answers › FRM-40654 Error when saving Report Changes

FRM-40654 Error when saving Report Changes

Avatar photoCustomer Questions & Answers 5 replies

I am receiving the error ‘FRM-40654: Record has been updated by another user’ every time I try to save changes on the report setup window. I am the only one editing, so this doesn’t seem like a true concurrency issue.

5 replies

  • Support Enginatics

    This specific forms error when editing reports often signals a character set mismatch between your Oracle Database and your application tier. Oracle requires these character sets to be identical.

  • Avatar photoCustomer

    How can I check if the application tier character set matches the database setting, specifically the NLS_CHARACTERSET?

  • Support Enginatics

    You can check the database character set using the SQL query: select vnp.* from v$nls_parameters vnp where vnp.parameter = ‘NLS_CHARACTERSET’. The application tier setting is found by reviewing the Forms Server Environment Variables (via Help > About Oracle Applications) or by querying the context files directly.

  • Avatar photoCustomer

    Understood. So correcting the apps tier context file and running autoconfig to align the character sets should resolve this error?

  • Support Enginatics

    That is the required resolution. Once the DB and application tier use the same character set, the problem should cease, as outlined in Oracle’s Globalization Guide.

  • You must be logged in to reply to this post.