Invalid Role Or Role Does Not Have The Notification Preference Set (Doc ID 728331.1)

Last updated on OCTOBER 12, 2016

Applies to:

Oracle Workflow - Version 11.5.10.2 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.
Checked for relevance on 12-Oct-2016

Symptoms

Using the Oracle Application Release 11.5.10.2


When customer uses OAM to Test the Workflow Mailer - Sent Test Mail generates the following error:

Invalid Role, or role does not have notification preference set to receive detail email messages. Please choose another role.

Further investigation of the FND_USER_PREFERENCES table reveals that the only MAILTYPE present in the table is "QUERY'. All the valid values that allow Notification_Preferences to be formatted are missing from the FND_USER_PREFERENCES table.

As an alternative, trying to assign an Email Style for Notifications in the "Preferences" link yields the following problems:

The Preference Page is missing the section for Email Styles and has the following error:

ERROR

You have encountered and unexpected error. Please contact the System 
Administrator for assistance.


DETAILS OF ERROR
-----------------------

oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: 
SQL error during statement preparation.  Statement: SELECT * FROM (select t.
territory_short_name territory_name, t.nls_territory
from   fnd_territories_vl t, v$nls_valid_values v 
where  t.nls_territory = v.value 
and    v.parameter = 'TERRITORY') QRSLT  ORDER BY territory_name
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:891)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareExce
ption(OAPageErrorHandler.java:1145)
at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:

 

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms