SMTP Server Configurations

Task notifications can be sent as Email to the assigned users. To receive notifications as email, perform the following configurations:

1. Add the following entries in AAI_EMAIL_CONFIG table:
   V_PROTOCOL - SMTP
   V_HOST –SMTP/ Mail Server ID
   V_PORT - SMTP Server Port
   V_AUTHENTICATION - Either False or True
   V_USER_NAME - Login name to SMTP/ Mail Server ID from which mail will be triggered. This is required if V_AUTHENTICATION is set as True.
   V_PASSWORD - Password to login into SMTP/ Mail Server. This is required if V_AUTHENTICATION is set as True.
   V_SECURITY -
2. Add the following entries in the AAI_USER_PREFERENCE table:
   In this table, you can set the user preference of how to receive the notification mails.
   • 0 – To receive no notification mails
   • 1 – To get mails instantly
   • 2 – To get bulk mail (Additionally, you need to set V_BULK_MAIL_TRIGGER value to Y in the AAI_WF_BULK_MAIL_TRIGGER table). A single mail will be sent with all the pending notifications from last trigger, as a PDF attachment. Once the bulk mail is sent, V_BULK_MAIL_TRIGGER value is automatically set to N.
   • 3 – To get mail with attachment
   (Optional) <Enter additional information about the step.>
3. Add the email ID of the user, to which the notification mails need to be sent, in the CSSMS_USR_PROFILE table.

   Table 8-1 V_USR_ID V_EMAIL

   V_USR_ID	V_EMAIL
   USER1	[e-mail]
   USER2	[e-mail]

4. Add the following entries in the AAI_WF_EMAIL_TEMPLATE table:
   •  V_MAIL_FROM- Email id from which the mail is sent
   •  V_MAIL_MESSAGE- Email message template
   •  V_MAIL_SUBJECT- Subject of the mail
   •  V_APP_PACKAGE_ID- Application package ID
   •  V_MAIL_TYPE- Email type such as task or bulk task.
   •  N_TEMPLATE_ID- A unique Email Template ID
   •  V_TEMPLATE_NAME- Email Template name
5. Set the V_EMAIL_REQUIRED value to Y in AAI_WF_APP_PACKAGE_B (for app level setting), AAI_WF_APP_REGISTRATION (for entity type level setting) and AAI_WF_ACTIVITY_TASK_B (for task level setting) tables.