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

Last updated on JANUARY 13, 2017

Applies to:

Oracle Human Resources - Version 12.1.3 and later
Information in this document applies to any platform.
Relevancy checked 11-Apr-2015

Symptoms

On :  12.1.3 version, Core HR - General

R12.HR_PF.B.delta.4

PERWSHRG 12.0.37.12010000.5

ACTUAL BEHAVIOR  
---------------

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.

EXPECTED BEHAVIOR
-----------------------

Expect the online synchronization to be working.

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms