You can configure the character encoding that notification mailers use to compose e-mail notifications. This feature is useful when you have multiple languages installed in your Oracle E-Business Suite database and your users' e-mail clients use different codesets than the default codeset defined for the database.
When you configure a notification mailer in the Workflow Manager component of Oracle Applications Manager, the Reset NLS configuration parameter lets you specify whether the mailer should use the same character encoding for all notification messages, or encode each notification message with character encoding according to the notification recipient's preferred language. You can also define the special #WFM_RESET_NLS message attribute for a message to override the Reset NLS setting for that particular message. Additionally, you can use the Character Encoding Configuration page to specify the character encoding that you want to use under either Reset NLS setting, overriding the default logic for determining the character encoding.
If the Reset NLS parameter is deselected at the notification mailer level and is not overridden at the message level, or if the #WFM_RESET_NLS message attribute is set to N at the message level, then the notification mailer uses the same character encoding for all notification messages.
By default, the notification mailer uses the default character encoding for the database.
If you want to use different character encoding instead, then you can specify the override character encoding in the Character Encoding Configuration page.
If the Reset NLS parameter is selected at the notification mailer level and is not overridden at the message level, or if the #WFM_RESET_NLS message attribute is set to Y at the message level, then the notification mailer encodes each notification message with character encoding according to the notification recipient's preferred language.
By default, the notification mailer uses the following logic to determine the character encoding for the message.
If the notification recipient has specified both a preferred language and a preferred territory, then the notification mailer uses the character encoding listed in the WF_LANGUAGES table for that language and territory.
If no preferred territory is specified, then the notification mailer uses the character encoding associated with the first entry it encounters in the WF_LANGUAGES table for the user's preferred language.
If no preferred language is specified, then the notification mailer uses the character set listed in WF_LANGUAGES for the language AMERICAN and territory AMERICA.
If you want to use different character encoding instead, then you can use the Character Encoding Configuration page to specify the override character encoding for each language installed in your database. In this case the notification mailer uses the override character encoding configured for the notification recipient's preferred language.
The Character Encoding Configuration page also lets you review and update the Reset NLS parameter setting for each notification mailer that you have configured. Any changes you make in this page will be reflected in the notification mailer configuration wizard in the Workflow Manager component of Oracle Applications Manager as well.
Note: In some instances, no alternative character encoding may be available, either as the overall character encoding for all messages or for a particular language. In this case, you cannot configure an override character encoding.
Navigate to the Character Encoding Configuration page by selecting Administration in the top level menu for the Oracle Workflow administrator Web pages and choosing the Character Encoding tab.
The page displays the default character encoding used when the Reset NLS parameter is deselected at the notification mailer level and is not overridden at the message level, or when the #WFM_RESET_NLS message attribute is set to N at the message level. Select the override character encoding that you want to use instead.
Next, the page displays the default character encoding used for each installed language when the Reset NLS parameter is selected at the notification mailer level and is not overridden at the message level, or when the #WFM_RESET_NLS message attribute is set to Y at the message level. Select the override character encoding that you want to use for each language instead.
Finally, the page displays the Reset NLS parameter for each notification mailer that you have configured. Deselect this parameter if you want a notification mailer to use the same character encoding for all notification messages. Select this parameter if you want the notification mailer to encode each notification message with character encoding according to the notification recipient's preferred language. Any changes you make in this page will be reflected in the notification mailer configuration wizard in the Workflow Manager component of Oracle Applications Manager as well.
Select Apply to save your changes. You can also select Reset to revert to the last saved values.
In Oracle Applications Manager, stop and restart the service component container named Workflow Mailer Service for the updated character encoding to take effect. See: Service Components.