1 Reply Latest reply: Feb 7, 2013 7:17 PM by Hussein Sawwan-Oracle RSS

    Event Alert firing Two times when updated Sales order

    User380464
      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
          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