Popular Posts

Tuesday, November 19, 2024

Workflow Queries to debug the Errors

Execute Below query to identify the errors why the workflow is struck 

SELECT

   workflowitemeo.item_type,

   workflowitemeo.item_key,

   workflowitemeo.begin_date,

   workflowitemeo.end_date,

   workflowitemtypeeo.display_name,

     ias.error_name error_name,

   ias.error_message error_message,

   ias.error_stack error_stack 

FROM

   wf_items workflowitemeo,

   wf_item_types_vl workflowitemtypeeo,

   wf_activities_vl activityeo,

   wf_item_activity_statuses ias 

WHERE

   ias.activity_status = 'ERROR' 

   AND ias.item_type = workflowitemeo.item_type 

   and workflowitemeo.item_type ='OEOL'

   AND ias.item_key = workflowitemeo.item_key 

   AND workflowitemeo.item_type = workflowitemtypeeo.name 

   AND activityeo.item_type = workflowitemeo.item_type 

   AND activityeo.name = workflowitemeo.root_activity 

   AND activityeo.version = workflowitemeo.root_activity_version 

 --  AND workflowitemeo.begin_date > SYSDATE - 1 

   AND workflowitemeo.item_type <> 'WFERROR'

 --  and workflowitemeo.item_key='485787'

 order by begin_date desc

Workflow Queries to debug the Errors

Execute Below query to identify the errors why the workflow is struck  SELECT    workflowitemeo.item_type,    workflowitemeo.item_key,    wo...