Hi All, where can i find workflow notification id (NID) log files. for notification id(NID) MAIL_status=FAILED in wf_notifications table. As clinet asking like "why are PO Notification emails are not going out on Production"
What is the application release? You can find the Workflow log file FNDCPGSC*.txt under $APPLCSF/$APPLOG directory. Please see these docs. How To Troubleshoot Java-based Workflow Notification Mailer [ID 242941.1] How To Troubleshoot When Email Notification Responses Are Processed But The Approval Workflow Still Shows In Process [ID 458665.1] Troubleshooting Inbound Email Notifications [ID 1184846.1] Unable to Connect to Mail Store in Workflow Notification Mailer Logs [ID 741352.1] You may also run the diagnostics script and see if you get more details about the error. 11i : Oracle Workflow Cartridge Workflow Java Mailer Setup Test [ID 274764.1] Oracle Workflow Release 12 Diagnostics [ID 469822.1] Thanks, Hussein