Alert Notification for Transaction Feed Management

Oracle Revenue Management and Billing enables you to configure alert notification for the Transaction Feed Management feature. At present, the system supports the following two alert notifications:

• To Do Creation

• Email Notification

The objective of these notifications is to create an alert for the records which are in the Ignored or Error status. Once a To Do is created, it indicates the number of records which are in the Ignored or Error status. However, the email notification provides the error summary statistics.

A new batch named C1-ERRAL is introduced in this release. While executing the C1-ERRAL batch, you need to set the To Do Created For parameter to TFM. In addition, you need to specify the transaction status (for example, EROR or IGNR) for which you want to create an alert notification. On executing the C1-ERRAL batch, the system creates a To Do using the C1-TXNER To Do type.

The C1-ERRAL batch must be executed only after all the transaction feed management batches are executed successfully. If the C1-ERRAL batch is executed for the first time, the system considers all the transactions whose CURR_​SYS_​PRS_​DT is earlier than or equal to the batch business date. However, in the subsequent execution, the system considers only those transactions whose CURR_​SYS_​PRS_​DT is later than the last To Do generation date and earlier than or equal to the batch business date.

On clicking the To Do notification in the To Do List screen, you can view the error records in the Feed Management Dashboard screen. Note that the system will not create a new To Do when the To Do for the same drill key combination already exists in the Open status.

To create an email notification, you need to attach an algorithm which is created using the C1-TFMERREML algorithm type to the To Do Post-Processing system event of the C1-TXNER To Do type. On creating a To Do, the batch creates an email outbound message which contains the error summary statistics.