Need help to send email notification when the status changes to "closed" for TM reconciliation
Need suggestion in sending reconciliation status "closed" email notification to users. Data from source gets loaded to a Balance comparison TM reconciliation/profile every day and there are 6 data sources defined with 3 match processes (2 data source for each match process as source system and sub-system).
Debit and credit transactions are loaded separately against each Data Source so there are total 12 data loads (Data Load Rule) happening through Data Management/Exchange.
We also have Auto Submit and Auto Approve reconciliation rules created with the filter condition -> "source & sub system less unmatched" And "Source & sub system less unmatched supported" And "Less matched in-transit" equals 0 to change the reconciliation status to "Closed"