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 FEBRUARY 17, 2023
Applies to:
Oracle Workflow - Version 11.5.10.2 to 12.2.6 [Release 11.5.10 to 12.2]Oracle Order Management - Version 12.2.6 to 12.2.6 [Release 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
---------- ------------------------- ------------- -------
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.
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| Workflow Information Center, Diagnostics, & Community |
| References |