Oracle EBS Workflow Mailer Troubleshooting Checklist (Log Location to Purge)
This checklist covers the Oracle Workflow Notification Mailer on EBS 12.1 and 12.2 when emails stop, arrive late or replies are not processed. It runs from service status and log location through SMTP and IMAP settings, queue state, user preferences, background processes and safe purging.
0 of 30 items complete
7 critical items still open - these are the highest-risk gaps.
1. Service status
2. Logs
3. Outbound email
4. Inbound processing
5. Queue and notification state
6. Background processing
7. Diagnostics
8. Purge and housekeeping
Start with Service status and Logs; most mailer problems show up there. Treat any open critical item in Outbound or Queue state as the likely cause before changing anything else.
Send us your mailer log excerpt
Share the FNDCPGSC log lines around the failure and your mailer parameters, and we will point to the likely cause.
Optional. The tool and every export work without this. No spam.
How notifications reach an inbox
When a workflow sends a notification, Oracle Workflow creates a row in WF_NOTIFICATIONS and raises a business event. The Workflow Deferred Notification Agent Listener processes it and places a message on the WF_NOTIFICATION_OUT queue. The Workflow Notification Mailer, a service component running under the Workflow Mailer Service, dequeues the message, renders it according to the recipient's notification preference and sends it through SMTP. Responses come back through IMAP into the inbox folder, and the mailer moves them to processed or discard. A break anywhere in that chain looks the same to users: no email, so check each link in order.
Where the mailer log is
The mailer writes to a file named FNDCPGSC followed by the process id, with a .txt extension, in $APPLCSF/$APPLLOG on the node running the Workflow Mailer Service. On 12.2 that directory is under fs_ne, so it is shared between run and patch editions. To find the right file, open Administer Concurrent Managers, select Workflow Mailer Service, view the processes and note the process id. The default log level shows errors only; raise the Log Level parameter of the mailer component in Workflow Manager while you reproduce the problem, then lower it again because statement-level logging grows quickly.
- Table FND_SVC_COMPONENTS: COMPONENT_NAME, COMPONENT_STATUS, COMPONENT_TYPE
- Queue WF_NOTIFICATION_OUT: ready messages waiting for the mailer
- WF_LOCAL_ROLES: NOTIFICATION_PREFERENCE and EMAIL_ADDRESS per role
Background processes
The Workflow Background Process (short name FNDWFBG) is a concurrent program that runs deferred activities, timed-out activities and stuck processes for an item type. It is not the mailer, but many 'notification never sent' cases are really workflows waiting on a deferred activity that no background process picks up. Schedule separate runs: deferred activities frequently (for example every few minutes for busy item types such as approvals), timeouts every hour or so, and stuck processes less often. Leaving item type blank processes all item types, which is fine for small systems but slow on large ones.
Common mistakes
After a clone, the mailer in test either sends real emails to real users or has a Test Address that silently redirects everything; both cause confusion, so set the Test Address deliberately in every non-production environment. Users with notification preference QUERY or DISABLED never get email, which often looks like a mailer fault. Deleting messages from WF_NOTIFICATION_OUT to clear a backlog can lose notifications and corrupt the queue; only do it with Oracle Support. Finally, check that the mail relay accepts connections from the concurrent node's IP address.
Frequently Asked Questions
Where is the Workflow Mailer log in Oracle EBS?
In $APPLCSF/$APPLLOG on the concurrent processing node, named FNDCPGSC<process id>.txt. Find the process id for the Workflow Mailer Service in Administer Concurrent Managers. On 12.2 this directory is in the non-editioned file system, fs_ne.
What does the Workflow Background Process do in Oracle EBS?
Workflow Background Process (FNDWFBG) processes deferred activities, timed-out activities and stuck processes for the item type you specify. Without it scheduled, workflows wait indefinitely on deferred steps. Schedule separate runs for deferred, timeout and stuck processing at different frequencies.
How do I troubleshoot a single notification that was not sent?
Run $FND_TOP/sql/wfmlrdbg.sql with the notification id. It shows the notification, its MAIL_STATUS, the recipient's preference and email, and related queue messages. Check WF_LOCAL_ROLES for the recipient, then the mailer log around the send time.
What is the Workflow Analyzer?
An Oracle-provided diagnostic script, available from My Oracle Support Doc ID 1369938.1, that reports on workflow health: runtime data volumes, mailer configuration, background process scheduling and known issues. Run it regularly and after any mailer or upgrade change.
If you want admins and approvers to ask EBS which notifications are waiting and why in plain English, on your own servers, we can set up that private AI layer.
Related Tools
Oracle EBS Concurrent Manager Not Starting Troubleshooting Checklist
A step-by-step checklist for EBS 12.1 and 12.2 when the Internal Concurrent Manager or standard managers will not start.
OracleOracle EBS Concurrent Managers and Settings Reference
What each standard concurrent manager and service does, and what the main tuning settings mean, in one searchable table.
OracleOracle EBS Rapid Clone Checklist
Step-by-step checklist for cloning an EBS instance with Rapid Clone, including the post-clone scrubbing that protects production data and integrations.
OracleOracle EBS Instance Health Assessment
A 10-question self-assessment that scores how well your EBS instance is run and points to the first areas to fix.
More Oracle tools
See all- Oracle EBS Inventory Tables Reference
- Oracle EBS WIP Tables Reference
- Oracle EBS Cycle Count Workload Calculator
- Oracle EBS Discrete Manufacturing Go-Live Checklist
- Oracle EBS Inventory Accuracy Readiness Assessment
- Oracle EBS Concurrent Request Phase and Status Reference
- Oracle EBS Responsibility Design Worksheet
- Oracle EBS GL Period Close Checklist
- Oracle EBS AP Invoice Interface Template
Keep exploring
Free tools
- Oracle EBS Workflow Error and Notification SQL GeneratorGenerate the five queries and the PL/SQL retry block a workflow administrator needs: errored activities, open notifications, mailer backlog, deferred queue and retry.
- Oracle EBS Concurrent Manager Not Starting Troubleshooting ChecklistA step-by-step checklist for EBS 12.1 and 12.2 when the Internal Concurrent Manager or standard managers will not start.
- Oracle EBS Discrete Manufacturing Go-Live ChecklistA grouped go-live checklist for Oracle Inventory, BOM, WIP and Cost Management covering setup, data, testing and cutover for discrete manufacturers.
ERP fixes and how-tos
- Fix Oracle EBS Workflow Notification Mailer Not Sending EmailsEBS Notification Mailer stuck on Suspended or Error usually means SMTP, IMAP, or TLS changed on the mail server. Fix the connection and clear the backlog.
- Oracle Workflow error: Attribute does not exist for item typeFix Oracle Workflow's Attribute does not exist for item type error in EBS by checking the item type's attribute definitions in Workflow Builder against every activity and message referencing it, including custom customizations.
- How to Add a Private AI Layer to Oracle EBS 12.2 On-PremReference architecture for a private AI layer on Oracle EBS 12.2: Active Data Guard replica, ISG REST, MO and responsibility security, local GPUs and audit.
Runs with your ERP
- Esker Order Management and Oracle E-Business SuiteHow Esker captures customer POs from email, fax and PDF and creates sales orders in Oracle EBS: integration, data flows, setup, pitfalls and a private AI layer.
- Cloud Inventory (DSI) with Oracle E-Business Suite: Mobile Barcode InventoryCloud Inventory, formerly DSI, adds offline mobile barcode inventory to Oracle E-Business Suite and JD Edwards. Data flows, setup steps, pitfalls and AI notes.
- MarkView for Accounts Payable and Oracle E-Business SuiteHow Tungsten (Kofax) MarkView automates AP invoice capture and discrepancy workflow inside Oracle EBS: integration, data flows, setup, pitfalls and AI.
AI on your ERP
- AI for Oracle E-Business Suite, Without Leaving On-PremHosting Oracle EBS 12.2 on-prem or in a private cloud? Add a private LLM over concurrent programs, interface tables and AP/PO data without moving to Fusion.
- AI for Oracle EBS in Industrial Manufacturing: WIP, MRP, and BOM Questions Answered DirectlyAI for Oracle E-Business Suite in industrial manufacturing: WIP jobs, BOMs, MRP, inventory and purchasing answered in plain English, private and read-only.
Integrations
- How to add WhatsApp to Oracle E-Business SuiteHow to connect WhatsApp Business to Oracle E-Business Suite 12.1 and 12.2: ISG REST, Workflow business events, template messages and two-way replies into EBS.
- How to add Slack alerts and approvals to Oracle E-Business SuiteConnect Slack to Oracle E-Business Suite for alerts, slash commands and interactive approvals using Workflow events, Oracle Alert and ISG, without exposing EBS.