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

Description:

The below workflow help to find out the error messages while doing oracle workflow activities from backend.

We are finding error messages while doing workflow activities from the backend.

 

Approach:

1.          Find an internal workflow name
2.          Query the workflow table with an 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 the above query will get an 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’

 

Summary:

This Post explained what the steps are should follow to find out the error message in oracle workflow activities from backend

The customer in fusion application

 

Queries?

Do drop a note by writing us at contact@doyensys.com or use the comment section below to ask your questions.