Fixing Invalid Workflow Rule Sets such as WF_DEFERRED_R and Related Errors on Workflow Queues:ORA-24033 (Doc ID 337294.1)

Last updated on MARCH 21, 2017

Applies to:

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

Symptoms

Fixing invalid rule sets and subscriber/rule related errors such as "ORA-24033: no recipients for message"

OWNER OBJECT_NAME OBJECT_TYPE STATUS
---------- ------------------------- ------------- -------
APPLSYS WF_NOTIFICATION_IN_R RULE SET INVALID
APPLSYS WF_NOTIFICATION_OUT_R RULE SET INVALID
APPLSYS WF_NOTIFICATION_OUT$1 RULE SET INVALID
APPLSYS WF_NOTIFICATION_IN$1 RULE SET INVALID
APPLSYS WF_JAVA_DEFERRED_R RULE SET INVALID
APPLSYS WF_JAVA_ERROR_R RULE SET INVALID
APPLSYS WF_JAVA_DEFERRED$1 RULE SET INVALID
APPLSYS WF_JAVA_ERROR$1 RULE SET INVALID
APPLSYS WF_DEFERRED_R RULE SET INVALID
APPLSYS WF_DEFERRED$1 RULE SET INVALID
APPLSYS WF_ERROR$1 RULE SET INVALID
APPLSYS WF_ERROR_R RULE SET INVALID
APPLSYS WF_DEFERRED_TABLE_M_R RULE SET INVALID

Sample Errors:

ORA-25448: rule APPLSYS.WF_DEFERRED_QUEUE_M has errors
ERROR: ORA-025448 : rule APPLSYS.WF_DEFFERED has errors
ORA-00911: invalid character
ORA-24033 no recipients for message


APP-FND-01564: ORACLE error 24033 in FDFDDS_RAISE_DFF_COMPILED
Cause: FDFDDS_RAISE_DFF_COMPILED failed due to ORA-24033: no recipients for
message
ORA-06512: at "APPS.FND_FLEX_SERVER", line 4969
ORA-06512: at line 3.

 

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