Use wfbesdbg.sql to display debugging information for an event that you can use to check the status of the event or investigate errors. This script creates an output file named wfevtdbg<event_key>.html, where <event_key> is the event key for a particular instance of the event. The output file displays details about the Business Event System, including the statuses of the local system and agent listeners, details about the definitions of the specified event and any subscriptions to that event, and details about the specified instance of the event if it appears on one of these queues:

• WF_DEFERRED

• WF_JAVA_DEFERRED

• WF_ERROR

• WF_JAVA_ERROR

Use the script as follows:

sqlplus <user> @wfbesdbg <event_name> <event_key> 
Enter password: <password>

Replace <event_name> with the name of the event and <event_key> with the event key that identifies the particular instance of the event. The event name and event key parameters are case-sensitive.