1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Can we send all rows of sql query in single mail through Periodic Alert?

Discussion in 'Oracle Apps Technical' started by jagadekara, May 11, 2015.

  1. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi All,

    I created a periodic alert. In that I used one query which gives 14 records. So it is sending 14 emails now.
    But I want single mail with those 14 records. So How to do that?
     
  2. krasnoslobodtsev_si

    krasnoslobodtsev_si Forum Genius

    Messages:
    626
    Likes Received:
    129
    Trophy Points:
    810
    Location:
    Russian Federation
    Hi.
    Candidate solutions can be a little.
    What Oracle version?

    Possible options:
    1) to use the trigger (after ins/upd or compound)
    and jobs for sending mail
    2) to use CDC and jobs for sending mail
    3) to use the mechanism of basis of the notification message about changes
    and jobs for sending mail
     
  3. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi,

    I want it through Oracle Alerts, isn't possible?

    My Version is 12.1.3
     
  4. krasnoslobodtsev_si

    krasnoslobodtsev_si Forum Genius

    Messages:
    626
    Likes Received:
    129
    Trophy Points:
    810
    Location:
    Russian Federation
    by means of alert it is possible to send I singat to the subscriber to activate a certain processing within the current transaction...

    why alert?

    why not to use pipe?

    you can describe the task in more detail?
     
  5. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi,

    What is Singat?

    I am not aware about Pipe.

    Any how, I have done it through Alert.
     
  6. krasnoslobodtsev_si

    krasnoslobodtsev_si Forum Genius

    Messages:
    626
    Likes Received:
    129
    Trophy Points:
    810
    Location:
    Russian Federation
    Hi.
    signat is a misprint,it is signal.

    in a simple case it is possible to make as : subscriber executes request and receives 14 records. creates a body of the message and sends to the receiver.
    if the request returns more than 14 records: to divide into groups on 14 records, saving groups some table.

    it is better to envelop all control logic in procedure or package.
     
  7. RG Hegde

    RG Hegde Forum Advisor

    Messages:
    185
    Likes Received:
    35
    Trophy Points:
    310
    Location:
    Pune
    Hello Jagadekara,

    We are facing the same problem here .

    Could you please assist.

    How you have achieved that consolidated mail in periodic alert.
     
  8. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi Hegde,

    In Actions, Action Level should be Summary.

    Also in Email Text box, the out put columns should be in between the template.

    Template:

    =**= Enter summary template below this line =**=
    **
    =**= Enter summary template above this line =**=
     
    RG Hegde likes this.
  9. RG Hegde

    RG Hegde Forum Advisor

    Messages:
    185
    Likes Received:
    35
    Trophy Points:
    310
    Location:
    Pune
    Hello Jagadekara,

    Thanks for the quick response .

    We will try this and let you know