Hi Atul

How to enbale OEM for Oracle11i?

Thanks

umair

Hi atul
I want to configure workflow purchage notification mailer.We would like to receive my Notifications into my Inbox. Please help me to configure/setup my Oracle workflow Notification Settings for the email server or clinet.
Please assist me to allow the Notifications to be sent to the Required emails automatically after the manager responds to the user’s request.My application version is 12.0.4.
Please explain :What we need to set for below Parameters
Outbound EMail Account (SMTP)
Server Name
Inbound EMail Account (SMTP)
Server Name
Inbound Processing
server Name
User name:
Password:
Reply to address:

Thanks
Abhishek

Hi Atul

I had configured the workflow mailer but after 8 hrs all the concurrnet request are giving signal 11 error.This error is not comming in the test server.When i disabled the WFNM the production is working fine.

Can please tell me what is the poblem bhind this error and how can I get rid of this problem.

Regards
Lalit

Hi Atul,

Thank you for your imediate response.
Can you please tell how can i resolve this signal11 error.
Please help me i am facing lot of problem due to this issue.

Regards,
Lalit

Very good suggestions

1. We have R12 Oracle Apps and in order to configure workflow notifications mailer do we need to configure SMTP & IMAP Oracle server Box or we have to take the IP of SMTP & IMAP from sysadmins Incase if we have to configure can you please guide me how do we go about it ??

SMTP server is required for outgoing mails only
and
IMAP server is required for only incoming mails

If you only want outgoing mails (for alerts) then you don’t need IMAP server at all (In workflow notification mailer configuration screen under “Inbound EMail Account (IMAP)” don’t select check box “Inbound Processing”. By doing this notification mailer will not do any validation for IMAP server and incoming mail processing with not activate.
For outgoing mails, You don’t need to configure SMTP server. Use any existing SMTP server (or SMTP relay server ) (only requirement is that Concurrent Manager should be able to ping SMTP server and port 25 (SMTP server port) should be open between CM node & SMTP server)

2. We want use Workflow notification mailer only for alert manager and not for other modules since we use a pl/sql package to send mail.

Alert manager started using Workflow Notification mailer to send notification from ATG Rollup 4 (check with oracle support/ATG team to confirm)

Hi Atul,

I want to include the url of workflow notification in the email notification so that the user can directly go to the notification page from email notificaiton in rel 12.

How to acheive this?

Thanks
rajesh

Hi

I have configured the workflow mailer(11.5.10.2) but the notification test fail with the following msg error :
javax.mail.MessagingException: 501 Sender domain must exist

Any help?
Thanks in advance.
Hakim

Hi,

Thank you for your immediate response.
Find below the result of the test :
——————————————–
EHLO bones.otalgerie.com
MAIL FROM: abdelkrim.kaci@otalgerie.com
RCPT TO: abdelkrim.kaci@otalgerie.com
Subject:
hakimmmmmmmmmmmmmm
.
quit
503 bones.otalgerie.com Duplicate HELO/EHLO
501 Sender domain must exist
503 Need MAIL before RCPT
——————————————–

I count on your help.
Regards

Hi,

I’m using the smtp of HP-UX server (our Oracle Applications Server)

Regards

Setting Inbound to 0 means notification from User to Workflow Notification Mailer will not work.

Inbound to 1 means Inbound email notification is enabled.

1 means enabled
0 means disabled

Outbound is from Workflow Notification Mailer to User , 1 means enabled and 0 means disabled

Which documentation you are following for
“Schedule Event” ?

Hi Atul,

I am new in Oracle Apps.Is there is any document for maintaing and troubleshooting workflow mailer?

Thanx in advance..
Pokhraj

Dears Atul / Guyes

on ERP 12i we have configured notification mailer succussfully via IMAP and working fine by sending notifications to the users, after sometime the notificatin cannot connect to Exchange Server by saying as below :
Inbound EMail Account (IMAP)
* Server Name= Our Exchange Server
“Unable to make a network connection.”

SSL is enabled

we tested from other server by typing
telnet exchange server 993
connected
but from application server
$ telnet Exchnage IP 993
Trying Exchnage IP…
telnet: Unable to connect to remote host: Connection refused

anyone can help please ?

Dear Atul / guys

thanks for your reply, the Exchange Team has indication that there is some other system in the same subnet range is connected both on:

172.30.50.*

and also from other subnet from windows we could connected to the exchange Server successfully.
So the Exchange Team have their prove.

I do appreciate if someone has an idea.

Alihaddawi

Thanks again,

Since we have other server in the same subnet as dbTier can telnet via 993 port successfully than means there is no Firewall to block it from accessing exchange server.

We have two tiers Scenario of our Oracle Apps.

dbTier responses to telnet exchange id 993

appsTier doesn’t response to telnet exchange id 993

I feel we need Unix Admin has good experience to help ..

BR,

Hi All/atul,

I want to prepare sheel script for monitoring workflow mails if it is struck in the Inbox.Please advise me………..

@ Nikhil,
If you want to send notifications in user accounts and would like to see those notifications in email server then you need to configure SMTP server (or use existing SMTP server – your CM should be able to connect to SMTP server) and then use configuration notification mailer screen in Oracle Application Manager.

@ Nikhil

For mail server (SMTP) server on windows, search on google about free SMTP/mail server for windows and then install.

Then configure mail client like outlook express or thunderbird to connect to mail (smtp) server on local machine.
Mail server usually runs on port 25 .

Once you can send and receive mail to your local account (local smtp server) thwen login to OAM (Oracle Application Manager) and configure Workflow Notification Mailer as shown in this post.

can anybody here tell me that how could i configure Reminder of workflow notofcation so that incase of any pending again an automatic reminder to this notification could be generated.

Hi Atul,

As per you1.
For Outbound Notification, CM (Concurrent Manager) node should be able to connect to SMTP (Simple Mail Transfer Protocol) server/relay.
2.For Inbound Notification (Optional), CM node should be able to connect to IMAP (Internet Message Access Protocol) Server.
For CM node need to connect SMTP/IMAP server what confu setup need to be done.
Regards
Sanjeev

Hi Atul,

I’ve do the setup as you mentioned. Now the status of Workflow Notification Mailer is running, but when I Test Mailer to send message to my email, I didn’t get the message on my email

We want the from address of particular notifications to be different from the general workflow mailer account. is this achievable ?. If yes, how please

Hello Atul,

Just a quick question. May I know which table stores the details reg. the Inbound and outbound email account (such as the inbound server name, username, protocol etc.) ?

Thanks
Muthu

How enable smtp in linux

Hello

I am using R12(12.1.1) Application ,i want to configure IMAP server on my application.

For this its required separate IMAP server ? or we can configure in SMPT

We have already configure SMPT for outbound and wrking fine..

Please suggest me..Thanx Santu..

Hi,

We want to configure oracle notification mailer on R12(Linux Server).
Its kind of approval notification,the user should recieve email through which he can Approve/Reject the request from mail itself is this possible?

What are the steps to achieve this on linux server.?
Can you provide the same for me.

Thanks a Lot.

Hello All,

I am new to Oracle Apps and learning a lot reading posts on OnlineAppsDBA.com.

Per the blogs:

SMTP server is required for outgoing mails only
and
IMAP server is required for only incoming mails

We have a requirement to send workflow & email notifications to PO buyers & approvers (level-1 and level-2 approvers).

Please advise, if I need to perform any configuration in Purchasing Module in Oracle R12.

thanks.

I am getting Performing alert “TEST_ALR” (ROUTINE=alepaa) (FILE=alr/lib/alepea.c) (LINE=1065)
Connecting to “APPS (101)” (ROUTINE=alepaa) (FILE=alr/lib/alepea.c) (LINE=1128)
Performing action set “TEST_ALR_AS” (ROUTINE=alepea) (FILE=alr/lib/alepea.c) (LINE=277)
error and so not able to receive any email notifications as well.

What should be done on this.

Hi –

Is there a script to check the workflow mailer services from unix and bounce them? Sometimes the mailer says it is working fine, but it is not. Restarting the services seems to wake them up.

Thank-you,
S3