We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Want to do a Bulk update on Work Email to stop notifications or Data Masking reasons

Accepted answer
154
Views
8
Comments
edited May 24, 2017 7:24PM in HCM Integrations 8 comments

Summary

NOT Licensed for data masking want to update email address for everyone please use this sql to create a HDL file and import into HCM.

Content

Here you go!

select 
'METADATA|PersonEmail|EmailAddressId|PersonId|PersonNumber|DateFrom|DateTo|EmailType|EmailAddress|PrimaryFlag|GUID|SourceSystemOwner|SourceSystemId'
from dual
union all
select
('MERGE|PersonEmail'
|| '|'
|| pemail.Email_Address_Id
|| '|'
|| pemail.Person_Id
|| '|'
|| papf.Person_Number
|| '|'
|| to_char(pemail.Date_From,'YYYY/MM/DD')
|| '|'
|| to_char(NVL(pemail.Date_To,'4712/12/31'),'YYYY/MM/DD')
|| '|'
|| pemail.Email_Type
|| '|'
|| '[email protected]'

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!