Alert purging process by the InboxPurge agent in IBM Order Management System

Answer

The 'ExpirationDays' is set during alert creation, this value is to define the number of days of no activity on the alert, and when the expiration day is passed the alert should close automatically. A value of zero means the exception will not expire and the alert maintains its current 'created' status.

In createException API add AutoResolveFlag=Y or ExpireDays='1' attributes while creating an exception.

The alerts are closed only after the combination of  "ExpirationDays+ModifyTs"  has passed the current date. This date can be calculated by the DB query to get an estimate of the expected expiration date for an alert,

SELECT YFS_INBOX.* FROM YFS_INBOX YFS_INBOX
WHERE ( ( ( ACTIVE_FLAG = 'N' OR ACTIVE_FLAG = 'n' ) AND ENTERPRISE_KEY = '<KEY>' AND RESOLUTION_DATE < 2018-10-08T00:00:00 ) OR
( ACTIVE_FLAG = 'Y' AND STATUS = 'OPEN' AND EXPIRATION_DAYS > 0 AND ENTERPRISE_KEY = '<KEY>' AND MODIFYTS + EXPIRATION_DAYS DAYS < 2018-10-10 AND
NOT EXISTS ( SELECT 1 FROM YFS_INBOX INNER
WHERE INNER.INBOX_KEY=YFS_INBOX.PARENT_INBOX_KEY ) ) ) ORDER BY INBOX_KEY;

If the ExpireDays is set to 1 then this query returns the list of all alerts/exceptions which have passed the 1 day expiration date. 

The purge agent 'InboxPurge agent' monitors for alerts in the output table and ultimately purge them.

Now the purged alerts will be moved to 'closed' status.

In case the output table of above query is empty then it might be so that there are no eligible alerts to be closed/purged.

When an alert is created the RESOLUTION_DATE is set to ‘1900-01-01-00.00.00.000000' this is an expected behavior.