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!

Oracle alerts issue

Discussion in 'Oracle Apps Technical' started by nikhil9421, Nov 10, 2017.

  1. nikhil9421

    nikhil9421 Active Member

    Messages:
    15
    Likes Received:
    0
    Trophy Points:
    100
    Hello All,



    This is regarding Oracle Alerts,

    1. I wanted to create AFTER UPDATE event base alert, But i want to fire alert only if specific column is updated.
    For eg ; Table TABLE_ABC and if column COL1 is updated, then only alert should run and notification should be sent,
    If any other column of same table is updated, then notification should not be sent.

    2. Can we get old and new value in oracle alert AFTER UPDATE event.

    Could you please help to get this done through Oracle Alerts.?

    Thanks In advanced.
     
  2. krasnoslobodtsev_si

    krasnoslobodtsev_si Forum Genius

    Messages:
    733
    Likes Received:
    143
    Trophy Points:
    830
    Location:
    Russian Federation
    If the task is to be solved at the database level, then you can use the following solutions:
    1) within bound the transaction you can use: a trigger and dbms_alert

    2) to organize the notification process for the client application after the transaction is committed (for example, changing the status of the document)
    dbms_change_notification
     
  3. nikhil9421

    nikhil9421 Active Member

    Messages:
    15
    Likes Received:
    0
    Trophy Points:
    100
    But how dbms_alert will be used to send mail to user, and business want it through Oracle Apps Alerts.

    How to implement it ?
     
  4. krasnoslobodtsev_si

    krasnoslobodtsev_si Forum Genius

    Messages:
    733
    Likes Received:
    143
    Trophy Points:
    830
    Location:
    Russian Federation
    I might to provide examples on basis dbms_alert and dbms_notification.
    And you ,might ,later select from samples that you needed .
     
  5. nikhil9421

    nikhil9421 Active Member

    Messages:
    15
    Likes Received:
    0
    Trophy Points:
    100
    Could you please share me same examples of both..
    ?

    Thanks :)