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