Alerts in AIP Data Management

Hi,

As we know the alert messages in AIP DM get staged in the following tables:

ALERT

ALERT_DETAIL

ALERT_DEFINITION

ALERT_DEFINITION_DESC

ALERT_STATUS_DESC

Where in the alerts have descriptions with placeholders like {0}, {1}, {2}…etc.  in ALERT_DEFINITION_DESC table and the corresponding values for the place holders would be available in ALERT_DETAIL table.

When we view these alerts from DM alerts screen, we can see these alerts with the descriptions having the placeholders replaced with their actual values.

For example:

Say Alert x has the description in ALERT_DEFINITION_DESC table as below:

“Source id {0}, commodity_id {1} is not a valid combination.”