This discussion is archived
1 Reply Latest reply: Feb 7, 2013 5:17 PM by Hussein Sawwan-Oracle RSS

Event Alert firing Two times when updated Sales order

User380464 Newbie
Currently Being Moderated
Hi ,

I have created one event alert. It is working fine while creating a new sales order i am getting email once. But once any sales order has updated means I am getting multiple Emails for same. Please find below mentioned i am using in Alert . In the query term_id 1045 & 1046 are 'Prepayment' values.

Any one help on this issue. This issue applicable only in PROD instance.

select ooh.order_number sales_Order_Number,
ooh.ORDERED_DATE,
ooh.FLOW_STATUS_CODE,
rt.NAME ,
hca.ACCOUNT_NUMBER customer_account_number
INTO &SALES_ORDER_NUMBER,
&ORDERED_DATE,
&FLOW_STATUS_CODE,
&NAME
&CUSTOMER_ACCOUNT_NUMBER
from oe_order_headers_all ooh,
ra_terms rt,
hz_cust_accounts hca
where 1=1
and ooh.payment_term_id=rt.term_id
and ooh.SOLD_TO_ORG_ID=hca.CUST_ACCOUNT_ID
and ooh.flow_status_code = 'ENTERED'
and rt.term_id in ('1045','1046')
and ooh.rowid = :ROWID


Thanks,
Amarnath
  • 1. Re: Event Alert firing Two times when updated Sales order
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    955221 wrote:
    Hi ,

    I have created one event alert. It is working fine while creating a new sales order i am getting email once. But once any sales order has updated means I am getting multiple Emails for same. Please find below mentioned i am using in Alert . In the query term_id 1045 & 1046 are 'Prepayment' values.
    Please see old threads for simialr discussion -- https://forums.oracle.com/forums/search.jspa?threadID=&q=Event+AND+Alert+AND+Multiple&objID=c3&dateRange=all&userID=&numResults=15&rankBy=10001
    Any one help on this issue. This issue applicable only in PROD instance.
    What is the difference between PROD and other instances?

    Thanks,
    Hussein