WF Mailer Not able to start with the following error : FRAMEWORK_USER=Unable to make a connection with the user and responsibility

Introduction

Solution to fix if the WF Mailer Not able to start with the  error : FRAMEWORK_USER=Unable to make a connection with the user and responsibility

Posted by 

Scenario:

I was trying to restart the WF Container using the following Navigation in 12.1.3

Oracle Application Manager -> Workflow ->Service Components ->Workflow Notification Mailer

When we go inside the container and restarts it failed and shows the following error when we click on the Workflow Notification Mailer.

Error :

Could not handle the control event -> oracle.apps.fnd.cp.gsc.SvcComponentContainerException: Could not start component; performing rollback -> oracle.apps.fnd.cp.gsc.SvcComponentException: Validation failed for the following parameters -> {FRAMEWORK_USER=Unable to make a connection with the user and responsibility}. Parameters were -> {RESET_NLS=N, FROM=Workflow Mailer Production, INBOUND_MAX_RET_EMAIL_SIZE=100, CANCELED=WFMAIL:CANCELED, SEND_UNSOLICITED_WARNING

Solution:

The Error indicates connectivity problem, and the notification mailer will attempt to make a connection as SYSADMIN with the system administrator responsibility. So verify the following:
1. SYSADMIN userid is active and the responsibility System Administrator is Active.
2. Also check whether sysadmin has the default value by :

select * from fnd_user_a  where USER_ID=’0′ order by 1 desc;

In my case SYSADMIN user was end dated by mistake. Because of that it fails to start the WF mailer. So we removed the enddate and tried restarting and it worked.

Reference:

Workflow Mailer Is Not Coming Up And Agent Listeners In Unavailable State FRAMEWORK_USER=Unable to make a connection with the user and responsibility (Doc ID 2448179.1)

Recent Posts