Oracle EXT_SYS ATP Error Message Handler

The Oracle EXT_SYS ATP Error Message Handler integration is called from the scope and global fault handlers of all integrations in the recipe/accelerator. It filters messages from fault handlers and sends an error notification email.

Integration Flow

Figure 2-15 Oracle EXT_SYS ATP Error Message Handler

Integration Description

Get Error Message

Gets the Error message detailed parameters from the integration that calls this Error Message Handler.

Get Email ID

Retrieves the Error Mail id from the Configuration table by invoking a stored procedure OHIP_OIC_GET_ERR_EMAIL_SP to get column ERR_EMAIL as configured in table OHIP_OIC_EXT_SYS_CONFIG_TAB for this external system.

Send Email Notification

Sends an email notification with the error message parameters to the ERR_EMAIL as configured for this external system id.

Set Error Status to Y for this External System ID

Updates the ERR_STATUS column to 'Y' in the configuration table for this external system id by invoking the stored procedure OHIP_OIC_UPD_EXT_SYS_ERR_STATUS_SP.