tag:blogger.com,1999:blog-1755315926100938840.post4467581280911052312..comments2024-03-28T15:16:06.294+03:00Comments on Erman Arslan's Oracle Blog: EBS-- Workflow Notification Mailer diagnosticsErman Arslanhttp://www.blogger.com/profile/07686231074805634082noreply@blogger.comBlogger13125tag:blogger.com,1999:blog-1755315926100938840.post-18722307386611457492019-06-26T03:19:36.610+03:002019-06-26T03:19:36.610+03:00Hi Erman,
Due to some auto reply emails in inbox ...Hi Erman,<br /><br />Due to some auto reply emails in inbox my workflow inbound messages were not processed. Hence we see many emails were in the inbox (IMAP) account.<br /><br />And this results approved emails not processed and showing in the approver's Worklist.<br />This only issue we know when some user complains or we check in the inbox.<br /><br />May I request you to help me,<br /><br />How to monitor the users worklist count to get notified that IMAP has some issue to check ?<br />How to monitor the mail account that some x number of emails laying in the inbox ?<br /><br />Please help how to get notified the above issue ?<br /><br />Thank you.<br />RajeshRajesh Sahuhttps://www.blogger.com/profile/03321487949215256087noreply@blogger.comtag:blogger.com,1999:blog-1755315926100938840.post-40289970494979922852018-07-18T12:12:35.875+03:002018-07-18T12:12:35.875+03:00Hi,
Can you guide me, how to find the port values ...Hi,<br />Can you guide me, how to find the port values of WF notification mailer (smtp & IMAP ), if they are configured with non-default ports ?<br />I queried apps.fnd_svc_components and apps.fnd_svc_comp_params_b tables, but I couldn't find port values. Sundar Kannanhttps://www.blogger.com/profile/14310178009826167012noreply@blogger.comtag:blogger.com,1999:blog-1755315926100938840.post-13130276403359099072017-09-20T19:48:59.466+03:002017-09-20T19:48:59.466+03:00Please use my forum to create an issue and ask you...Please use my forum to create an issue and ask your questions from there.<br />Subscribe to my forum, and ask your question. You can upload files(logs,screenshots) to there as well.<br /><br />Here is the link:<br /><br />http://ermanarslan.blogspot.com.tr/p/forum.html<br /><br /><br />I give tech support through my forum.. (not through emails or through comments)<br /><br />Please create your issue .Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1755315926100938840.post-41615137844206580182017-09-20T11:58:11.618+03:002017-09-20T11:58:11.618+03:00Hi Emran,
can you assist me to configure oracle w...Hi Emran,<br /><br />can you assist me to configure oracle workflow mailer using oracle 365 cloud account, i tried to configure but failed. currently i am trying to configure it in R12.2.4 environment. Note:2077434.1 Configuring an Oracle Workflow Notification Mailer with Cloud E-Mail Servers <br />applied patch as per the document. patch id 24290674. i have installed certificates from office 365 server directly as mentioned here http://oradig.com/configuring-outlook365-imapsmtp-ssl-server-with-oracle-r12-workflow-mailer/Anonymoushttps://www.blogger.com/profile/09478983110269537388noreply@blogger.comtag:blogger.com,1999:blog-1755315926100938840.post-89510486373907412472016-11-03T21:23:45.073+03:002016-11-03T21:23:45.073+03:00This comment has been removed by the author.Anonymoushttps://www.blogger.com/profile/15129327282578622338noreply@blogger.comtag:blogger.com,1999:blog-1755315926100938840.post-51138306809627027042016-11-02T20:00:25.882+03:002016-11-02T20:00:25.882+03:00Also ,please use my forum for ask questions..
Tha...Also ,please use my forum for ask questions..<br /><br />That is, you can open an issue in my forum and ask me your question if you need assistance<br />my forum : http://ermanarslan.blogspot.com.tr/p/forum.htmlAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-1755315926100938840.post-25632136045626296492016-11-02T19:58:46.422+03:002016-11-02T19:58:46.422+03:00The correct syntax is below, please modify your co...The correct syntax is below, please modify your command accordingly.<br /><br />AFJVAPRG -classpath $AF_CLASSPATH -Ddebug=Y -Dprotocol=imap \ <br />-Ddbcfile=$FND_SECURE/.dbc \ <br />-Dserver= -Dport=143 \ <br />-Daccount= -Dpassword= -Dconnect_timeout= 120 \ <br />-Dfolder=INBOX oracle.apps.fnd.wf.mailer.Mailer Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1755315926100938840.post-82692049387544155902016-11-02T19:57:59.906+03:002016-11-02T19:57:59.906+03:00You are running the command wrongly.
You didnt use...You are running the command wrongly.<br />You didnt use -Ddbcfile<br /><br />Check the blog post and write the command properly.<br /><br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1755315926100938840.post-67210811224140095982016-11-02T18:54:28.011+03:002016-11-02T18:54:28.011+03:00This comment has been removed by the author.Anonymoushttps://www.blogger.com/profile/15129327282578622338noreply@blogger.comtag:blogger.com,1999:blog-1755315926100938840.post-4779036207454111852016-04-18T20:00:35.840+03:002016-04-18T20:00:35.840+03:00That column is in AQ$_JMS_TEXT_MESSAGE.
So you sho...That column is in AQ$_JMS_TEXT_MESSAGE.<br />So you should play with AQ$_JMS_TEXT_MESSAGE type and create your query.<br /><br />Here is an example;<br /><br />select wfc.user_data.text_vc <br />from applsys.aq$wf_notification_out wfc<br />where corr_id = 'APPS:ALR';<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1755315926100938840.post-66741719391839971982016-04-18T19:16:26.931+03:002016-04-18T19:16:26.931+03:00Hi ! Thanks for replay.. But this is my problem. ...Hi ! Thanks for replay.. But this is my problem. <br />I dont have alert in wf_notifications table, so i DONT know that notification id.<br />SO, I cannot search by notification_id.<br />Its Alerts and not the normal WF notification.<br />Any other suggestion ? <br />Thanks,LAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-1755315926100938840.post-38141960930804014162016-04-18T18:46:52.194+03:002016-04-18T18:46:52.194+03:00Hi,
Check this way;
use $FND_TOP/sql/wfmlrdbg.sq...Hi,<br /><br />Check this way;<br /><br />use $FND_TOP/sql/wfmlrdbg.sql with notification ids.<br />wfmlrdbg.sql will produce you lots of details.<br />(use the notification id gathered from wf_notifications)<br />If you can link wf_notifications and applsys.aq$wf_notification_out and bring it further.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1755315926100938840.post-50550428957054234892016-04-18T18:34:31.056+03:002016-04-18T18:34:31.056+03:00Hi!
Any Idea how to query wf_notification_out user...Hi!<br />Any Idea how to query wf_notification_out user_data column ?<br />For example If I want to see that specific alert went out , i cannot query on that data..<br />Tried but not working:<br />SELECT user_data.GetValueForParameter('NOTIFICATION_ID') NOTIFICATION_ID<br /> ,A.user_data.GetValueForParameter('ROLE') ROLE<br /> ,A.user_data.GetValueForParameter('LANGUAGE') LANGUAGE<br /> , A.user_data.GetValueForParameter('GROUP_ID') GROUP_ID<br /> ,A.user_data.GetValueForParameter('TERRITORY') TERRITORY<br /> ,A.user_data.GetValueForParameter('Q_CORRELATION_ID') Q_CORRELATION_ID<br /> ,A.MSG_STATE<br /> ,A.CORR_ID<br /> from applsys.aq$wf_notification_out A where corr_id='APPS:ALR:'<br /> ;<br />Thanks,L<br />Anonymousnoreply@blogger.com