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