Emailing to Alternate Email Addresses
There is no provision in iStore or Release 11i to store an alternate email address, as a fall back plan, in case the customer does not get the first email on Order Confirmation or Forgotten Password, for eg. There are various approaches we could have adopted, where in we update the email address showing up in hz_parties and hz_contact_points with the alternate email address. However, that would jeopardize the very foundation of the hz tables and the way it is intertwined with other modules it would be a risk we take, since it would be a need-in-the-haystack kind of an effort to troubleshoot any issues related to an TCA or Customer related functionalities.
So, we felt, the best approach would be to update the wf_local_roles table with the alternate email address. This table is used by Oracle Workflow when it has to send out emails for Order Confirmation or Forgotten Password. We tried to insert the new row with the exact information related to the party_id (derived from hz_parties table), however it gave us a unique constraint error. Moreover, by updating the email address, we have made sure that only 1 row remains in the WF related table and its only the email address field that need to be changed.