Receipt Confirmation Alert (Check Periodic Alert) is running forever and not sending notifications. Please let me know if any of you see similar issue and fix for it. I have opened SR with Oracle as well.
WF mailer is up and running and delivering notifications and no issue for other requests.
It is waiting on the following
Current Wait Event SQL*Net message from client
Current Wait Class Idle
Program ALECDC@jupiter (TNS V1-V3)
Thanks in advance.