PO Approval Mail is sent twice (duplicate emails) to Users for approval
Hi
The issue is that the business users are getting duplicate mails for PO Approval.
Emails are sent twice.
When checked in the APPLSYS.AQ$WF_DEFERRED, following query returns two rows.
SELECT A.user_data.GetValueForParameter('NOTIFICATION_ID') NOTIFICATION_ID
,A.user_data.GetValueForParameter('ROLE') ROLE
,A.user_data.GetValueForParameter('LANGUAGE') LANGUAGE
, A.user_data.GetValueForParameter('GROUP_ID') GROUP_ID
,A.user_data.GetValueForParameter('TERRITORY') TERRITORY
,A.user_data.GetValueForParameter('Q_CORRELATION_ID') Q_CORRELATION_ID
,A.user_data
,A.MSG_STATE
,A.CORR_ID
,A.*
FROM APPLSYS.AQ$WF_DEFERRED A
WHERE A.USER_DATA.GETEVENTKEY()= '22374539'--notification_id