Notification Emails are not Getting Sent and Mailer Log Shows ORA-24010 Error
Last updated on AUGUST 02, 2017
Applies to:Oracle Workflow - Version 188.8.131.52 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
Million Knowledge Articles and hundreds of Community platforms