1 Reply Latest reply: Sep 1, 2013 11:49 AM by Asif Muhammad RSS

    How clear backlog of notifications




      Platform: linux 4u5 32-bit


      We've configured "Oracle Workflow Notification Mailer" successfully in our TEST instance. Now we are planning to move to Production instance. Before starting I run $FND_TOP/sql/wfver.sql script and got following result:


      sqlplus apps/******** @wfver.sql;


      WF_DEFERRED messages ready:2351236, processed:0
      WF_NOTIFICATION_OUT messages ready:3, processed:0
      WF_ERROR messages ready:381746, processed:0



      I just want to ask is:


      Does this huge number of ready events will give any performance issue if I enable workflow in production? How can I know the actual backlog of notifications which will trigger on enabling OWF Mailer. Please advise.