Core Workflow - EBS (MOSC)

MOSC Banner

PO Approval Mail is sent twice (duplicate emails) to Users for approval

edited Jun 17, 2015 5:46AM in Core Workflow - EBS (MOSC) 1 commentAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center