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

Finding error messages while doing
workflow activities from backend.

Approach:
  1.            Find a workflow internal name
  2.            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’
Or

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

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’

  • January 11, 2015 | 34 views