How to find error messages while doing Oracle workflow activities from backend.

Doyensys 2015-01-11 1 min read

Finding error messages while doing
workflow activities from backend.

Approach:

Find a workflow internal name
Query the workflow table with
internal name and see the result output error message field.

Internal name(Item type
column in backend)

SQL queries:

Select * from
wf_item_activity_statuses where item_type= ‘APINVAPR’

Select * from
wf_item_activity_statuses where item_type= ‘APINVAPR’ AND TRUNC(BEGIN_DATE)=TRUNC(SYSDATE)

Select Invoice_id
from
ap_invoices_all where invoice_num=’test19sep10′

From above query will get
a invoice_id(1524287)

Select * from wf_item_activity_statuses where item_key
like ‘1524287%’

Result output will show error
message details in error_message column

Other SQL Queries :

Select * from
WF_MESSAGES where Type = ‘APINVAPR’

Select * from WF_ACTIVITIES where item_type = ‘APINVAPR’

Select * from wf_item_attributes where item_type = ‘APINVAPR’

Related blogs