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

FRM-40654 Error when saving Report Changes

Avatar photoCustomer Questions & Answers 5 replies

When I try to save modifications to a report, I get the concurrency error FRM-40654: Record has been updated by another user, even though I’m the only one editing. What typically causes this false concurrency error?

5 replies

  • Support Enginatics

    This is generally a sign of a severe setup issue: a character set mismatch between your Oracle Database and your application tier. Oracle’s Globalization Guide requires the APPL_TOP character set to be identical to the database character set.

  • Avatar photoCustomer

    How can I quickly verify both character sets to confirm the mismatch?

  • Support Enginatics

    You can verify the database setting using `select vnp.* from v$nls_parameters vnp where vnp.parameter = ‘NLS_CHARACTERSET’`. The application tier setting can sometimes be viewed via Help > About Oracle Applications > Forms Server Environment Variables, or by querying context files using SQL provided in the troubleshooting section.

  • Avatar photoCustomer

    So the solution is to correct the application tier context file and run `autoconfig` to enforce alignment?

  • Support Enginatics

    That is the required solution. Aligning the DB and application tier character sets resolves this concurrency validation error.

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