ORA-20002: 3207: User ‘XXX_does not have access to notification 1234567

We received the above message while testing HRSS WF.

Error :
ORA-20002: 3207: User ‘XXX_does not have access to notification 1234567. ORA-06512: at “APPS.WF_ADVANCED_WORKLIST”, line 225 ORA-06512: at line 1

Cause:
-The reason for the errors is :-The entry tied to the FND User in question is associated with an Expired Employee.
-To verify this, run this query and enter username when prompted, and if r.EXPIRATION_DATE is less then SYSDATE the issue has been confirmed that the FND User in question is associated with an Expired Employee.

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

apps.fnd_user f, apps.wf_roles wfr, apps.wf_local_user_roles r
where

f.USER_NAME=wfr.NAME

and wfr.NAME=r.ROLE_NAME

and r.user_name = ‘XXX_XXXX’;

-What has most likely happened is that the Employee / FND User in question had a change to the Employee record that expired an original record while keeping a current record for that employee.
Solution
1. Open the FND Users form and query user in question, and remove the Person field and save.
2. Add back the person field and save again
3. Save the form.
4. Then run the Synchronize WF Local Tables program for ALL
5. If certain documents are stuck in In Process or Pre-Approved status then review datafix below.

 

Thanks,

Senthil