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 FEBRUARY 23, 2021
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