Display Name in workflow tables does not match Name with per_all_people_f records. (Doc ID 2502299.1)

Last updated on OCTOBER 21, 2024

Applies to:

Symptoms

Problem Statement:

After upgrading from 11i to 12.2.5 the employee name(full_name) in per_all_people_f and wf_local_roles.description are not matching.

Steps to Reproduce:
The issue can be reproduced at will with the following steps:

1. After Upgraded from 11i to 12.2.5
2. Employee Full name in the instance is concatenated using Last Name, First name, Suffix and Preferred Name
3. When any of the above column value is updated the full_name gets automatically updated in per_all_people_f but the corresponding  wf_local_roles.description does not get updated automatically.
4. Expecting the employee name in per_all_people_f.full_name should match to wf_local_roles.description after the full_name is updated in per_all_people_f table.
5. Run the SQL before and after updating any/all value of Last Name, First name, Suffix and Preferred Name
   select first_name,last_name, full_name
       from per_all_people_f
       where person_id = &person_id ;
   
   select display_name,Description  from wf_roles where  ORIG_SYSTEM = 'PER' AND orig_system_id =  &person_id;
   
   per_all_people_f.full_name gets updated correctly but wf_roles.Description does not get updated with same value.
   
   
   NOTE:
   ---------
   1. Concurrent Request  'Synchronize WF LOCAL tables' is disabled in the instance.

Changes

 Recent Upgrade to 12.2.5

Cause

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