select o.OBJECT_NAME, rp.STATUS_CODE, be.TYPE_CODE, be.MESSAGE_CODE, be.EXCEPTION_TRACE2, rp.created_date
from BPM_RUN_OBJECTS o
inner join bpm_run_processes rp
on o.object_id=rp.id and o.table_name='BPM_RUN_PROCESSES'
inner join BPM_ERRORS be
on rp.id= be.PROCESS_INSTANCE_ID
and o.OBJECT_NAME ='update_tasks'
and rp.STATUS_CODE='BPM_PIS_ERROR' and be.TYPE_CODE='BPM_PMT_ERROR'
and rp.CREATED_DATE=sysdate
Query to get the failed process is above. Once I get the information, I need to send out notification to a team with the information from the query.
What is the best approach?
Thanks,
Tai