Online Synchronization Between Per_all_people_f And Wf_local_roles Not Working As Expected (Doc ID 1508922.1)

Last updated on MAY 09, 2024

Applies to:

Symptoms

On :  12.1.3 version, Core HR - General


Find that online synchronization is not working from full name column in per_all_people_f table to description column in wf_local_roles table.


STEPS
The issue can be reproduced at will with the following steps:

1.  Create a new person
2.  Check the description in wf_local_roles
3.  Run sync process manually
4.  Check the description in wf_local_roles
5.  Get select * from per_all_people_f for this person

For Example :

Created new employee number XXXX

select * from per_all_people_f where person_id=XXXXX

Shows full_name=Test, Mrs. Good

select * from wf_local_roles
where display_name like '%Good%';

Shows
name= PER_ROLE:35514, display_name= Test, Good, description is null
name= HZ_PARTY:538386, display_name= Good Test, description is Good Test

Run Concurrent program 'Synchronize WF LOCAL tables' for origin PER_ROLE (Employees)

Shows
name= PER_ROLE:35514, display_name= Test, Good, description is Test, Mrs. Good
name= HZ_PARTY:538386, display_name= Good Test, description is Good Test

WORKAROUND
----------------------

The description column in wf_local_roles table is correctly populated if the Synchronize WF LOCAL tables concurrent process is run.

Cause

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