My Oracle Support Banner

R12 PAXPREPR FRM-40654: Record Has Been Updated Error While Updating A Task (Doc ID 2639152.1)

Last updated on JULY 08, 2020

Applies to:

Oracle Project Foundation - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

PAXPREPR error when updating any information on task
 - columns contain special characters

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

Identifying script

SQL>select task_id, project_id, task_number, task_name, last_update_date, description,  REGEXP_REPLACE (DESCRIPTION ,'[^' || CHR(1) || '-' || CHR(127) || ']' , '') from pa_tasks
          where length(asciistr(description))!=length(description)  
          order by description;

      or

          select * from pa_tasks where REGEXP_LIKE(description,
    '[^[:alnum:]'' '']')  ;

Changes

 

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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