Notification Emails are not Getting Sent and Mailer Log Shows ORA-24010 Error (Doc ID 968683.1)

Last updated on AUGUST 02, 2017

Applies to:

Oracle Workflow - Version 11.5.10.2 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.

Symptoms

Notification emails are not sent; in OAM (Oracle Application Manager) the Workflow Notification Mailer has status "System Deactivated" (DEACTIVATED_SYSTEM) and mailer log reports the following error:

Error:
java.sql.SQLException: ORA-24010: QUEUE APPLSYS.WF_NOTIFICATION_OUT does not exist


Additional information: the mailer log files have their name starting with FNDCPGSC and are generated in $APPLCSF/$APPLLOG directory.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms