My Oracle Support Banner

R12: PAXPREPR Is There a Permanent Solution for Leading/Trailing Spaces in Fields in PA_PROJECTS_ALL or PA_TASKS Table Which Causes FRM-40654? (Doc ID 2609314.1)

Last updated on NOVEMBER 15, 2022

Applies to:

Oracle Project Costing - Version 12.2.5 and later
Information in this document applies to any platform.


When updating a project (for example changing the status) via 'Project' form (PAXPREPR.frm), the user receives the error 'FRM-40654: Record has been updated. Requery block to see change'. This is a known issue and is due to either leading or trailing spaces on text fields in PA_PROJECTS_ALL or PA_TASKS tables. Note that the projects/tasks are created from an external source that are eventually created in Oracle Projects. 

Oracle Support provided a data fix script called afshrchk.sql which does resolve the issue.  Is there a permanent solution to this type of issue?


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

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