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 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.


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:

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.


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