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.
Definition ID: 10006 Name: Workflow Notification Mailer Startup Mode: Automatic Container Type: Oracle Applications GSM Inbound Agent: Workflow Notification In Queue Outbound Agent: Workflow Notification Out Queue Correlation ID: <blank> 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.}. Parameters were -> {INBOUND_MAX_IGNORE_SIZE=1000, INBOUND_MAX_LOOKUP_CACHE_SIZE=100, ATTACH_IMAGES=Y, INBOUND_UNSOLICITED_THRESHOLD=2, ALLOW_FORWARDED_RESPONSE=Y, NODENAME=WFMAIL, SEND_UNSOLICITED_WARNING=Y, AUTOCLOSE_FYI=Y, PROCESSOR_READ_TIMEOUT_CLOSE=N, INBOUND_PROTOCOL=IMAP, ATTACHED_URLS=WFMAIL:ATTACHED_URLS, TEST_ADDRESS=NONE, PROCESSOR_OUT_THREAD_COUNT=1, EXPUNGE_ON_CLOSE=Y, ATTACH_STYLESHEET=Y, OUTBOUND_CONNECTION_TIMEOUT=120, INBOUND_MAX_RET_EMAIL_SIZE=100, MAX_INVALID_ADDR_LIST_SIZE=100, PROCESSOR_MAX_LOOP_SLEEP=60, SEND_ACCESS_KEY=N, PROCESSOR_IN_THREAD_COUNT=0, FRAMEWORK_APP=1, CLOSED=WFMAIL:CLOSED, INBOUND_FETCH_SIZE=100, SUMMARY=WFMAIL:SUMMARY, ENABLE_STYLESHEET=N, PROCESSOR_ERROR_LOOP_SLEEP=60, OPEN_MAIL_FYI=WFMAIL:OPEN_MAIL_FYI, FRAMEWORK_RESP=20420, ALTERNATE_EMAIL_PARSER=oracle.apps.fnd.wf.mailer.DirectEmailParser, INBOUND_PASSWORD=_@@$@^!@@$808946^4@@000!!6#68@!$90^646##`@^|0AB+^@0|0}80&}0|&8$B0}#0%|@00, HTTP_USER_AGENT=Mozilla/4.76, RESET_NLS=N, PROCESS=PROCESS, OPEN_MAIL_DIRECT=WFMAIL:OPEN_MAIL_DIRECT, PROCESSOR_LOOP_SLEEP=5, MESSAGE_FORMATTER=oracle.apps.fnd.wf.mailer.NotificationFormatter, REPLYTO=dbadmins@domainname, FRAMEWORK_USER=0, CANCELED=WFMAIL:CANCELED, OUTBOUND_PROTOCOL=SMTP, DISCARD=DISCARD, ACCOUNT=domainsrvoracle, FROM=Oracle System, SEND_CANCELED_EMAIL=Y, PROCESSOR_DEFER_EVTDATA_READ=Y, WARNING=WFMAIL:WARNING, PROCESSOR_MAX_ERROR_COUNT=10, INBOUND_CONNECTION_TIMEOUT=120, HTMLAGENT=http://oratestapp03.domainname:8005/pls/TEST3, INBOX=INBOX, OPEN_INVALID_MORE_INFO=WFMAIL:OPEN_INVALID_MORE_INFO, OUTBOUND_SSL_ENABLED= Details Container: Workflow Mailer Service Max Error Count: 10 Inbound Thread Count: 0 Outbound Thread Count: 1 Log Level: Error Processor Read Wait Timeout: 10 Processor Min Loop Sleep: 5 Processor Max Loop Sleep: 60 Processor Error Loop Sleep: 60 Processor Close on Read Timeout: N EMail Servers General Mailer Node Name: WFMAIL Email Parser: oracle.apps.fnd.wf.mailer.TemplatedEmailParser Alternate email parser: oracle.apps.fnd.wf.mailer.DirectEmailParser Expunge Inbox on Close: Y Inbound EMail Account Inbound Protocol: IMAP Inbound Server Name: 10.1.0.117 Username: domainsrvoracle Inbox Folder: INBOX Inbound connection time out: 120 Inbound message fetch size: 100 Maximum Ignore List size: 1000 Inbound SSL Enabled: N Outbound EMail Account Outbound Protocol: SMTP Outbound Server Name: oratestapp03.domainname Test Address: NONE Outbound connection time out: 120 Outbound SSL Enabled: N EMail Processing Processed Folder: PROCESS Discard Folder: DISCARD Allow Forwarded Response: Y Message Generation Send From: Oracle Procurement System Reply-to Address: dbadmins@domainname HTML Agent: http://oratestapp03.domainname:8005/pls/TEST3 Message Formatter: oracle.apps.fnd.wf.mailer.NotificationFormatter Framework User: 0 Framework Responsiblity: 20420 Framework Application ID: 1 Framework URL timeout: 30 Attach images to outbound emails: Y Attach stylesheet to outbound email: Y Autoclose FYI: Y Direct response: N Reset NLS: N Inline Attachments: N Send warning for unsolicited e-mail: Y Send e-mails for canceled notifications: Y Templates Attached URLs: Workflow URL Attachment Outbound Closed Notification: Workflow Closed Mail Outbound Cancelled Notification: Workflow Canceled Mail Invalid Response Notification: Workflow Invalid Mail Open Notification: Workflow Open Mail (Templated) Open Notification (Direct Response Parsing): Workflow Open Mail (Direct) Open FYI Notification: Workflow Open FYI Mail Outbound Summary Notification: Workflow Summary Mail Outbound Warning Notification: Workflow Warning Mail Open Notification (More Information Request): Workflow Open Mail (More Information Request) Outbound HTML Summary Notification: Workflow Summary Mail (HTML) Scheduled Events Last Updated: 14-02-2012 10:50:13 Event Started Running Next Executes Last Executed Interval(minutes) Failures Job ID What Launch Summary Notifications 12:00:00 AM Feb 04 2010 AST Running 12:00:00 AM Feb 04 2010 AST 12:00:00 AM Jun 30 2005 AST 1440 0 104 FND_SVC_COMPONENT.EXECUTE_REQUEST (p_component_request_id => 10000); Tags -- Unsent message follows --: UNDELVRD Host unknown: UNDELVRD The following addresses had delivery problems: UNDELVRD Transcript of session follows: UNDELVRD Auto-Reply: Unavailable Auto-reply: Unavailable Returned mail: Unavailable SENDMAIL: Ignore POSTMASTER: Ignore Warning For Unsolicited Mail: Ignore Warning: Your previous response to this message was invalid: Ignore Warning: Your previous response to this message was invalid: Ignore
I want to write a script which will give me a count of unread mails from INBOX of workflow mailer in R12 apps. Script also should send a mail to our DBA account …..!!!!!!!!!
Please give me a solution 🙁