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