Sunday, January 23, 2011

How to purge e-mail notifications from the Workflow queue

How to purge e-mail notifications from the Workflow queue

Some times Due to large number of e-mail notifications to accumulated in the queue Workflow mailer will not start,To fix this issue we need purge the notifications from the Workflow queue.


The below outlines the steps, Please take proper backup before performing the below.

1) You need to update the notifications you do not want sent, in the WF_NOTIFICATIONS table.

2) Check the WF_NOTIFICATIONS table as below. Records where status = 'OPEN' and mail_status = 'MAIL' are notifications that will have an e-mail notification sent.

SQL> select notification_id,status,mail_status,begin_date from WF_NOTIFICATIONS where status = 'OPEN' and mail_status = 'MAIL';

3) This should show you which notifications are waiting to be e-mailed.

4) To update a notification so that it will not get e-mailed. Set the MAIL_STATUS = 'SENT'. The mailer will think the e-mail has already been sent and it will not send it again.

SQL> update WF_NOTIFICATIONS set mail_status = 'SENT' where mail_status = 'MAIL';

-> This will update all notifications waiting to be sent by the mailer.

5) Then run the script wfntfqup.sql to purge the WF_NOTIFICATION_OUT queue and rebuild it with data currently in the WF_NOTIFICATIONS table. This is what purges all notifications waiting in the queue to be sent.Only the ones where mail_status = 'MAIL' and status = 'OPEN' will be placed in the WF_NOTIFICATION_OUT queue and sent by the mailer.

SQL>sqlplus apps/apps_pwd @$FND_TOP/patch/115/sql/wfntfqup APPS APPS_PWD APPLSYS

6) Now you can start your WF Containers and then Mailer

