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!

How to send an oracle alert when responsibility assigned to user?

Discussion in 'Oracle Apps Technical' started by jagadekara, Aug 17, 2015.

  1. jagadekara

    jagadekara Forum Guru

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

    how to send an Oracle Alert when responsibility assigned to user?

    For example, I have a user TEST2.
    So when ever new responsibility or responsibilities assigned to him,then I need to send one email with those responsibilities names to my manager.

    How to achieve this?
     
  2. krasnoslobodtsev_si

    krasnoslobodtsev_si Forum Genius

    Messages:
    626
    Likes Received:
    129
    Trophy Points:
    810
    Location:
    Russian Federation
    Hi.
    it is possible to use the following:
    1) to use a trigger and the job of sending the letter
    2) to use DBMS_CHANGE_NOTIFICATION
     
  3. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    I didn't get you.

    How to do it?