|
| RE-CREATE WORKFLOW QUEUE !!!!! (New Year Gift) |
| Friday, January 1, 2010 |
===================================
Wish Happy New Year To ALL Readers
===================================
Check the following :
SQL> Select OWNER,OBJECT_NAME,OBJECT_TYPE,STATUS from dba_objects where OBJECT_NAME='WF_DEFERRED';
RE-CREATE WORKFLOW QUEUE
========================
=> Bring down the Workflow Services of DMYFAI instance.
=> Add the Subscribers to The WF_DEFERRED queue
=>Logon to SQLPLUS as APPLSYS schema.
declare
lagent sys.aq$_agent;
begin
lagent := sys.aq$_agent('WF_DEFERRED',null,0);
dbms_aqadm.remove_subscriber(queue_name=>'WF_DEFERRED', subscriber=>lagent);
end;
/
commit;
declare
lagent sys.aq$_agent;
begin
lagent := sys.aq$_agent('WF_DEFERRED',null,0);
dbms_aqadm.add_subscriber(queue_name =>'WF_DEFERRED',subscriber=>lagent,rule=>'1=1');
end;
/
commit;
=> Bring up the Workflow Services of DMYFAI instance.
=> Take an invalid count
=> Add the missing subscriber/rule to the queue.
- Run $FND_TOP/patch/115/sql/wfquec2.sql
sqlplus apps/ @wfquec2.sql
- For other missing subscriber/rule,
run $FND_TOP/patch/115/sql/wfmqsubc.sql
sqlplus apps/ @$FND_TOP/patch/115/sql/wfmqsubc.sql APPLSYS
=> Check for new invalids |
posted by Jaswinder Singh @ 1:24 AM   |
|
|
|
|
|
Happy New Year Jassi