Query to get failed workflows with detail error message in Oracle Apps EBS R12

Query to get failed workflows with detail error message in Oracle Apps EBS R12

Query:

SELECT

   workflowitemeo.item_type,

   workflowitemeo.item_key,

   workflowitemeo.begin_date,

   workflowitemeo.end_date,

   workflowitemtypeeo.display_name,

   wf_fwkmon.getitemstatus(workflowitemeo.item_type, 

                                         workflowitemeo.item_key, 

                                         workflowitemeo.end_date, 

                                         workflowitemeo.root_activity, 

                                         workflowitemeo.root_activity_version 

                                         ) AS workflow_status,

   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 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';

If you like please follow and comment