Alerts in Oracle Applications

Purpose of Alert in Oracle Applications

In Oracle applications, alert is the best option for sending notification to user. we can send notification to user through various ways such as workflow, mail etc. which depends on User requirements. One of the requirements we have received by user that whenever the requisition will be created, manager should know about that requisition details information.
  

select ph.segment1   ,ph.TYPE_LOOKUP_CODE 
 ,(select name from hr_organization_units
   where organization_id = pl.source_organization_id)source
 ,(select name from hr_organization_units
   where organization_id = pl.destination_organization_id)destination
 ,(SELECT first_name||' '||last_name 
  FROM per_people_f 
  WHERE person_id = ph.preparer_id)Name  
 ,pl.item_description
 ,pl.quantity
 ,ph.creation_date
 ,pl.need_by_date
INTO &OUTPUT1,
&OUTPUT2,
&OUTPUT3,
&OUTPUT4,
&OUTPUT5,
&OUTPUT6,
&OUTPUT7,
&OUTPUT8,
&OUTPUT9
FROM PO_REQUISITION_HEADERS_ALL ph,PO_REQUISITION_LINES_ALL pl
WHERE ph.requisition_header_id=pl.requisition_header_id
and ph.TYPE_LOOKUP_CODE='INTERNAL'
AND ph.ROWID = :ROWID

2.Press the Actions Button and enter the following code which is shown below

3. Press the Action Details button, enter email id and description

 4. Enter the Action Sets information

5. Enter the Members information

After done all the steps save the alert. Create the requisition and check user is receiving the notification properly.