My Oracle Support Banner

WF_DEFERRED_R is Invalid After Upgrade From 11.5.10 to 12.0.1 (12.1, 12.2), or Database Upgrade to 12c, or Table Re-organization (Doc ID 1078530.1)

Last updated on FEBRUARY 12, 2019

Applies to:

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


Symptoms

After upgrading from Oracle Applications 11.5.10.2 to Release 12.0.1, the Workflow "WF_DEFERRED_R" Rule Set is Invalid and cannot be validated.
  * These steps can be applicable beyond Release 12.0.1, because the problem is most commonly caused by Database changes. ex: upgrade to 12c, or table re-organization
This can happen to any one or all of the Workflow Queue Rules:
WF_DEFERRED_QUEUE_M
WF_JAVA_DEFERRED
WF_JAVA_ERROR
WF_NOTIFICATION_IN
WF_NOTIFICATION_OUT
WF_REPLAY_OUT
WF_WS_JMS_OUT
WF_BPEL_Q
WF_CONTROL
WF_ERROR
WF_WS_JMS_IN
WF_WS_SAMPLE
WF_DEFERRED
WF_IN
WF_JMS_IN
WF_JMS_JMS_OUT
WF_JMS_OUT
WF_REPLAY_IN
WF_OUT

Changes

Upgraded Oracle Applications from Release 11.5.10.2 to 12.0.1, or upgrade the Oracle Database to 12g.

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
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.