Alert Notification Through email for NEW (PO) Purchase order creation in Oracle Apps EBS R12

Alert Notification Through email for NEW (PO) Purchase order creation in Oracle Apps EBS R12


When ever a new purchase order is being created ,then a email notification will send to the user.
Steps:-

(1)Go to alert manager responsibility -> alert ->define.

(2)Application will be Purchasing and put the name of the Alert. The alert will be a event alert(click the event tab). Then put the details in the event details section, Application name and the table on which the alert will be applied. And check the event type means when the alert will get fire. Here the alert will be fire after inserting a new row in PO_HEADESR_ALL table.

Then put the number of days we want to keep the log in Keep.

Nextly build the sql statement. Here the output variable will be defined by &OUTPUT1.

Nextly verifiy the sql statement by pressing the verify tab.

 

Next save the alert and press in run button.

(3)Next step is to define the action, through ACTION button.

Here put the action name, description and action level(here we considering the detail).
(4)By pressing the action details button it will open the screen for entering the detail action plan,

Here in this case action type is ,message.
In to ,put the email id of the person to whom we want to send the alert.in cc put the other people email id you want to send the notification.
In reply to , put the email id of the person from whose email id the server will send the email notification.

In the below part select TEXT and type the message you want to send along with the output variable
"&OUTPUT1". After that save the form.

(5)Now define the action set pressing the button (action set).
Put the sequence no ,action set name,description then press the "action set details".this will open a new window.where you have to check the output tab where you can see the output variable(OUTPUT1) and then click the members tab.Here you have to define the particular action specified to the action set.Put the sequence number ,action name.In On Error section by default it will be the action :Abort. Now save the work.

(6)Now in System->option ,in mail server option tab specify the mail database/server name.

(7)Create a new PO and check the email in which the alert notification will forwarded.

(8)Also run the following sql,

select corrid, to_char(enq_time, 'MM-DD-YYYY HH:MM:SS') enq_time, to_char(deq_time, 'MM-DD-YYYY HH:MM:SS') deq_time,state from wf_notification_out where corrid like '%ALR%';

This query will return the row from the table related to the message which has been send.