My Oracle Support Banner

How to Resolve FRM-40654 Errors When Updating a Project or Other Transactions in Projects? (Doc ID 362800.1)

Last updated on NOVEMBER 25, 2020

Applies to:

Oracle Project Foundation - Version and later
Oracle Project Billing - Version 12.1.3 to 12.1.3 [Release 12.1]
Oracle Grants Accounting - Version 12.2.5 to 12.2.5 [Release 12.2]
Information in this document applies to any platform.


When modifying a project (or some other type of transaction) in Projects you get the following error:

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

The error may occur when:

It may occur in almost any form within Projects or Grants Accounting, for example:

How can this type of error be resolved?


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 Why does this error occur?
 Fixing the problem
 What if the afchrchk.sql script is missing?
 Troubleshooting common issues with afchrchk.sql

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.