Business Event - Possible Errors

1>> Check for possible errors

       

              a>. select notification_id

       from wf_notifications
     where subject like '%<business event name>%’;

b>. select wf_notification.getbody(<notification id of business event>)
      from dual;

2>> Check if Agent Listener is down

Navigation :: Workflow Administrator Web Applications > Oracle Applications Manager > Workflow Manager.

3>> Event Error Name: WFE_DISPATCH_RULE_ERR
     Event Error Message: 3825: Error '-4061 - ORA-04061: existing state of has been invalidated 

Reason: When a package is compiled, all copies in the shared pool are flagged as invalid. The error is caused because the notification mailer is reading an old version of the package stored in memory 

Solution: 
1. Stop the Notification Mailer and Workflow Deferred Notification Agent Listener
2. Recompile the APPS schema through ADADMIN (You should have 'apps' and 'system' password)
3. Start the Notification Mailer and agent listener and re-test 

4>> Event Error Message: No Event Subscriptions exist for this Event 

Run below concurrent program
System Administrator > "Synchronize Product License and Workflow BES License"