Notification Mailer Fails With ORA-25205 On wf_notification_out (Doc ID 377021.1)

Last updated on OCTOBER 04, 2016

Applies to:

Oracle Workflow - Version 11.5.9 to 11.5.10.2 [Release 11.5 to 11.5.10]
Information in this document applies to any platform.
Checked for relevance on 29-SEP-2016


Symptoms

The Workflow mailer does not start as it fails with errors in the log file

:ERROR:[fnd.wf.bes.PLSQLQueueHandler]:dequeue() :Could not execute() the CallableStatement or retrieve OUT parameter -> java.sql.SQLException: ORA-25205: the QUEUE APPLSYS.WF_NOTIFICATION_OUT does
not exist
ORA-06512: at "APPS.WF_EVENT_OJMSTEXT_QH", line 1080
ORA-06512: at line 1

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