Your Doorstep to the Temple of Oracle

Oracle EBS

Workflow Java Mailer FAQ

Posted by appsdba11i on May 1, 2011

This FAQ is to provide common Actions / Answers for the Workflow Java Mailer
Questions and Answers

What Email Server Software is certified?

Email Server Software is not certified for use with the Java Mailer where only an IMAP version 4 compliant server and an SMTP server are required.

How to access the Workflow Java Mailer without logging into OAM?

a. Click on the Workflow Administrator Web (New) responsibility.

b. In the upper right under Oracle Applications Manager, click on Workflow Manager.

How to Start or Stop the Workflow Java Mailer?

a. Log into OAM and navigate to:

Sitemap > Under Workflow > Service Components > Select Workflow Notification Mailer Service > Click on Stop or Start.

b. Wait a minute and verify that mailer component stays in a STARTING or STOPPING state.

How to increase the log level for the Workflow Mailer?

a. Log into OAM and navigate to:

Sitemap > Under Workflow > Service Components > Select Workflow Notification
Mailer Service > Edit > Advanced.

b. On step 2 of 8, for the log level section, click on the list of values selecting Statement.

c. Click on Next to step 4 and click on Finish. The workflow mailer service will need to be restarted in order to pick up the change.

How to increase the log level for the Workflow Components?

a. Log into OAM and navigate to:

Sitemap > Under Workflow > Service Components > Select Workflow Notification
Mailer Service > Click on the Workflow Mailer service to the right > Edit > Edit Service Parameters

In this setting:

SVC_WRITE_DIAG_TO_GSM_LOG=Y:SVC_CONTAINER_LOOP_SLEEP=10:SVC_CONTAINER_READ_TIMEOUT=10:

SVC_CONTAINER_LOG_LEVEL=4:SVC_COMP_MONITOR_LOOP_SLEEP=60:SVC_COMP_MONITOR_ONDEMAND_FREQ=300:
SVC_COMP_MAX_ERROR_COUNT=5:SVC_PROXY_SET=NONE:SVC_class=MsoNormal
style=’margin-left:1.0in’

change SVC_CONTAINER_LOG_LEVEL=4 to SVC_CONTAINER_LOG_LEVEL=1

b. Click OK > Save > select Workflow Mailer Service > Start

Wait a minute and verify that mailer component stays in STARTING state. Do the same for Agent Listener services. Simply reverse this setting the level back to 4 to reduce the logging level.

NOTE: Not changing the log level back to a lower level will generate larger log files.
Where are the mailer log files located?

On the concurrent tier, navigate to:

a. $APPLCSF or $APPLLOG directory.

b. $> ls -ltr FNDCPGSC*.txt

What Workflow changes are required for cloning an instance?

a. Please be sure to complete section 3 of Note 230672.1 Cloning Oracle Applications Release 11i with Rapid Clone .

b. Please be sure to input the new IMAP and SMTP server names and passwords within the definition of the Workflow Mailer in OAM.
Why can Workflow email notifications be received, but the responses are not processed?

a. This could be associated to the inbound thread count set for the mailer being set to 0. The value is set on Step 2 of the configuration of the Workflow Mailer in OAM. If the value is changed, the configuration must be saved and the workflow notification mailer service will need to be re-started.

b. An override address may be set where all email notifications are sent to the override address. To check this, click on the “Workflow Notification Mailer” link
and click on the Set Override Address button. If the Current Override Address has an email address, all Workflow Email Notifications are being sent to that address. To change it to NONE, click on Submit with no value in the * New Override Address field. If the value is changed, the configuration must be saved and the workflow notification mailer service will need to be re-started.
How to send a test email notification?

(a) Login to OAM

(b) Navigate to: Workflow Manager (click Go).

(c) Click on the ‘Service Components’ link at the bottom left side of the screen.

(d) Click on the Workflow Notification Mailer service component.

(e) Click on the ‘Test email’ link at the top right of the screen and follow the process.

(f) Select a valid role from the list of values for the test.
How to check the email template within OAM?

a. Log into OAM as the SYSADMIN user.

b. Select Workflow Manager from the Drop Down list.

c. Select Service Components

d. Highlight the radio button next to the Workflow Mailer Service and select “View Details” for the mailer.

e. On this screen there is a section named Templates.

f. What is selected as the Mail Template is the current email template used. If the template is changed, the workflow mailer service must be re-started in order to adopt the change.
How to turn off notifications for a user?

1. Logged into applications, click on the Preferences link in the upper right hand corner.

2. Change the Email Style under Notifications to: Do not send me email and save.
Why would Workflow Email Notifications not be received for a user, but are for others?

The notification preference may not be set to receive email notifications for the user and can be checked by performing the following steps:

1. Log into applications.

2. In the upper right hand corner of the screen, click on Preferences.

3. Within the Notifications section for Email Style, the value must be set to a value other than: Disabled or Do not send me mail.
How to determine the Notification Perference for a user without logging into Applications?

1. select name, display_name, notification_preference, email_address from wf_local_roles where name = ‘user_name’;

2. For a non application user or an ADHOC user/ supplier, then check in table wf_local_roles table:

select name, notification_preference from wf_local_roles where name =’user_name’;

If the value for notification_preference is not as expected, update the value in this table. Assuming the user requires MAILHTML as the notification preference:

update WF_LOCAL_ROLES
set notification_preference = ‘MAILHTML’
where name = ;

Workflow Java Mailer FAQ (Doc ID 562551.1)

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s