Tag Archives: Notifications

Notifications Automatically Closing

Problem:

A preparer creates a purchase request and send it to the approver, who approves it. The preparer then receives a notification that the PR was approved, but the notification automatically disappears from the list after the browser is refreshed or when the user logs off.

Solution:

The AutoClose_FYI parameter must be changed from ‘Y’ to ‘N’ in Notification Mailer.

Then the Notification Mailer must be stopped and started for the change to take effect.

Outbound Server Unable to Make a Network Connection

Problem:

The Notification Mailer shows the following error:

Navigation: Oracle Application Manager > Site Map > Administration tab >
Notification Mailer (under Workflow)
Click: Workflow Notification Mailer

Component Details: Workflow Notification Mailer: TEST3 shows an error in Status
Information:

This automatic Service Component has been restarted the maximum of 10 times after
stopping with error. Thus, it has been system deactivated ->
oracle.apps.fnd.cp.gsc.SvcComponentContainerException: Could not start component;
performing rollback -> oracle.apps.fnd.cp.gsc.SvcComponentException: Validation
failed for the following parameters -> {OUTBOUND_SERVER=Unable to make a network
connection.}.

Solution:

Change Outbound Server from EBS application tier server to mail server. The Outbound Server is usually automatically reset as part of the cloning process.

Change OUTBOUND_SERVER from oratestapps.domainname to 10.x.x.x.

Read more »

Setting Up Oracle Alerts To Send Email Notifications

This document shows how to set up Oracle Alerts to send email notifications.

1. Navigate to Alerts and enter the following information:

Application: Application Object Library
Description: Send email Notification
Name: Send Email Notification

Under Periodic > Periodic Details
Frequency: Every N Calendar Days
Days: 1
Start Time: 07:00:00
End Time: 18:00:00
Check Interval: 00:30:00

Keep: 2 Days
End Date:

Select Statement:

select w.notification_id,
w. group_id,
w.message_type,
w.message_name,
rtrim(f.email_address),
substr(f.description,1,30) name,
w.to_user,
substr(w.subject,1,100) message_text
INTO
&notification_id,
&group_id,
&message_type,
&message_name,
&email_address,
&name,
&to_user,
&message_text
from
wf_notifications w,
fnd_user f
where
w.recipient_role = f.user_name and
w.status=’OPEN’ and
trunc(begin_date) = trunc(sysdate)

2. Click the Actions button.

3. Enter the following information:

Actions – Send Email Notification
Action Name: Email User
Description: Send User an email
Action Level: Detail

Action Details – Email User

To: &EMAIL_ADDRESS
Subject: PROD NOTIFICATION:&NOTIFICATION_ID – &MESSAGE_TYPE – &MESSAGE_NAME

Select Text.

Enter the following text into the textbox:

&NAME

Please log in to Oracle Applications and check your Notifications. &MESSAGE_TEXT

Link to Oracle:
http://appsserver.serverdomain.com:8000/OA_HTML/US/ICXINDEX.htm

This is an unattended messaging system. Please do NOT respond to this email.

Oracle Applications

4. Action Sets – Send Email Notification

Seq: 1
Action Set Name: Email Notification
Suppress Duplicates:
Enable:

5. Alert Details – Send Email Notification

Under the Outputs tab:

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