How to remove/mask the Workflow email address to avoid mails being sent to user from TEST/DEV Oracle Apps Instance
Scenario:
Whenever we are cloning EBS applications we might need to go
ahead and might need to start the workflow notification mailer. But starting
workflow mailer might cause sending mails to business user or end users which
would be irrelevant to them and cause confusion.
Solution:
As part for post cloning steps we should mask/remove email
address for user. You can change scripts as per the needs
1) Connect as apps
Create table per_all_people_f_bakup as select * From
per_all_people_f;
2) Connect as apps
Create table fnd_user_bakup as select * From fnd_user;
3) Now lets mask the email address
Connect as apps
Update per_all_people_f set email_Address='dummy@xyz.com'
where email_Address is not null;
Update fnd_user set email_Address='dummy@xyz.com' where
email_Address is not null ;
commit;
Table Relationship Between per_all_people_f and fnd_user
table
per_all_people_f and fnd_user join
fnd_user ==> Employee_Id
Per_all_people_f ==> Person_i
Select * from per_all_people_f papf , fnd_user fu11 where
papf.person_id=fu11.employee_id;