Thursday, June 4, 2015

Not able to view notifications - ORA:20002: 3207

A client declared "I am not Not able to view notifications from OAF despite I have lots of .. " . Also clicking related URL in notifications mail give ORA-2002:3707 : User does not have access to notification ..

Expired FND  user can cause this issue.

To detect that if it is  , below sql can be run.

select f.USER_NAME "FND USER NAME", wfr.DISPLAY_NAME, f.END_DATE, r.EXPIRATION_DATE,
    wfr.STATUS, wfr.EXPIRATION_DATE, wfr.ORIG_SYSTEM, wfr.PARENT_ORIG_SYSTEM
    from fnd_user f, wf_roles wfr, wf_local_user_roles r
    where f.USER_NAME=wfr.NAME
    and wfr.NAME=r.ROLE_NAME
    and r.user_name = '&username';

If expiration date is less then SYSDATE then this user seems Expried Employee

In order to solve this


1.From Security--> User-->Define query user.
2.Remove employee name from Person field
3.Save
4.Add employee name to Person field back
5.Save
6.Re-query user.
7.Run Synchronize WF Local Tables program

No comments:

Post a Comment