Thursday Nov 05, 2015

Checking for Proper Language Translation in Workflow Directory Services

Introduction

When logging into the Oracle EBS pages in any language ideally roles should be viewable with display names and descriptions in that language so the logged in user would understand them.

If there are any doubts about whether or not roles would be translated to a newly activated language, there are some steps that could be followed to check for proper language translation.  These steps could also be used to check that a language has been successfully added.


Required Patches

To make sure language translation takes place as expected there are some required 1-off patches that need to be applied.

21538802:R12.OWF.B - 1OFF:12.1.3:WF_DIRECTORY.SETADHOCUSEREXPIRATION RESETS THE EMAIL ADDRESS OF ROLE
21538803:R12.OWF.C - 1OFF:12.2.3:21289350 FORWARD PORT: WF_DIRECTORY.ADD_LANGUAGE DOES NOT ADD MISSING


Preliminary Setup

Also, for language translation to work properly the ROLE_TL_VIEW value for a particular ORIG_SYSTEM in the WF_DIRECTORY_PARTITIONS table needs to be set to “NOBS”.  While this could easily be set manually by anyone it is really up to the product development teams to set the value through formal patching.  Thus, if necessary a patch should be requested from the appropriate product development team that does just that.


Scenario
  1. Use appropriate AD tools to add languages, e.g. French and Danish.
  2. Log into Oracle EBS as sysadmin using the English interface.
  3. Use the System Administrator or User Management responsibility to create a new role while also entering a brief description, e.g. RM_ROLE_TEST, "RM role test - English".
  4. Log out.
  5. Query the WF_LOCAL_ROLES and WF_LOCAL_ROLES_TL tables for this newly created role and check the description.  It should be the same one entered at creation for all languages, i.e. "RM role test - English", as shown below:
  6. Log into Oracle EBS as sysadmin using one of the other language interfaces, e.g. French.
  7. Use the System Administrator or User Management role to modify the description of the role created earlier to indicate the language, e.g. "RM role test - French".
  8. Log out.
  9. Query the WF_LOCAL_ROLES_TL table for this role and check the description.  It should show the language-specific description, e.g. "RM role test - French" for French, as shown below:

  10. Log into Oracle EBS as sysadmin using another one of the other languages, e.g. Danish.
  11. Use the System Administrator or User Management role to modify the description of the role created earlier to indicate the language, e.g. "RM role test - Danish".
  12. Log out.
  13. Query the WF_LOCAL_ROLES_TL table for this role and check the description.  It should show the language-specific description, e.g. "RM role test - Danish" for Danish, as shown below:

  14. If desired, log into Oracle EBS as sysadmin using the other default languages, Arabic and Korean, and perform the same roles description modifications then log out.
  15. After all the language-specific description modifications the WF_LOCAL_ROLES_TL table for this role should look something like the following:
About

This blog is dedicated to bring latest information on Oracle Workflow new features, best practices, troubleshooting techniques and important fixes directly from it's Development Team.

Search

Archives
« May 2016
SunMonTueWedThuFriSat
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
    
       
Today