WF_WS_JMS_OUT_R , WF_WS_SAMPLE_R , WF_JAVA_DEFERRED_R invalids after Database upgrade from 11g to 12c

Dear Folks,

We have observed few invalids related to workflow after DB upgrade to 12c from 11G.


OWNER           OBJECT_NAME                    CREATED   OBJECT_TYPE                    LAST_DDL_ STATUS
--------------- ------------------------------ --------- ------------------------------ --------- -------
APPLSYS         WF_WS_JMS_OUT_R                09-NOV-13 RULE SET                       03-APR-19 INVALID
APPLSYS         WF_WS_SAMPLE_R                 09-NOV-13 RULE SET                       03-APR-19 INVALID
APPLSYS         WF_JMS_IN_R                    09-NOV-13 RULE SET                       03-APR-19 INVALID
APPLSYS         WF_JMS_OUT_R                   09-NOV-13 RULE SET                       03-APR-19 INVALID
APPLSYS         WF_JAVA_DEFERRED_R             09-NOV-13 RULE SET                       03-APR-19 INVALID
APPLSYS         WF_WS_JMS_IN_R                 09-NOV-13 RULE SET                       03-APR-19 INVALID
APPLSYS         WF_JMS_JMS_OUT_R               09-NOV-13 RULE SET                       03-APR-19 INVALID
APPLSYS         WF_JAVA_ERROR_R                09-NOV-13 RULE SET                       03-APR-19 INVALID

Solution
======

As per ML 337294.1 we executed below procedure for each object listed above.

declare
l_wf_schema varchar2(200);
lagent sys.aq$_agent;
l_new_queue varchar2(30);
begin
l_wf_schema := wf_core.translate('WF_SCHEMA');
l_new_queue := l_wf_schema||'.WF_WS_JMS_OUT_R';
lagent := sys.aq$_agent('WF_WS_JMS_OUT_R',null,0);
dbms_aqadm.add_subscriber(queue_name=>l_new_queue, subscriber=>lagent,rule=>'1=1');
end;
/
commit;

declare

l_wf_schema varchar2(200);

lagent sys.aq$_agent;

l_new_queue varchar2(30);

begin

l_wf_schema := wf_core.translate('WF_SCHEMA');

l_new_queue := l_wf_schema||'.WF_WS_SAMPLE_R';

lagent := sys.aq$_agent('WF_WS_SAMPLE_R',null,0);

dbms_aqadm.add_subscriber(queue_name=>l_new_queue, subscriber=>lagent,rule=>'1=1');

end;

/

commit;

declare

l_wf_schema varchar2(200);

lagent sys.aq$_agent;

l_new_queue varchar2(30);

begin

l_wf_schema := wf_core.translate('WF_SCHEMA');

l_new_queue := l_wf_schema||'.WF_JMS_IN_R';

lagent := sys.aq$_agent('WF_JMS_IN_R',null,0);

dbms_aqadm.add_subscriber(queue_name=>l_new_queue, subscriber=>lagent,rule=>'1=1');

end;

/

commit;

declare

l_wf_schema varchar2(200);

lagent sys.aq$_agent;

l_new_queue varchar2(30);

begin

l_wf_schema := wf_core.translate('WF_SCHEMA');

l_new_queue := l_wf_schema||'.WF_JMS_OUT_R';

lagent := sys.aq$_agent('WF_JMS_OUT_R',null,0);

dbms_aqadm.add_subscriber(queue_name=>l_new_queue, subscriber=>lagent,rule=>'1=1');

end;

/

commit;

declare

l_wf_schema varchar2(200);

lagent sys.aq$_agent;

l_new_queue varchar2(30);

begin

l_wf_schema := wf_core.translate('WF_SCHEMA');

l_new_queue := l_wf_schema||'.WF_JAVA_DEFERRED_R';

lagent := sys.aq$_agent('WF_JAVA_DEFERRED_R',null,0);

dbms_aqadm.add_subscriber(queue_name=>l_new_queue, subscriber=>lagent,rule=>'1=1');

end;

/

commit;

declare

l_wf_schema varchar2(200);

lagent sys.aq$_agent;

l_new_queue varchar2(30);

begin

l_wf_schema := wf_core.translate('WF_SCHEMA');

l_new_queue := l_wf_schema||'.WF_WS_JMS_IN_R';

lagent := sys.aq$_agent('WF_WS_JMS_IN_R',null,0);

dbms_aqadm.add_subscriber(queue_name=>l_new_queue, subscriber=>lagent,rule=>'1=1');

end;

/

commit;

declare

l_wf_schema varchar2(200);

lagent sys.aq$_agent;

l_new_queue varchar2(30);

begin

l_wf_schema := wf_core.translate('WF_SCHEMA');

l_new_queue := l_wf_schema||'.WF_JMS_JMS_OUT_R';

lagent := sys.aq$_agent('WF_JMS_JMS_OUT_R',null,0);

dbms_aqadm.add_subscriber(queue_name=>l_new_queue, subscriber=>lagent,rule=>'1=1');

end;

/

commit;

declare

l_wf_schema varchar2(200);

lagent sys.aq$_agent;

l_new_queue varchar2(30);

begin

l_wf_schema := wf_core.translate('WF_SCHEMA');

l_new_queue := l_wf_schema||'.WF_JAVA_ERROR_R';

lagent := sys.aq$_agent('WF_JAVA_ERROR_R',null,0);

dbms_aqadm.add_subscriber(queue_name=>l_new_queue, subscriber=>lagent,rule=>'1=1');

end;

/

commit;

Then compile invalid objects. Issue solves.

Thanks.

Sreeharsha