CRM :: Masking the email addresses in non-production environment

Important CRM tables to be updated for masking the email addresses in non-production environment.This is crucial when we want to test the email functionality in peoplesoft as we donot want the emails from DEV/TEST environments to go to the real email addresses.

update ps_bo_srch_eml set cm_concat = 'DevEmailTesting@abc.com', email_addr = 'devemailtesting@abc.com',cm_concat_upper = 'DEVEMAILTESTING@ABC.COM';
update ps_rf_provider_grp set email_addr = 'DevEmailTesting@abc.com'
update ps_rc_case set rc_contact_info mailto:= where rc_contact_info like '%@%';
update ps_cm set email_addr= 'DevEmailTesting@abc.com' where cm_type_id=4;
update ps_rf_provider_grp set email_addr= 'DevEmailTesting@abc.com';
update psuseremail set emailid= 'DevEmailTesting@abc.com';
update ps_rolexlatopr set emailid= 'DevEmailTesting@abc.com';
update psoprdefn set emailid= 'DevEmailTesting@abc.com';
update ps_rb_in_email set reply_to_address= 'DevEmailTesting@abc.com';
update ps_rbc_recipient set email_addr= 'DevEmailTesting@abc.com';
update ps_mcfem_mail_main set mcf_email_from= 'DevEmailTesting@abc.com';
update ps_RB_EMAIL_ORGL set email_from= 'DevEmailTesting@abc.com' , Email_bcc= 'DevEmailTesting@abc.com';

There are other ways to do it also. This is just data masking.
We can achieve this objective by writing a wrapper code around sendmail() function in peoplesoft.This wrapper can modify the 'To email address' to dummy ID when we are dealing with non-production environments.
In higher peopletools version 8.47, we would need to write a similar wrapper around javamail API function call also.