WF_LOCAL_SYNCH.PROPAGATE_USER & PROPAGATE_ROLE: Update EMAIL ADDRESS (Doc ID 1071923.1)

Last updated on JANUARY 18, 2017

Applies to:

Oracle Human Resources - Version 11.5.10.2 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.
This applies to Full HR installs as well.




Goal

How do we change the e-mail address in the HR tables and the WF Roles tables? 
We have the incorrect spelling of our company name and we cannot update the e-mail addresses using the HR API.

We have around 3600 employees having invalid email addresses. All these employee email addresses are ending with @YXZ.com instead of @XYZ.com. Please provide the data fix to correct the email addresses in HR tables as soon as possible. Then we need to update the e-mail addresses in the WF_ROLES tables.

Solution

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