0% found this document useful (0 votes)
301 views5 pages

Oracle Alert To Send Email

Oracle Alert To Send Email

Uploaded by

Safy Safy
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
301 views5 pages

Oracle Alert To Send Email

Oracle Alert To Send Email

Uploaded by

Safy Safy
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 5

Home Amazon Resources About

Search: type, hit enter

My Documentation on Oracle Database, E-Business Suite and PeopleSoft

RSS Feed

Posted by Vasudev Seeram on July 27, 2005 Go to comments Leave a comment (0)

Changing Employee’s Start Date


This document shows how to set up Oracle Alerts to send email notifications.
RC-20200: Fatal: Could not find Unzip When
Installing EBS R12
1. Navigate to Alerts and enter the following information: Running PO Approval Analyzer Diagnostic as
Concurrent Request
Application: Application Object Library Resolving Stuck Selected For Payment Cheques
Description: Send email Notification Troubleshooting PRC: Interface Supplier Costs
Name: Send Email Notification Issue

Under Periodic > Periodic Details


Frequency: Every N Calendar Days
Ken on Journal Wizard: Viewer application
Days: 1
profile is not set.
Start Time: 07:00:00 Tom on File /etc/oratab is not accessible.
End Time: 18:00:00 shiva on File /etc/oratab is not accessible.
Check Interval: 00:30:00 How To Fix Oracle Xe Error Code 17002 in
Windows on SQL Developer Vendor Code
Keep: 2 Days 17002
End Date: Amit on Outbound Server Unable to Make a
Network Connection

Select Statement:

select w.notification_id, November 2015


w. group_id, December 2014
w.message_type,
Copyright © 2016 TriniDBA | Powered by zBench and WordPress November 2014 ↑ Top
w.message_name, October 2014

rtrim(f.email_address), September 2013


February 2013
substr(f.description,1,30) name,
January 2013
w.to_user,
December 2012
substr(w.subject,1,100) message_text
October 2012
INTO
September 2012
&notification_id, August 2012
&group_id, July 2012
&message_type, June 2012
&message_name, May 2012
&email_address, March 2012

&name, February 2012


January 2012
&to_user,
December 2011
&message_text
November 2011
from
October 2011
wf_notifications w,
September 2011
fnd_user f August 2011
where July 2011
w.recipient_role = f.user_name and June 2011
w.status=’OPEN’ and May 2011
trunc(begin_date) = trunc(sysdate) February 2010
January 2010
December 2009
2. Click the Actions button.
November 2009
October 2009
3. Enter the following information:
September 2009
August 2009
Actions – Send Email Notification July 2009
Action Name: Email User May 2009
Description: Send User an email April 2009
Action Level: Detail March 2009
February 2009

Action Details – Email User January 2009


To: &EMAIL_ADDRESS December 2008
Subject: PROD NOTIFICATION:&NOTIFICATION_ID – &MESSAGE_TYPE – &MESSAGE_NAME November 2008
October 2008
September 2008
Select Text.
August 2008
July 2008
Enter the following text into the textbox:
June 2008
May 2008
&NAME March 2008
February 2008
Please log in to Oracle Applications and check your Notifications. &MESSAGE_TEXT January 2008
December 2007
Link to Oracle: November 2007

http://appsserver.serverdomain.com:8000/OA_HTML/US/ICXINDEX.htm October 2007


September 2007
August 2007
This is an unattended messaging system. Please do NOT respond to this email.
July 2007
June 2007
Oracle Applications
May 2007
April 2007
4. Action Sets – Send Email Notification February 2007
January 2007
Seq: 1 December 2006
Action Set Name: Email Notification November 2006

Suppress Duplicates: October 2006


September 2006
Enable:
August 2006
July 2006
5. Alert Details – Send Email Notification
June 2006
July 2005
Under the Outputs tab: April 2005

Output Name: NOTIFICATION_ID


Description: NOTIFICATION_ID
Detail:
Summary:
Output Name: GROUP_ID
Description: GROUP_ID
Detail:
Summary:

Output Name: MESSAGE_TYPE


Description: MESSAGE_TYPE
Detail:
Summary:

Output Name: MESSAGE_NAME


Description: MESSAGE_NAME
Detail:
Summary:

Output Name: EMAIL_ADDRESS


Description: EMAIL_ADDRESS
Detail:
Summary:

Output Name: NAME


Description: NAME
Detail: 40
Summary: 40

Output Name: TO_USER


Description: TO_USER
Detail:
Summary:

Output Name: MESSAGE_TEXT


Description: MESSAGE_TEXT
Detail: 150
Summary: 150

11i, ERP Email Notification, Notification Setup, Notifications, Oracle Alerts, WF_NOTIFICATIONS

← Setting Up Cash Management Open Interface Cloning Multi Node To Single Node →

NOTE - You can use these HTML tags and attributes:


<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote
cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s>
<strike> <strong>

NAME

EMAIL

Website URL

seven × =

SUBMIT

You might also like