User ‘SYSADMIN’ does not have access to notification. ORA-06512: at APPS.WF_ADVANCED_WORKLIST

Posted on August 7, 2008. Filed under: Configuration, DBA/Admin Tips, R12, Workflow Mailer | Tags: , , , |

Users reported that they got below error message when they were trying to view the notifications while logged in as SYSADMIN user on a development instance.

ORA-20002: 3207: User ‘SYSADMIN’ does not have access to notification .
ORA-06512: at “APPS.WF_ADVANCED_WORKLIST”, line 82

A quick check on the Workflow System Administrator Value (How to check this value) revealed that the value is not set to SYSADMIN and its set to “Workflow Administrator Web (New)”.

Is this the cause of the problem, NO.

The problem was SYSADMIN user didnt have this responsibility (Workflow Administrator Web (New)) assigned to him. To resolve the issue, Assign the responsibility using System Administrator -> Security : User -> Define -> SYSADMIN user.

cheers,
OraclePitStop

Advertisements

Make a Comment

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

One Response to “User ‘SYSADMIN’ does not have access to notification. ORA-06512: at APPS.WF_ADVANCED_WORKLIST”

RSS Feed for OraclePitStop – Lets share some knowledge Comments RSS Feed

Hey, this is a great post
The only thing I would add is that, for me,
when I got this error, I had to grant whatever
role is set as the Workflow System
Administrator role (in the workflow configuration
page) to SYSADMIN


Where's The Comment Form?

Liked it here?
Why not try sites on the blogroll...

%d bloggers like this: