Changed Workflow Administrator role from SYSADMIN to a user ABC. After this change the users started getting the following error in workflow notification emails.
ORA-20002: 3207: User 'SYSADMIN' does not have access to notification 66758. ORA-06512: at "APPS.WF_ADVANCED_WORKLIST", line 84 ORA-06512: at line 1
ORA-20002: 3207: User 'SYSADMIN' does not have access to notification 66758. ORA-06512: at "APPS.WF_ADVANCED_WORKLIST", line 84 ORA-06512: at line 1
- To resolve the issue I changed the Workflow Administrator role from ABC to 'Workflow Administrator Web (New)' responsibility.
- Assingned this responsibility to SYSADMIN and user ABC.
- Then run the request “Synchronize WF LOCAL tables” with “ALL” in parameter.