Sunday, 11 January 2015

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'

No comments:

Post a Comment