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

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]'