My Blog List

Wednesday, April 4, 2012

Changing email addresses for testing in peoplesoft

In test instance we need to make sure that none of the emails generated accidentally go to the real person. To manually changed all of my test participants’ emails to go to tester or developer we can update following tables manually unless you have any custom tables to update.

UPDATE PSOPRDEFN SET EMAILID = 'xyz@abc.com'
UPDATE PS_ROLEXLATOPR SET EMAILID = 'xyz@abc.com'
UPDATE PS_EMAIL_ADDRESSES SET EMAIL_ADDR = 'xyz@abc.com'
UPDATE PSUSEREMAIL SET EMAILID = 'xyz@abc.com'