Use wfmlrdbg.sql to display debugging information for a notification that you can use to check the status of the notification or investigate errors. This script creates an output file named wfmlrdbg<nid>.html, where <nid> is the notification ID (NID).
Use the script as follows:
sqlplus <user> @wfmlrdbg <nid> Enter password: <password>
Replace <nid> with the notification ID for the notification.
Note: You can also obtain this information by running the Mailer Diagnostic Test in Oracle Diagnostics Framework. See: Mailer Diagnostic Test.