63 comments:

  1. Hi,

    Thanks, that was very useful information, one quick question on above.

    How can we change the status in WF_NOTIFICATIONS to 'CLOSED' from 'OPEN' from application.

    Thanks in advance...

    ReplyDelete
  2. Thanks a lot for sharing this pretty useful information, keep updates regularly...
    Regards,
    SAP training in chennai|SAP course in chennai|SAP Training in Chennai|sap training in Chennai

    ReplyDelete
    Replies
    1. Java Training Institutes Java Training Institutes Java EE Training in Chennai Java EE Training in Chennai Java Spring Hibernate Training Institutes in Chennai J2EE Training Institutes in Chennai J2EE Training Institutes in Chennai Core Java Training Institutes in Chennai Core Java Training Institutes in Chennai

      Delete
    2. Java Online Training Java Online Training Java Online Training Java Online Training Java Online Training Java Online Training

      Hibernate Training Institutes in ChennaiHibernate Training Institutes in Chennai Hibernate Online Training Hibernate Online Training Hibernate Training in Chennai Hibernate Training in Chennai

      Delete
  3. Awesome Post! I like writing style, how you describing the topics throughout the post. I hope many web reader will keep reading your post at the end, Thanks for sharing your view.
    Regards,
    Angularjs training in chennai|Angularjs training chennai|Angularjs course in chennai|Angularjs training center in Chennai

    ReplyDelete
  4. Learning new technolgoy would help oneself at hard part of their career. And staying updated is the only way to survive in current position. Your content tells the same. Thanks for sharing this information in here. Keep blogging like this.

    JAVA J2EE Training in Chennai | JAVA Training in Chennai | Hadoop training in chennai

    ReplyDelete
  5. Excellent post!!! In this competitive market, customer relationship management plays a significant role in determining a business success. That too, cloud based CRM product offer more flexibility to business owners to main strong relationship with the consumers. Salesforce Training Institutes in Chennai | Salesforce Training in Chennai

    ReplyDelete
  6. Paris airport transfer - Parisairportransfer is very common in Paris that provides facilities to both the businessmen and the tourists. We provide airport transfers from London to any airport in London and also cruise transfer services at very affordable price to our valuable clients.

    Paris taxi
    Paris airport shuttle
    paris hotel transfer
    paris airport transfer
    paris shuttle
    paris car service
    paris airport service
    disneyland paris transfer
    paris airport transportation
    beauvais airport transfer
    taxi beauvais airport
    taxi cdg airport
    taxi orly airport

    ReplyDelete
  7. This informative article is really includes much bigger information about This kind of Topic.blog management

    ReplyDelete
  8. Quite useful information, it helped me much to avoid mail overflow issues.
    Regards,
    JAVA Training|JAVA Training in Chennai|java courses

    ReplyDelete
  9. Hi Dude,
    Awesome Post!!! With unique content, I really get interest to read this post. I hope this article help many of them who looking this pretty information.
    Regards,
    Hadoop Training in Chennai|Big Data Training Chennai|Best Hadoop Training in Chennai

    ReplyDelete
  10. Useful Information
    one and only affiliate agency in south INDIA, earn money online from affiliate network in india

    ReplyDelete
  11. Well Said, you have furnished the right information that will be useful to anyone at all time. Thanks for sharing your Ideas.
    Node JS training in chennai | Node JS training institute in chennai

    ReplyDelete

  12. useful information

    Online recruitment for bank jobs and government jobs and you can get Notification and application to apply online for bank jobs and govt jobs

    ReplyDelete
  13. GK Updates (GK), Latest Current Affairs, General knowledge, Current Affairs, Daily Current Affairs, GK, Todays GK, Daily GK Updates,This Year Latest Current Affairs, India Current Affairs GK, General, Knowledge, Quiz, Awareness, Questions, Answers, Explanation, Interview, Entrance, GK,Exams.

    ReplyDelete
  14. Excellent post!!!. The strategy you have posted on this technology helped me to get into the next level and had lot of information in it.
    cloud computing training in chennai | cloud computing courses in chennai

    ReplyDelete
  15. Useful Information……
    Recruitment voice contains Daily GK Updates, Bank Recruitment, Government jobs, Bank jobs, Interview Tips, Banking News, GK Updates and Latest Jobs. @ http://recruitmentvoice.com

    ReplyDelete
  16. Nice Information :
    Telugu Cinema Contains Telugu Cinema News, Latest Movie Reviews, Actor, Actress, Movie Galleries And Many More @ http://www.telugucinema.com/

    ReplyDelete
  17. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, OAF, ADF, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete
  18. PHP provides the best option to build the website where we can design our website in a very interactive manner that provides better functioning in data management.
    PHP Training in Chennai | PHP course in Chennai

    ReplyDelete
  19. Nice Information:
    Telugu Cinema Contains Telugu Cinema News, Latest Movie Reviews, Actor, Actress, Movie Galleries And Many More Telugu Cinema News

    ReplyDelete
  20. Nice Information
    one and only affiliate agency in south INDIA, earn money online from affiliate network in india

    ReplyDelete
  21. Useful Information……
    Recruitment voice contains Daily GK Updates, Bank Recruitment, Government jobs, Bank jobs, Interview Tips, Banking News, GK Updates Bank Recruitment

    ReplyDelete
  22. Interesting Post! Thank you for sharing the recent technological updates.
    Regards,
    PHP Training in Chennai|PHP Training

    ReplyDelete
  23. Thanks for sharing this informative content that guided me to know the details about the training offered in different technology.
    Microstrategy training in chennai

    ReplyDelete
  24. • Very good effort in collecting information.........
    tib co training in chennai

    ReplyDelete
  25. Well Said, you have furnished the right information that will be useful to anyone at all time. Thanks for sharing your Ideas.
    Web Designing Course in Chennai | web designing training in chennai

    ReplyDelete
  26. Thanks for sharing this unique and informative content which provided me the required information.
    Java Training in Chennai | JAVA Course in Chennai

    ReplyDelete
  27. Nice Information

    New Year 2017 - New Year 2017 Images Happy New year Wishes 2017, Happy New Year 2017, New Year Wishes, New Year Greetings

    ReplyDelete
  28. Get Top packing and moving services at Dealkare. We have listed best packers and movers on our website.
    Packers and movers in raj nagar extension

    ReplyDelete
  29. Get Indian Government exams information at FindSarkariJobs.
    SSC Exam Result 2017

    ReplyDelete
  30. Thank you for this valuable information. I have got some important suggestions from it. I'm working in Brave Technologies Private Limited. We provides lowest price of ERP Software for our clients. Contact us on info@bravetechnologies.in. ERP in Chennai | ERP Providers in Chennai

    ReplyDelete
  31. Nice blog. Thank you for sharing. The information you shared is very effective for learners I have got some important suggestions from it. erp provider in chennai.

    ReplyDelete
  32. This is excellent information. It is amazing and wonderful to visit your site.Thanks for sharing this information&its very useful to me...
    Android training in chennai
    Ios training in chennai

    ReplyDelete
  33. Oh! Wow! Nice informative post. I thank you for sharing the information about how to promote a website. Java advantage many uses for to all web application developers. This factors to promote client's website and own as well.Selenium Training in Chennai
    Selenium Training

    ReplyDelete
  34. Thanks for sharing such a informative blog. Really its Very interesting blog which helps me to get the in depth knowledge about the technology. MCSE Training Institute in Chennai | MCSA Training Institute in Chennai | Hardware & Networking Training in Chennai

    ReplyDelete
  35. Nice blog. Thank you for sharing. The information you shared is very effective for learners I have got some important suggestions from it.
    Java Training Institute in Chennai | DotNet Training Institute in Chennai | Web Designing Training Institute in Chennai

    ReplyDelete
  36. Great post and informative blog.it was awesome to read, thanks for sharing this great content to my vision.
    Final Year Project Center in Chennai | Final Year Project Center in Velachery

    ReplyDelete
  37. Useful information. i am looking SAP HANA Online Training with real time project.

    ReplyDelete
  38. happy new year 2018 sms
    happy new year quotes in hindi
    advance happy new year 2018
    whatsapp new year dp
    happy new year 2018 wallpaper 3d
    new year whatsapp dp
    this post is really informative, I want to share it with all of my friends. Please allow me to share it with my friends who will subscribe to your site.

    ReplyDelete
  39. I believe there are many more pleasurable opportunities ahead for individuals that looked at your site.


    sas training in bangalore

    ReplyDelete
  40. Needed to compose you a very little word to thank you yet again regarding the nice suggestions you’ve contributed here.

    java training in bangalore

    ReplyDelete

  41. The website is looking bit flashy and it catches the visitors eyes. A design is pretty simple .
    regionale stellenbörse

    ReplyDelete
  42. I believe there are many more pleasurable opportunities ahead for individuals that looked at your site.
    aws training in Chennai

    ReplyDelete
  43. Those guidelines additionally worked to become a good way to
    recognize that other people online have the identical fervor like mine
    to grasp great deal more around this condition.

    white label website builder

    ReplyDelete
  44. I believe there are many more pleasurable opportunities ahead for individuals that looked at your site.

    digital marketing training in chennai

    ReplyDelete