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:

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

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