Alerts response processing again !!!
I already have posted couple of posts related to this issue.
This is what we are facing.
Before R1213 upgrade we were using alerts response processing functionality without any issue.
After the upgrade we realized that alert action processor is completing with signal 11 and its not marking status to C in ALR_ACTUAL_MESSAGES table. Also its not firing the event which its supposed to, after a response is received.
So as a workaround I wrote a DB trigger on ALR_RESPONSE_MESSAGES table to do what the response processing is supposed to do.
Here is our design.