Workflow Instance Monitoring View Is Not Displaying The Workflow Instance Information In Application User Interface, But The Instance Records Keep Getting Created In database Tables S_WFA_STPRP_LOG, S_WFA_INST_LOG and S_WFA_INSTP_LOG (Doc ID 2640700.1)

Last updated on MARCH 03, 2023

Applies to:

Symptoms

Customer is trying to using Workflow Monitoring debug level to troubleshoot some issue they are having with DataQuality (EDQ) Merge. They have enabled the Workflow Monitoring debug level for some workflow on Production to monitor the workflow execution, but when they navigate to Administration - Business Process > Workflow Instance Monitor View they can not see any monitoring information about the workflow they have enabled.

But they can see a lot of records been created in the database in tables S_WFA_STPRP_LOG, S_WFA_INST_LOG and S_WFA_INSTP_LOG, so it seems to be logging but not showing in the Administration - Business Process > Workflow Instance Monitor View. Now if they try to stop the creation of the record setting monitor level back to 0 it does not stop the creation of the records on these tables.

The issue can be reproduced at will with the following steps:

1. Login to Siebel and navigate to Administration - Business Process > Workflow Deployment > Active Workflow Process and increase the Monitoring Level to 4- Debug.

2. After that go to Administration - Business Process > Workflow Instance Monitor View, they can not see any information about the workflow in the monitoring view

3. Behind the scene they see a lot of records been created in table S_WFA_STPRP_LOG, S_WFA_INST_LOG and S_WFA_INSTP_LOG

4. Now to stop monitoring they go back to Administration - Business Process > Workflow Deployment > Active Workflow Process and set the Monitoring Level to 0 - None.

5. But still they see record been created in S_WFA_STPRP_LOG, S_WFA_INST_LOG and S_WFA_INSTP_LOG

6. In Workflow Instance Monitor they see some workflow in Active and read-only which we cannot "de-activate".

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.