11i & r12 workflow mailer configuration guide · configuration of workflow mailer ... smtp...
TRANSCRIPT
11i & R12
Workflow Mailer
Configuration
Guide
First things first ................................................................................................................... 3
IMAP & SMTP Server Details ....................................................................................... 3
Dedicated Email ID......................................................................................................... 3
Verify Access to SMTP Server....................................................................................... 3
Folder Creation ............................................................................................................... 5
Verify Access to IMAP Server ....................................................................................... 5
Configuration of Workflow Mailer..................................................................................... 7
Step 1 .......................................................................................................................... 7
Step 2 .......................................................................................................................... 8
Step 3 .......................................................................................................................... 8
Step 4 .......................................................................................................................... 9
Step 5 .......................................................................................................................... 9
Step 6 ........................................................................................................................ 10
Step 7 ........................................................................................................................ 11
Step 8 ........................................................................................................................ 12
Step 9 ........................................................................................................................ 13
Step 10 ...................................................................................................................... 14
Step 11 ...................................................................................................................... 14
Step 12 ...................................................................................................................... 15
Step 13 ...................................................................................................................... 16
Step 14 ...................................................................................................................... 17
Step 15 ...................................................................................................................... 17
Step 16 ...................................................................................................................... 18
Step 17 ...................................................................................................................... 19
Step 18 ...................................................................................................................... 20
Step 19 ...................................................................................................................... 21
This ensures your workflow mailer is up and running. Hoooooray !!!!!!!!!!!.......... 21
First things first
IMAP & SMTP Server Details 1. Make sure you have fully functional IMAP & SMTP servers.
2. Obtain the IP address and hostname of the IMAP and SMTP server from your
Sysadmin.
Dedicated Email ID 3. Request the Sysadmin to create a dedicated email id to configure Workflow
Mailer.
Verify Access to SMTP Server
Assumptions SMTP Server Name smtp.abc.com Concurrent Manager Server Name
(Where Java Mailer service will be
running)
cm.abc.com
Application Owner applabc Dedicated Email Id [email protected] Your Email Id [email protected] (official) and [email protected]
(personal)
(wondering why two email-id’s – hold on to
that question for sometime)
Step Login to cm.abc.com as applabc user. Command 1 telnet smtp.abc.com 25 (25 is the default SMTP port)
Expected Output
(Sample)
Trying... Connected to SMTP.abc.com. Escape character is '^]'. 220 smtp.abc.com ESMTP Service (Lotus Domino Release 8.0.1) ready at Wed, 8 Oct 2008 15:56:11 -0400
Command 2 EHLO cm.abc.com
Expected Output
(Sample)
250-smtp.abc.com Hello cm.abc.com ([10.10.10.10]), pleased to meet you 250-HELP 250-SIZE 15360000 250 PIPELINING
Command 3 MAIL FROM: [email protected]
Expected Output
(Sample)
250 [email protected]... Sender OK
Command 4 RCPT TO: [email protected]
Expected Output
(Sample)
250 [email protected] ... Recipient OK
Command 5 DATA
Expected Output
(Sample)
354 Enter message, end with "." on a line by itself
Command 6 Subject: Test email from cm.abc.com
Expected Output
(Sample)
[No output here, just stays in the next line, waiting to enter the mail body]
Command 7 Test
Expected Output
(Sample)
[No output here, just stays in the next line, waiting to enter the mail body]
Command 8 .
Expected Output
(Sample)
250 Message accepted for delivery
Command 9 Quit
Expected Output
(Sample)
quit 221 smtp.abc.com SMTP Service closing transmission channel Connection closed by foreign host.
The above test validates the email sending functionality of the SMTP server. Check
the inbox of [email protected] and make sure you had received the email.
In some organizations, additional policies might be imposed at the SMTP server level
to restrict emails being sent to non-official ids (in our assumption it is anything other
than @abc.com ie., [email protected] ).
Now lets do a test to check for any such policies. Repeat all steps as mentioned in
the above table. For command 4 Replace [email protected] to [email protected]
Error message “554 Relay rejected for policy reasons. “, will be reported, if
restrictions are imposed.
A message like this “250 [email protected] ... Recipient OK” means you are good to go.
Even the “554 Relay rejected …” error message is not a show stopper to configure
the workflow mailer, provided this error message is reported only for non @abc.com
email id. You can still go ahead and configure the workflow mailer, with the only
drawback being you won’t be able to send any notification to non-official email id.
This will pose as a threat if you are planning to use say, Oracle Supplier Module
wherein when you register a new supplier, workflow will send out email notifications
to your suppliers with the username and password details.
Ok now is that we had verified our email id and SMTP server, lets do two more tests.
Folder Creation
4. Login to the corporate email application using the newly created email id ie.,
5. Create two folders called PROCESS and DISCARD (not necessarily these
names, it can be anything). In general two folders are required – 1) To place
the emails that were processed by Workflow Mailer and 2) To place spam kind
of messages (received) which are meant to be discarded.
6. Try sending an email from [email protected] to your id ([email protected])
and make sure you receive the email.
Verify Access to IMAP Server
Assumptions
IMAP Server Name imap.abc.com
Step Login to cm.abc.com as applabc user. Command 1 telnet imap.abc.com 143 (143 is the default SMTP port)
Expected Output
(Sample)
Trying... Connected to imapserver.abc.com. Escape character is '^]'. OK Domino IMAP4 Server Release 8.0.1 ready Thu, 9 Oct 2008 15:25:52 -0400
Command 2 10 login mine <mine user password> [ Note: 10 is part of the command]
Expected Output
(Sample)
10 OK LOGIN completed
Command 3 10 select "INBOX"
Expected Output
(Sample)
* 181 EXISTS * 0 RECENT * OK [UNSEEN 20] Message 20 is first unseen * OK [UIDVALIDITY 1] UIDs valid * OK [UIDNEXT 182] Predicted next UID * FLAGS (\Flagged \Seen \Answered \Deleted \Draft) * OK [PERMANENTFLAGS (\Flagged \Seen \Answered \Deleted \Draft \*)] Permanent flags 10 OK [READ-WRITE] SELECT completed
Command 4 10 select "PROCESS"
Expected Output
(Sample)
* 0 EXISTS * 0 RECENT * OK [UIDVALIDITY 2] UIDs valid * OK [UIDNEXT 1] Predicted next UID * FLAGS (\Flagged \Seen \Answered \Deleted \Draft) * OK [PERMANENTFLAGS (\Flagged \Seen \Answered \Deleted \Draft \*)] Permanent flags 10 OK [READ-WRITE] SELECT completed
Command 5 10 select "DISCARD"
Expected Output
(Sample)
* 17 EXISTS * 0 RECENT * OK [UIDVALIDITY 1] UIDs valid * OK [UIDNEXT 18] Predicted next UID * FLAGS (\Flagged \Seen \Answered \Deleted \Draft) * OK [PERMANENTFLAGS (\Flagged \Seen \Answered \Deleted \Draft \*)] Permanent flags 10 OK [READ-WRITE] SELECT completed
Command 6 10 logout
Expected Output
(Sample)
* BYE logging out 10 OK LOGOUT completed Connection closed by foreign host.
In the above table we verified two things 1) Access to IMAP Server 2) Accessibility to
the folders that will be used by workflow mailer.
Now you are all set to configure the Workflow Mailer.
Configuration of Workflow Mailer
Step 1
Login as Sysadmin -> System Administration -> Workflow
Step 2
Click on the x symbol Next to Notification Mailers
Step 3
Click on Edit
Step 4
Click on Advanced
Step 5
Click Next
Step 6
Click Next
Represents the maximum number of times oracle apps will try connecting to the smtp server to obtain a connection in case of dis-connectivity / error before stopping workflow mailer.
Step 7
Make sure you had provided valid details for IMAP Inbound server name, Username,
password and SMTP Outbound Server Name, before clicking on next.
Click Next
At this stage following validation activities will be performed by Oracle Apps.
• Connectivity to IMAP and SMTP server
• Workflow mailer user Information (email id and password verification)
• Verify Process and Discard folder
IMAP server name.
Valid Email Id.
SMTP server name.
Step 8
Verify Reply-to Address & HTML Agent value before clicking on Next and also enable
Autoclose FYI if its not checked.
Click Next
Step 9
Click Next
Step 10
Click Next
Step 11
Click Next
Step 12
Click Finish
Step 13
At this time, the workflow mailer should be started. To verify the status, Click on
Service Components.
Step 14
Check for agents before starting Workflow Notification Mailer (if its still down).
Enter % in the search window.
Step 15
Start Workflow Notification Mailer after making sure the agents are running (as in
the below picture).
Step 16
Select Start and click Go.
Step 17
Click Ok.
Step 18
To check on the status, click on the refresh button on the browser toolbar or F5 and NOT FROM THE DROP DOWN LIST.
Step 19
The status for Workflow Notification Mailer should be with the tick mark and running.
This ensures your workflow mailer is up and running. Hoooooray !!!!!!!!!!!