My Oracle Support Banner

12.2 E-Business Suite Workflow Test Notifications Fail With Error 'ORA-20002: 3116 : Activity 'WFTESTS/MAILER_TEST1' is not a runnable process. ORA-06512: at "APPS.WF_ENGINE", line 4201 ORA-06512: at line 1' (Doc ID 2371228.1)

Last updated on MARCH 19, 2018

Applies to:

Oracle Workflow - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

E-Business Suite 12.2 Workflow, Workflow Mailer related issues

 

 

 



Attempts to send a Test Workflow Notification fail and the following error is received:

'An error has occurred!

ORA-20002: 3116 : Activity 'WFTESTS/MAILER_TEST1' is not a runnable process. ORA-06512: at "APPS.WF_ENGINE", line 4201 ORA-06512: at line 1.'


The issue can be reproduced at will with the following steps:
1. Started the Workflow Services from the Oracle Application Manager (OAM) > Workflow > Home > Notification Mailers > Workflow Notification Mailers Start
2. Generate a TEST Workflow Notification in OAM


The issue has the following business impact:
Due to this issue customer reports that this is happening in Production and all Users are Impacted, but they do not know the extent of the impact
on the products yet because its a Sunday and not all users are in.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


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