Sunday 4 November 2018

Rule Set "Applsys.Wf_deferred_r" Has Errors after upgrade

Rule Set "Applsys.Wf_deferred_r" Has Errors

After upgraded database from 10.2.0.4 to 11.2.0, Rule Set WF_DEFERRED_R  became invalid

MOS: 553673.1

To implement the solution, please execute the following steps:

1. Run that PL/SQL

sqlplus applsys/
declare
lagent sys.aq$_agent;
subscriber_exist exception;
pragma EXCEPTION_INIT(subscriber_exist, -24034);
begin
lagent := sys.aq$_agent('WF_DEFERRED',null,0);
dbms_aqadm.add_subscriber(queue_name=>'APPLSYS.WF_DEFERRED',subscriber=>lagent,rule=>'1=1');
exception
when subscriber_exist then
-- just add the rule if subscriber exists
dbms_aqadm.alter_subscriber(queue_name=>'APPLSYS.WF_DEFERRED',subscriber=>lagent,rule=>'1=1');
end;
/

Hope your issue resolved!!