Invalid Role Or Role Does Not Have The Notification Preference Set
(Doc ID 728331.1)
Last updated on AUGUST 11, 2024
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.
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
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| Workflow Information Center, Diagnostics, & Community |
| References |