Send your questions to appsdbauniverse@gmail.com

Wednesday, November 30, 2016

Workflow Notification mailer failing with Unable to make a connection with the user and responsibility

Status Information
This automatic Service Component has been restarted the maximum of 10 times after stopping with error. Thus, it has been system deactivated -> 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}.


SQL> select user_id,user_name from apps.fnd_user where user_name='SYSADMIN';
USER_ID USER_NAME
---------- -------------
  12345678 SYSADMIN


Someone have updated user_id of SYSADMIN to different value instead of 0. This is not allowed.


SQL> update apps.fnd_user set user_id=0 where user_name='SYSADMIN' and user_id='12345678';


1 row updated.


SQL> commit;


Commit complete.


SQL> select user_id,user_name from fnd_user_bkp where user_id=0;
USER_ID USER_NAME
---------- -------------
         0 SYSADMIN


Restart Workflow Notification mailer.

No comments:

Post a Comment