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 laterInformation in this document applies to any platform.
Goal
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?
Solution
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
Goal |
Solution |
References |