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

Query to get Parent and Child Accounts in Oracle APPS R12

SELECT ffv1.flex_value parent_account       ,ffvt1.description parent_account_desc   ,ffv2.flex_value child_account   ,ffvt2.description...