Use wfntfsh.sql to display status information about a particular notification, given its notification ID.

Use the script as follows:

sqlplus <user> @wfntfsh <notification_id> 
Enter password: <password>