ORA-24026: operation failed, queue APPLSYS.WF_CONTROL error in WF Notification Mailer (+ solution)

Symptoms

The orkflow mailer does not run because of errors in the log file

ORA-20002: 3825: Error '-24026 - ORA-24026: operation failed, queue APPLSYS.WF_CONTROL has
errors' encountered during execution of 'WF_RULE.ERROR_RULE' for event
'oracle.apps.fnd.cp.gsc.SvcComponent.start'.
FUNCTION_NAME=WF_EVENT_OJMSTEXT_QH.enqueue()

Cause

Either the queue WF_CONTROL or its data is corrupted, probably due to the change of the IMAP/SMTPserver settings.

Since the WF_CONTROL queue is used by the notification mailer to hold runtime data, and it is not valid, the mailer will not be able to start up

Solution

To solve this problem please proceed as follows:

1. Stop Workflow Agent listeners

2. Run the following:
cd $FND_TOP/patch/115/sql
sqlplus APPS/ @wfctqrec.sql APPLSYS

3. Grant required privileges:
sqlplus apps/passwd @afwfqgnt.sql APPS APPLSYS

Note: APPLSYS password is the same as APPS'.

4. Start Workflow Agent listeners.

The Workflow mailer should start now

Hint: to make sure the WF_CONTROL queue was created successfully, the Concurrent request 'Workflow Control Queue Cleanup' should run without errors.