Monday, December 30, 2024

Query to check the Workflow Agent Listeners and their Statuses

SELECT fsc.component_name
      ,dq.owner
      ,dq.queue_table
      ,fsc.correlation_id
  FROM applsys.fnd_svc_components fsc
      ,applsys.wf_agents          wa
  ,dba_queues dq
 WHERE fsc.inbound_agent_name || fsc.outbound_agent_name = wa.name
   AND dq.owner || '.' || dq.name = wa.queue_name
   AND fsc.component_type LIKE 'WF_%AGENT%'

No comments:

Post a Comment