Goals To add an additional language to an existing Siebel Enterprise Time 20 – 30 minutes
Instructions:
In this practice, you will add French to your existing Siebel Enterprise. Recommended practice is to install all expected languages on initial deployment, but it is also possible to add new languages after the Enterprise has been deployed. To deploy a new language, run all of the installers and
configuration tools in the same order as you would for an initial deployment.
1. Add French to the Siebel Enterprise. This adds French Application Object Managers (AOMs), as well as French support files to your installation.
a. Using Windows Explorer, navigate to
D:\Labs\8.1_Install\Installers\Server\Siebel_Enterprise_Server.
b. Double-click setup.exe.
c. Click Next on the Welcome screen.
d. The setup program recognizes the existing installation and presents a new option window:
Oracle Internal & Or acle Academy Use Only
e. Select Add languages to Siebel Enterprise Servers in D:\OUses and click Next.
f. Select fra - French (Standard) and click Next. The language packs available to you depend on what you selected when you downloaded from E-Delivery.
g. Once installation completes after 1-2 minutes, the Siebel Server Configuration Tool runs automatically.
h. Select Add Language Support for the Siebel Server and click Next.
i. Enter the parameters:
Parameter Value Purpose
Gateway Name Server Authentication User Account Name
SADMIN Used to log in to the Siebel Gateway Name Server to obtain configuration information.
Gateway Name Server Authentication User Account Password - and confirm
SADMIN Used to log in to the Siebel Gateway Name Server.
Gateway Name Server
Host Name <Machine Name> Used to connect to the Siebel Gateway Name Server.
Gateway Name Server
TCP/IP Port 2320 Port on which the Siebel Gateway Name
Server is listening for connections.
Siebel Enterprise Name OUEnt Enterprise containing the Siebel Server.
Deployed Languages English (American) French (Standard)
The languages to deploy on the Siebel Server.
j. If necessary, click Next then Finish to exit the After Intallation dialog box.
2. Add French to the Siebel database seed data. This provides string translations for menu items and other strings displayed in the application.
a. Select Start > Programs > Siebel Enterprise Server Configuration 8.1 > Database Server Configuration.
b. Enter the parameters:
Parameter Value Purpose
Siebel Server Directory D:\OUses\siebsrvr Location of Siebel Server executables.
Siebel Database Server
Directory D:\OUses\dbsrvr Location of Siebel Database Configuration Tool executables.
Database Platform Oracle Database Enterprise Edition
Type of database used by the Siebel Enterprise.
Action Install Database Used to either install the initial database, or add a language to an existing database.
Action Type Add a language to an existing Siebel Database
Used to add a new language to an existing database.
Has GRANTUSR.SQL
been run? GRANTUSR.SQL has
been run by the DBA to create Siebel users and roles
Unless GRANTUSR.SQL has been run, the configuration scripts will fail, hence this step is a safety check.
Base Language English (American) The language in which installer log files and other enterprise-wide messages are
Oracle Internal & Or acle Academy Use Only
Lesson 12: Multilingual Installations
displayed.
Lanuage to add French (Standard) Language to add to the database.
ODBC Data Source
Name OUEnt_DSN Used to connect to the Siebel database.
Database User Name SADMIN Used to log in to the Siebel database to access or update tables.
Database User Password - and confirm
SADMIN Used to log in to the Siebel database.
Database Table Owner SIEBEL Used to access the Siebel database schema.
Database Table Owner Password
- and confirm
SIEBEL Used to access the Siebel database schema.
Siebel Repository Name Siebel Repository Used to add data to the Siebel Repository.
Parallel Indexing? Does not use the Oracle Parallel Indexing option
Used to improve performance when using multiple machines for the database server.
Security Group
ID/Grantee SSE_ROLE Role of Siebel Users in the database.
Log output directory install_lang Location to store installer log files.
Apply changes now? Yes Whether or not to apply the changes immediately.
c. Click OK in the Siebel Upgrade Wizard to start the database upgrade.
d. Once the database upgrade completes, click OK and cancel out of the Database Configuration Tool.
3. Add French to the Siebel Web Server Extension. This adds virtual directories that point to the French object managers.
a. Using Windows Explorer, navigate to
D:\Labs\8.1_Install\Installers\Server\Siebel_Web_Server_Extension.
b. Double-click setup.exe.
c. Select Add languages to Siebel Web Server Extension in D:\OUWebServer\SWEApp and click Next.
d. Select fra - French (Standard) as the language to add and click Next.
e. Once installation completes, the Siebel Web Server Extension Configuration Tool runs.
Oracle Internal & Or acle Academy Use Only
5. Confirm the French language installation.
a. Start a new instance of Internet Explorer and enter an address of http://<machine name>/callcenter_fra.
b. Confirm that the field labels and copyright notice are shown in French:
6. Confirm that LOVs have not yet been translated.
a. Enter:
User ID SADMIN
Password SADMIN
b. Click the arrow.
c. If a dialog box appears stating that, “Votre navigateur n’est pas configuré correctement”, click Répar, Auto. Then click Exécuter. This is the same Auto-Fix dialog box that appears in the English version of the application.
d. Click the Sociétés tab. This translates to Accounts.
e. Click My Accounts. Note that this string is not translated by default. This is the sort of testing you need to do when deploying a new language: When you are looking at a new language, you should navigate through the application and determine which strings, logos, or other images still require translation.
f. Click Nouveau to create a new account.
g. Enter INS Account in the Nom field. This is the account name.
h. Select the drop-down list in the Statut field. Note that all of these account statuses are still in English. This is an example of an untranslated List of Values (LOV).
i. Step off the record to save it.
Oracle Internal & Or acle Academy Use Only
Lesson 12: Multilingual Installations
j. Select Fichier > Déconnexion from the application-level menu to log out of the application.
Oracle Internal & Or acle Academy Use Only
Practice 12-2 Enabling Multilingual Lists of Values (MLOVs) (Optional)
Goals To enable an MLOV on the Account Status field Time 25 – 35 minutes
Instructions:
In this practice, you will enable a Multilingual List of Values (MLOV) on the Account Status field you examined in a previous practice. Multilingual Lists of Values store references to translated strings in the S_LST_OF_VAL table rather than the strings themselves therefore enabling large numbers of MLOVs can impact performance and affect integration strategies. See “Creating and Administering Lists of Values” in Configiuring Siebel Business Applications on Oracle Technology Network for more details.
Note: This practice provides detailed steps on enabling a single MLOV in the application. Oracle provides automated tools for enabling large numbers of MLOVs at once. Contact your Oracle representative for assistance in obtaining and utilizing these tools.
1. Use Siebel Call Center to determine the LOV type for the Account Status field.
a. Select Start > Programs > Internet Explorer b. Enter Address: http://localhost/callcenter_enu.
c. Enter:
User ID SADMIN
Password SADMIN
d. Click the arrow.
e. Click the Accounts tab.
f. Click INS Account under Recent Records. Note that accounts you create in one language are visible in other languages, because they are all stored in the same database.
g. Click the Account List link.
h. Select the Status drop-down list for the INS Account and select a value from it that is probably unique to Account Status. (Check the solutions if you have trouble):
i. Navigate to Administration - Data > List of Values.
j. Query for a Display Value equal to the value you entered above, for example, Red Customer.
More than one Type may be returned. What is the most likely LOV Type for Account Status in the list of returned types?
Oracle Internal & Or acle Academy Use Only
Lesson 12: Multilingual Installations
k. Select the record whose Type is ACCOUNT_STATUS and whose and Display Value matches the value you entered above.
l. If necessary, scroll to the right to expose the Translate column.This determines whether the ACCOUNT_STATUS LOV Type is translatable.
m. Verify that the Translatable checkbox is selected for ACCOUNT_STATUS.
n. Log out of Siebel Call Center.
o. Stop the Siebel Server [OUEnt_OUSrvr] service. You will be compiling to the server srf file, hence any Siebel Servers connected to the repository must be stopped.
2. Use Siebel Tools to determine whether or not the ACCOUNT_STATUS LOV can be
transformed into an MLOV. Then modify the necessary columns to perform the transformation.
Note that this process can be automated with tools available from your Oracle representative.
Note: Siebel Tools is a tool used by developers to perform application customizations. It reads a set of tables in the database known as the Siebel Repository, and compiles these tables to a proprietary compressed binary file known as the Siebel Repository File. Typically an installation specialist would not be using Siebel Tools.
a. Select Start > Programs > Siebel_Tools_81 > Siebel Tools.
b. Log in as SADMIN/SADMIN, connecting to the Server database.
c. Click the Flat tab in the Object Explorer. While the Types tab lists object types in their hierarchies, the Flat tab lists all object types in alphabetical order, and is useful for quickly finding child object types.
Oracle Internal & Or acle Academy Use Only
f. Move LOV Type and LOV Bounded to the top of the list:
g. Click OK.
h. Query for columns with an LOV Type of ACCOUNT_STATUS:
i. Click the Query button .
ii. Enter ACCOUNT_STATUS in the LOV Type column.
iii. Click the Execute Query button .
i. Modify the columns to support the ACCOUNT_STATUS MLOV:
i. Verify that each column has the LOV Bounded checkbox checked. Only bounded picklists can be converted to MLOVs. Hence all of the columns returned by the query must have this checkbox checked in order for you to be able to enable translation on the LOV.
ii. List the parent tables of the columns. You must lock each parent table for editing in order to modify the table:
iii. Click Table in the Object Explorer on the left of the screen.
iv. Query for a Name of S_ORG_EXT. Note that you need to scroll to the right to expose the table name.
v. Right-click S_ORG_EXT and select Lock Object.
Note: Normally a developer would not lock objects in the Server repository, but would instead work in a local repository and then check in the changes. Performing these changes in the server database is strictly for educational purposes.
vi. Repeat these steps to lock the other tables you found: S_ORG_BU, S_UCM_ORG_EXT, S_FINAN_PROF, and S_INV_PROF.
vii. Click Column in the Object Explorer and re-query for columns with LOV Type ACCOUNT_STATUS.
viii. For each column, change the Translation Table Name to S_LST_OF_VAL.
Oracle Internal & Or acle Academy Use Only
Lesson 12: Multilingual Installations
j. Compile each table into the Server srf file:
i. Click the S_ORG_EXT Parent Table link in the appropriate record.
ii. Right-click S_ORG_EXT and select Compile Selected Objects.
iii. Browse for D:\OUses\siebsrvr\objects\enu\siebel_sia.srf. This is the repository file being used by your English applications.
Note: Best practice is NOT to compile into the server repository; it is done here only to expedite this lab.
iv. Click Compile. If you receive an error message that the file is in use, check to make sure all the Siebel Server services in the Enterprise are stopped.
v. Repeat these steps to compile to the French srf file in D:\OUses\siebsrvr\objects\fra\siebel_sia.srf.
vi. Click the back button to return to the column list.
vii. For each of the other four columns, compile the parent table to both the English and French srf files.
k. Select File > Exit from the application-level menu to close Siebel Tools.
3. Run the Database Configuration Utility to translate all existing LOV values in the application.
a. Select Start > Programs > Siebel Enterprise Server Configuration 8.1 > Database Server Configuration.
Oracle Internal & Or acle Academy Use Only
b. Enter the parameters:
Parameter Value Purpose
Siebel Server Directory D:\OUses\siebsrvr Location of Siebel Server executables.
Siebel Database Server
Directory D:\OUses\dbsrvr Location of Siebel Database Configuration Tool executables.
Database Platform Oracle Database Enterprise Edition
Type of database used by the Siebel
Enterprise. Note that you need to scroll down to locate this option.
Action Run Database Utilities
(Scroll down to find this) Used to synchronize database schemas, convert to Universal Time Code (UTC), or convert LOVs to MLOVs.
Action Type Multilingual List of Value Conversion
Used to translate existing LOV values in the database to MLOV values.
Validate or Translate? Translate Validation tests your settings before performing the actual translations.
Base Language English (American) Language for error logs.
ODBC Data Source
Name OUEnt_DSN Used to connect to the Siebel database.
Database User Name SADMIN Used to connect to the Siebel database.
Database User Password - and confirm
SADMIN Used to connect to the Siebel database.
Database Table Owner SIEBEL Used to access the Siebel database schema.
Database Table Owner Password
- and confirm
SIEBEL Used to access the Siebel database schema.
Siebel Repository Name Siebel Repository Used to add data to the Siebel Repository.
Parallel Indexing? Does not use the Oracle Parallel Indexing option
Used to improve performance when using multiple machines for the database server.
Security Group
ID/Grantee SSE_ROLE Role of Siebel Users in the database.
Log output directory mlov_translate Location to store installer log files.
Apply changes now? Yes Whether or not to apply the changes immediately.
c. Click OK to proceed with the Upgrade Wizard.
d. Once it is complete, cancel out of the Database Configuration Tool.
4. Start the Siebel Server [OUEnt_OUSrvr] service. Allow it to fully start before proceeding.
5. Test your changes:
a. Start Internet Explorer and enter an address of http://<machine name>/callcenter_enu.
b. Log in as SADMIN/SADMIN.
c. Click the Accounts tab.
d. Click My Accounts.
Oracle Internal & Or acle Academy Use Only
Lesson 12: Multilingual Installations
e. Select the Status drop-down field for the INS Account and verify the options are all in English.
f. Set the status to Qualified.
g. Log out of Siebel Call Center.
h. In Internet Explorer, enter an address of http://<machine name>/callcenter_fra.
i. Log in as SADMIN/SADMIN.
j. Click the Sociétés tab.
k. Click My Accounts.
l. Verify that the statut for the INS Account is Qualifie, French for “Qualified”.
m. Select the Statut drop-down field and verify the options are all in French.
n. Select Fichier > Déconnexion from the application-level menu to log out of the application.
Oracle Internal & Or acle Academy Use Only
Solutions 12-2 Enabling Multilingual Lists of Values (MLOVs)
Answers
1.h. Select the Status drop-down list and select a value from it that is probably unique to Account Status:.
Any of the Statuses containing the word “Customer” are likely candidates; for example, Red Customer, Former Customer, New Customer, or Present Customer.
1.j. Query for a Display Value equal to the value you entered above, for example, Red Customer. More than one Type may be returned. What is the most likely LOV Type for Account Status in the list of returned types?
ACCOUNT_STATUS. If the answer were not this obvious, you would need to query for several other of the available values for Account Status until you got a unique LOV Type.
2.i.ii. List the parent tables of the columns. You must lock each parent table for editing in order to modify the table:
S_ORG_EXT, S_UCM_ORG_EXT, S_ORG_BU, S_INV_PROF, S_FINAN_PROF