Oracle Fusion, Oracle E-Business Suite

Tips, Tricks, Articles about Oracle E-Business Suite,Oracle Fusion, Oracle 11i, Oracle PL/Sql, Workflow, Order-to-Cash, Procurement-to-Pay, CRM, SOA, BPEL, WSDL, XML, OAF

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

Posted by Senthilkumar on July 14, 2011

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

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
Follow

Get every new post delivered to your Inbox.

%d bloggers like this: