Entity specific templates can be created by following ways :

• Creation of a new alert and template before the entity creation.

  If a new alert has to be maintained before the creation of any new entity, the data for the same has to be inserted in the following tables twice.

  One for DETERMINANT_VALUE ‘*’ and the other for DETERMINANT_VALUE ‘OBDX_BU’, which is the default entity.

  Tables:

  DIGX_EM_MESSAGE_TEMPLATE
  DIGX_EM_MESSAGE_TEMPLATE_DESTINATION_REL

• Creation of a new alert and template after the entity creation.

  If a new alert has to be maintained after the creation of entity/entities, the same can be replicated for the different entities using the below queries.

  First insert the templates for DETERMINANT_VALUE ‘*’ and DETERMINAT_VALUE ‘OBDX_BU’ and then execute the below queries for the respective entities.

  insert into DIGX_EM_MESSAGE_TEMPLATE(NAME, DESCRIPTION, TITLE, CONTENT, LOCALE,
          DETERMINANT_VALUE, DELETE_STATUS, EVENT_ID, LAST_UPDATED_BY, LAST_UPDATED_DATE)
          (SELECT NAME, DESCRIPTION, TITLE, CONTENT, LOCALE, #determinantValue, DELETE_STATUS,
          EVENT_ID, LAST_UPDATED_BY, sysdate FROM DIGX_EM_MESSAGE_TEMPLATE WHERE
          DETERMINANT_VALUE = '*')

  insert into DIGX_EM_MESSAGE_TEMPLATE_DESTINATION_REL(TEMPLATE_NAME, LOCALE,
          DETERMINANT_VALUE, DESTINATION_ID) (SELECT TEMPLATE_NAME, LOCALE, #determinantValue,
          DESTINATION_ID FROM DIGX_EM_MESSAGE_TEMPLATE_DESTINATION_REL WHERE DETERMINANT_VALUE =
          '*')