My Oracle Support Banner

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

Last updated on MAY 05, 2023

Applies to:

Oracle Workflow - Version to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.


Using the Oracle Application Release

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:


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


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(
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareExce
at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(





To view full details, sign in with your My Oracle Support account.

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

In this Document
 Workflow Information Center, Diagnostics, & Community

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.