{"id":7230,"date":"2021-04-30T18:52:22","date_gmt":"2021-04-30T18:52:22","guid":{"rendered":"https:\/\/rax-stg-wp-aws.com\/blogs\/fix-performance-issues-with-workflow-notification-mailer\/"},"modified":"2026-11-03T19:28:16","modified_gmt":"2026-11-03T19:28:16","slug":"fix-performance-issues-with-workflow-notification-mailer","status":"publish","type":"blogs","link":"https:\/\/www.rackspace.com\/en-gb\/blogs\/fix-performance-issues-with-workflow-notification-mailer\/","title":{"rendered":"Fix performance issues with Workflow Notification Mailer"},"content":{"rendered":"

Introduction<\/strong><\/p>\n

When you introduce new business processes to your Oracle Enterprise Resource Planning (ERP) systems, you might experience a serious notification bottleneck at the application server level rather than the mailer level.<\/p>\n

This notification congestion is due to the sudden influx of notifications that business users don’t receive in time or that arrive two to three hours late.<\/p>\n

This post helps you improve your performance and make notifications appear in real time. The post-process completion of the ERP business notifications should reach the approver’s inbox instantaneously, and the email approval should also be reflected in the system immediately.<\/p>\n

Steps to improve performance<\/strong><\/p>\n

This post offers four possible solutions for your notification performance problem. After you complete a solution’s steps, test the performance and see if it improved.<\/p>\n

Solution 1: Manually rebuild the Notification Mailer queue (WF\\_NOTIFICATION\\_OUT)<\/strong><\/p>\n

1. Stop the Workflow Agent listeners and mailers.
\n2. Find the tablespace that creates CORRID<\/strong> indexes for queue tables:<\/p>\n

sqlplus apps\/<apps_pwd>
\n 
\n        select distinct tablespace_name
\n         from dba_indexes,dba_queues
\n         where index_name=’WF_NOTIFICATION_OUT_N1′
\n         and table_name=queue_table
\n         and name like ‘WF%’;<\/em><\/p>\n

3. Rebuild the mailer’s queue:<\/p>\n

    sqlplus apps\/<apps_pwd> @$FND_TOP\/patch\/115\/sql\/wfntfqup APPS <apps_pwd> APPLSYS<\/em><\/p>\n

4. If the queue rebuild takes more than four or five hours (or never completes), run the following query:<\/p>\n

  select c.item_type child, decode(c.end_date,null,’OPEN’,’CLOSED’) child_status, c.parent_item_type parent,                       decode(c.parent_item_type,null,’NOPARENT’,decode(p.end_date,null,’OPEN’,’CLOSED’)) parent_status, count(*)
\n        from
\n        wf_items p,
\n        wf_items c
\n        where
\n        p.item_type(+) = c.parent_item_type
\n        and p.item_key(+) = c.parent_item_key
\n        and c.item_type=’WFERROR’
\n        group by c.item_type, decode(c.end_date,null,’OPEN’,’CLOSED’), c.parent_item_type , decode(c.parent_item_type,null,’NOPARENT’,decode(p.end_date,null,’OPEN’,’CLOSED’))
\n        order by c.item_type , c.parent_item_type;<\/em><\/p>\n

If that query returns one or more items, those items in WFERROR<\/strong> status are still open, or their parent Workflow item is still open. The program Purge Obsolete Workflow Runtime Data<\/em> concurrent request, FNDWFPR<\/strong>, purges only closed items. You can raise an Oracle Service Request (SR) or see How to Purge WFERROR (System: Error) Workflow Items. (Doc ID 804622.1<\/a>) for help.<\/p>\n

5. Recreate the index on the CORRID<\/strong> column:<\/p>\n

       sqlplus applsys\/<applsys_pwd><\/em>
\n 
\n        CREATE INDEX WF_NOTIFICATION_OUT_N1
\n        ON WF_NOTIFICATION_OUT(CORRID)
\n        STORAGE (INITIAL 1M NEXT 1M MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0)
\n        TABLESPACE &tbs; <\/em><\/p>\n

6. When prompted for the tablespace, enter the tablespace name from Step 2.<\/p>\n

7. Start the Workflow Agent listeners and mailers<\/p>\n

Solution 2: Increase the outbound thread count to two<\/strong><\/p>\n

1. Log in to the Oracle Application Manager and click Notification Mailer<\/strong>.
\n2. If the Notification Mailer service is running, select Stop<\/strong> in the right-hand
\n   corner of the row, and click Go<\/strong>.
\n3. Wait until it stops and the *user deactivated* indication displays.
\n4. Click Edit<\/strong> and Advanced<\/strong>.
\n5. Click Next<\/strong>. If the Outbound thread count is `1`, change it to `2`.
\n6. Click Next<\/strong> on the remaining screens.<\/p>\n

Solution 3: Check that all indexes are present for the WF\\_NOTIFICATION\\_OUT queue<\/strong><\/p>\n

If an index is missing, add it.<\/p>\n

Solution 4: Create a new mailer service<\/strong><\/p>\n

The solution has three parts:<\/p>\n

Part A: Create a new mailer service<\/strong><\/p>\n

 1. Select Workflow administrator Web Applications Responsibility<\/strong>.
\n 2. Select the Workflow Manager<\/strong> menu option.
\n 3. Click on the Service Components<\/strong> icon
\n 4. Click on the Workflow Mailer Service<\/strong> link in the Container<\/strong> column.
\n 5. Click Create New<\/strong>.
\n 6. Enter the following parameters:
\n     – Enabled<\/strong>: check this flag.
\n     – Manager<\/strong>: Enter the Mailer service name (such as Mailer Service HR).
\n     – Short Name<\/strong>: HR_MLR.
\n     – Application<\/strong>: Application Object Library.
\n 7. Click Add<\/strong> from Available Shifts<\/strong>.
\n 8. Move the Standard: Active 24 hours<\/strong>everyday shift from left to right.
\n 9. Click OK<\/strong>.
\n 10. Click Save<\/strong><\/p>\n

Part B: Create a new mailer and link it to the new mailer service from Part A<\/strong><\/p>\n

 1. Select Workflow Administrator Web Applications Responsibility<\/strong>.
\n 2. Select the Workflow Manager<\/strong> menu option.
\n 3. Click the Notification Mailers<\/strong> icon.
\n 4. Click  Create<\/strong> on the right-hand side.
\n 5. Select Workflow Mailer<\/strong>.
\n 6. Click Continue<\/strong>.
\n 7. Enter the Name<\/strong>, such as HR_MLR<\/em>, and enter the rest of the values on that page.
\n 8. Click Advanced<\/strong>.
\n 9. Enter the Correlation id<\/strong>: HXCEMP:%<\/em>.
\n 10. Enter the rest of the parameters with the same values as in the seeded WF Mailer except the Container, which you should set to the Workflow Service created in step# A. This is a crucial step. If you don’t select this service, the solution won’t work.
\n 11. Click Finish<\/strong>.<\/p>\n

Part C: Make sure the mailer service is linked properly<\/strong><\/p>\n

After completing the previous parts, run the following query to find out if the
\nHR_MLR New Mailer<\/strong> service is linked to the new HR_MLRMailer<\/strong><\/p>\n

\n     <\/strong>   select fcq.USER_CONCURRENT_QUEUE_NAME Mailer_Service,
\n          fcq.ENABLED_FLAG ENABLED, fsc.COMPONENT_NAME Mailer_Name,
\n          fsc.STARTUP_MODE, fsc.COMPONENT_STATUS
\n        from APPS.FND_CP_SERVICES fcs,fnd_svc_components fsc, APPS.FND_CONCURRENT_QUEUES_VL fcq
\n         where fcs.SERVICE_HANDLE = ‘FNDCPGSC’
\n         and fsc.component_type = ‘WF_MAILER’
\n         and fsc.concurrent_queue_id = fcq.concurrent_queue_id(+)
\n         order by fsc.STARTUP_MODE;<\/em><\/p>\n

Note<\/strong>: If, after creating a new workflow mailer service, you find genuine emails going into the DISCARD folder, see Workflow Mailer Randomly Moves Response E-mail Notifications to the Discard Folder (Doc ID 333444.1<\/a>).
\nYou probably have not created separate IMAP accounts for each mailer.<\/p>\n

Conclusion<\/strong><\/p>\n

This post presented four solutions to Oracle ERP notification performance issues, from rebuilding the queue to creating a new queue.  Hopefully, these options solve your problems.<\/p>\n","protected":false},"excerpt":{"rendered":"

Fix performance issues with Workflow Notification Mailer<\/p>\n","protected":false},"author":2,"featured_media":7232,"menu_order":0,"comment_status":"open","ping_status":"open","template":"","format":"standard","meta":{"content-type":"","nid":"26325","content_type":"blog","created_by":"10130","authored_on":"2023-11-30T19:52:22+00:00","field_article_industries":"","tag_category":"Technical","field_blog_author_text":"by Dilip Singh, Oracle Applications Database Administrator, Rackspace Technology","seo_description":"Troubleshoot and improve performance issues in Oracle ERP systems, especially Workflow Notification Mailers. Enhance business process efficiency.\r\n","field_featured_image":"","insights_image":"\/wp-content\/uploads\/2026\/blog_technical_images\/26325-insights_image-database-technical-blog-2-insights.jpg","field_partners":"","rxt_platforms":"Oracle, PostgreSQL","product":"","publisheddate":"2021-04-30T18:52:22","rxt_solutions":"Data, Databases, Data Management","opengraph_tag":"","x_tag":"","teaser_flag":"Technical Blog","seo_titile":"Performance Issues Workflow Notification Mailer | Rackspace","field_topics":"","field_slug":"fix-performance-issues-with-workflow-notification-mailer","footnotes":""},"categories":[178],"tags":[204],"class_list":["post-7230","blogs","type-blogs","status-publish","format-standard","has-post-thumbnail","hentry","category-blog","tag-technical"],"_links":{"self":[{"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/blogs\/7230","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/blogs"}],"about":[{"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/types\/blogs"}],"author":[{"embeddable":true,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/comments?post=7230"}],"version-history":[{"count":1,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/blogs\/7230\/revisions"}],"predecessor-version":[{"id":7231,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/blogs\/7230\/revisions\/7231"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/media\/7232"}],"wp:attachment":[{"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/media?parent=7230"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/categories?post=7230"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/tags?post=7230"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}