Oracle Workflow Guide
Release 2.6.2

Part Number A95265-02
Previous Next       Contents Index Glossary
         Previous  Next          Contents  Index  Glossary

WF_USERS

The WF_USERS view should reference information about all the individuals in your organization who may receive workflow notifications. Create this view, making sure it contains the following columns:

Attention: The Name column must be sourced from a column that is less than 30 characters long and is all uppercase. If your source table does not have a column that meets these criteria, DO NOT use string functions to force these restrictions. Instead, define the Name column to be <orig_system>:<orig_system_id> so that Oracle Workflow can reference the original base table where users are stored and a unique user in that table. For example, "PER_PEOPLE:009" represents a user whose employee ID is 009 and is stored in the personnel table called PER_PEOPLE.

Note: A notification preference of MAILTEXT, MAILHTML, or MAILATTH also allows users to query their notifications from the Notifications Web page.

Note: You can map the Notification_Preference column over the Oracle Workflow preferences table using the statement below. The benefit of this is that you can then globally set the default notification preference for all users in your enterprise using the Global Preferences web page and let individual users override that default value by changing their notification preference in the User Preferences web page. See: Global Preferences, User Preferences and get_pref.

			NVL(wf_pref.get_pref(USR.USER_NAME,'MAILTYPE'),
'MAILHTML')

Note: You can globally set the language for all the users in your enterprise, by specifying a language in the Global Preferences web page. Individual users may override that default value by changing their language in the User Preferences web page. See: Global Preferences, User Preferences and get_pref.

Note: You can map the Language column over the Oracle Workflow preferences table using the statement below. The benefit of this is that you can then globally set the default Language for all users in your enterprise using the Global Preferences web page and let individual users override that default value by changing their Language in the User Preferences web page. See: Global Preferences and User Preferences.

			NVL(wf_pref.get_pref(USR.USER_NAME,'LANGUAGE'),
FNDL.NLS_LANGUAGE)

Attention: Make sure that the e-mail templates used by the Notification Mailer to send notifications have been translated by Oracle to the language you wish to set. The e-mail templates are delivered in a file called wfmail.wft under the subdirectory $ORACLE_HOME/wf/res/<lang>. You can check the appropriate language subdirectory to verify if the templates have been translated to the language you wish to set. See: Modifying Your Message Templates.

Note: You can map the Territory column over the Oracle Workflow preferences table using the statement below. The benefit of this is that you can then globally set the default Territory for all users in your enterprise using the Global Preferences web page and let individual users override that default value by changing their Territory in the User Preferences web page. See: Global Preferences, User Preferences and get_pref.

			NVL(wf_pref.get_pref(USR.USER_NAME,'TERRITORY'),
FNDL.NLS_TERRITORY)


         Previous  Next          Contents  Index  Glossary


Oracle
Copyright © 2002 Oracle Corporation.

All Rights Reserved.