Script to update Workflow Mail Address as NULL in TEST Instances to Avoid Triggering Mail to users.

update fnd_user set email_address=' ';

update per_people_f set email_address=' ';

update hz_parties set email_address = null where email_address is not null;

update hz_contact_points set email_address = null where email_address is not null;

update ap_supplier_sites_all   set email_address = null, remittance_email=null;

update ap_supplier_contacts set email_address = null;

update iby_ext_bank_accounts set contact_email = null;

update iby_external_payers_all set debit_advice_email = null;

update iby_external_payees_all set remit_advice_email = null;

update po_headers_all      set email_address = null;

update pon_bid_headers set email  = null;

update pon_bidding_parties set additional_contact_email  = null;

update per_all_people_f set email_address=null, attribute3=trim(attribute3), attribute4=trim(attribute4), attribute5=trim(attribute5), attribute6=trim(attribute6), attribute7=trim(attribute7), attribute8=trim(attribute8), attribute9=trim(attribute9), attribute10=trim(attribute10), attribute11=trim(attribute11), attribute12=trim(attribute12), attribute13=trim(attribute13),attribute14=trim(attribute14),attribute15=trim(attribute15);

update WF_LOCAL_USERS set email_address = null where email_address is not null ;

update WF_LOCAL_ROLES set email_address = null where email_address is not null;

update wf_notifications set mail_status='SENT' where mail_status in ('MAIL', 'ERROR', 'FAILED'); (under apps schema);

update wf_notifications set status='CLOSED', mail_status='SENT', end_date=sysdate where status='OPEN' and MESSAGE_TYPE='WFERROR';

update fnd_user set user_guid=null';