ORA-20002: 3207: User 'SYSADMIN' does not have access to notification 1621941. ORA-06512: at "APPS.WF_ADVANCED_WORKLIST", line 82 ORA-06512: at line 1

Error:- ORA-20002: 3207: User 'SYSADMIN' does not have access to notification 1621941. ORA-06512: at "APPS.WF_ADVANCED_WORKLIST", line 82 ORA-06512: at line 1

Cause:- SYSADMIN user does not have Workflow administrator role.

Resolution:- Following options can be used to get the desired result

Option A:
1. Login to E-Business as the user who can modify the Workflow System Administrator and navigate:
Workflow Administrator Web Applications > Administration
Then select either the SYSADMIN user or the Workflow Administrator Web Applications responsibility as the Workflow System Administrator.
Note: Below sql can be used to get it done from backend
Run below query to check the resp/role name that has been assigned with WF_ADMIN_ROLE.

select text from wf_resources where name='WF_ADMIN_ROLE';

If output of above query is not ‘SYSADMIN’ or ‘Workflow Administrator Web Applications’ responsibility then you got the issue
Update the table as per your requirement.
update wf_resources set text='*' where name='WF_ADMIN_ROLE';
commit:

2. Send another type of the failing notification and confirm that the issue has been fixed.


Option B:

1. Login to E-Business as the user who can modify the Workflow System Administrator and navigate:
Workflow Administrator Web Applications > Administration
Then select your user or responsibility as the Workflow System Administrator.
2. Change the Workflow Mailer Framework User parameter from FND_USER.USER_ID = 0 to the USER_ID of the Workflow System Administrator user or to a user that is assigned to the responsibility you assigned as Workflow System Administrator.

a. Obtain the FND_USER.USER_ID:
select user_id, user_name from fnd_user where user_name=upper('');
b. Run $FND_TOP/sql/afsvcpup.sql to change the Framework User parameter under the Workflow Notification Mailer Component ID to the selected user_id.

c. Shutdown and restart the Workflow Mailer Service.

3. Send another type of the failing notification and confirm that the issue has been fixed.

Reference: Metalink Note ID - 344936.1