To display user defined objects in Oracle Workflow Builder in other languages (for standalone version only)
1. Install Oracle Workflow Cartridge.
2. Create the WF_LANGUAGES view in your workflow server.
3. Run the script wfnlena.sql to enable the language of interest. See: wfnlena.sql.
4. Run the script WFNLADD.sql to create rows for the enabled language in each workflow object translation table. See: WFNLADD.sql.
5. Set the NLS_LANG environment variable for the new language.
For example, in UNIX, use the command:
setenv NLS_LANG = 'language.territory_characterset'
For Windows NT, run the regedit32 command and locate the NLS_LANG setting under the HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE hierarchy. Double click on NLS_LANG, then set the variable to the new value and save your edit.
6. Create a translated version of your workflow process definition and save it as a flat file (.wft).
7. Load the translated .wft file to your workflow database, making sure that the current NLS_LANG setting is correct.
Note: To determine the language to load, the Workflow Definitions Loader uses the language specified in the .wft file, while the Workflow Resource Generator accepts a language parameter. If you do not specify a language parameter, the Workflow Resource Generator defaults to the current setting of NLS_LANG.