How to Manually Process the Events from Workflow Queues

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem: How to Manually Process the Events from Workflow Queues


Solution:



You need to manually process the events from the queues.

To identify the agent_name please run :
select component_name, inbound_agent_name from fnd_svc_components;


Here is a step by step Action Plan to process the events from Workflow Deferred Agent Listener (WF_DEFERRED)

If the Listener is stopped, leave it this way.If not please stop the Agent listener then:

1. Run the workflow deferred agent listener from sqlplus in order to process all the events

a. Source APPSORA.env so to run sqlplus from any location and use the $FND_TOP env variable:

. APPSORA.env

b. Login to sqlplus as the apps user:

sqlplus apps/

c. Make a script of the following and run it logged in as apps. It will create a file called
debug.log showing what it is doing as it dequeues. Failing events will also be enqueued on the
WF_ERROR queue:

================Begin Script========================

spool debug.log;
exec wf_log_pkg.wf_debug_flag := true;
exec fnd_log.g_current_runtime_level := 1;

begin

wf_event.listen(p_agent_name => 'WF_DEFERRED');
end;
/
col module format a15 ;
col message_text format a40;

commit;

select fnd_debug_util.get_trace_file_name() tracefile from dual;

spool off;

================End Script===========================

d. NOTE: This script will take time if there are several events in the WF_DEFERRED queue and should only be run on an as needed basis. The progress can be monitored running the following query:

SQL> select corr_id, msg_state, count(*) from applsys.aq$wf_deferred
group by corr_id, msg_state;

Events will move from 'ready' state to 'processed' state and willll remain in 'processed' state until the AQ manager runs and cleans them off, usually within 24 hours.


2. When the script finishes, restart wf deferred agent listener.





References:

Note.953103.1 How to Manually Process the Events from Workflow Queues

Get Oracle Certifications for all Exams
Free Online Exams.com