Sunday, March 12, 2017

After Upgrade to 12.1.3, "There are no active responsibilities available for this user" Error is Received after logging.

After Upgrade to 12.1.3, "There are no active responsibilities available for this user" Error is Received after logging


Symptoms:

When you log in, your  home page displays an empty list of responsibilities and message:
"There are no active responsibilities available for this user".
 Same issue is faced by all the users including SYSADMIN.

Changes:

E-Business Suite upgrade from 12.1.1 to 12.1.3


Cause:

EFFECTIVE_START_DATE and EFFECTIVE_END_DATE in WF_LOCAL_USER_ROLES and WF_USER_ROLE_ASSIGNMENTS tables are not correctly synchronized.


Solution:

As you don't have access to any responsibility, to fix the issue, you must execute wf_maintenance.ValidateUserRoles API from sql*plus prompt:


sqlplus apps/apps_pwd

begin
wf_maintenance.ValidateUserRoles(p_BatchSize => NULL, p_check_dangling => TRUE, p_check_missing_ura => TRUE, p_UpdateWho => FALSE);
end;
/

This API invokes the same PL/SQL code than the concurrent program: "Workflow Directory services user/role validation" with argument values as NULL:Yes:Yes:No:NULL


Reference metalink Doc ID 1511839.1

No comments:

Post a Comment