DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Sunday, February 5, 2017

There are no active responsibilities available for this user

Missing SYSADMIN Responsibility After Upgrade To 12.1.3.

When you log in, your  home page displays an empty list of responsibilities and message,
Same issue is faced by all the users including SYSADMIN.

Cause:

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


Solution:

Login into apps schema,

We have to execute wf_maintenance.ValidateUserRoles API.

sqlplus apps/apps

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

No comments: