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.
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.
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
¬ification_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
Recent Comments