My Oracle Support Banner

MLOV value is not displayed with specified default locale when outputting BIP report. (Doc ID 1581075.1)

Last updated on SEPTEMBER 08, 2020

Applies to:

Siebel CRM - Version [23021] and later
Information in this document applies to any platform.


When BIP report is output, "Code" value is displayed instead of Multi-lingual LOV (MLOV) value specified the default locale.
(However, template translation (xlf) is worked correctly.)

Report Image:

Screen Image:

MLOV Data:

This problem is happened when you set as follows at [Administration - BI Publisher Reports]> [Administration - BI Publisher Reports] (or [Reports - Custom Templates]),

- set [Output Type] other than "All"
- set [Default Locale] other than "English - United States"

Reproduce Procedure (following description is a sample of this issue),

(1) Preparation/Customization

1. Create a new MLOV

- Login Siebel Web Client as SADMIN.
- Move [Sitemap]> [Administration - Data]> [LOV Explorer].
- Create a new record.
      TYPE="TEST01", Translate="Y", Multilingual="Y", Replication Level="All"
- Expand [Types]> "TEST01"> [Values].
- Create new records.
      Code="001", Display Value="テストone" ("TEST one" in Japanese) , Language Name="Japanese", Active="Y",
        Translate="Y", Multilingual="Y"
      Code="002", Display Value="テストtwo" ("TEST two" in Japanese), Language Name="Japanese", Active="Y",
        Translate="Y", Multilingual="Y"
- move [List of Values].
- press [Clear Cache].

2. Prepare at Siebel Tools

- Login to Siebel Tools.
- Lock project "Account", "Table Party", "VERT CUT Common" and "SFA XMLP Project".
- Select [View]> [Options].
- Open [Language Setting] tab.
- Change Language to "JPN (Japanese)".

3. Create a new Pick List

- Go [Object Explorer]> [Pick List]
- Create a new record.
      Name="PickList Test01", Project="Account", Bounded="TRUE",
        Business Component="PickList Generic", Inactive="FALSE",
        Sort Specification="Order By", Type Value="TEST01"
- Compile the repository file (.srf).

4. Add a new Column

- Go [Object Explorer]> [Table].
- Select Name="S_PARTY".
- Go [Column].
- Create a new record.
      Name="X_TEST01", User Name="TEST01 Ext", Type="Extension", Nullable="TRUE",
        Translation Table Name="S_LST_OF_VAL", Physical Type="Varchar", Length="20",
        LOV Type="TEST01", LOV Bounded="TRUE", Status="Active", Inactive="FALSE"
- [Apply] and [Activate] it.
- Compile the repository file (.srf).

5. Add a new field into Business Component

- Go [Object Explorer]> [Business Component].
- Select Name="Account".
- Go [Field].
- Create a new record.
      Name="Test01", Column="X_TEST01", Inactive="FALSE", PickList="PickList Test01",
        Text Length="20", Type="DTYPE_TEXT".
- Go [Pick Map]
- Create a new record.
      Field="Test01", Picklist Field="Value", Inactive="FALSE"
- Compile the repository file (.srf).

6. Add a field into Applet

- Go [Object Explorer]> [Applet].
- Select Name="SIS Account List Applet".
- Go [List]> Name="List"> [List Column].
- Create a new record.
      Name="Test01", Field="Test01", HTML Type="Text", HTML Width="60",
        Runtime="TRUE", Show in List="TRUE", Inactive="FALSE"

- Go [Object Explorer]> [Applet].
- Select Name="SIS Account List Applet".
- Right click and select [Edit Web Layout].
- Add "Test01" into any empty field.
- Save it.

7. Add a new field into Integration Object

- Go [Object Explorer]> [Integration Object].
- Select Name="BIP Accounts - Current Query".
- Go [Integration Component]> Name="Accounts - Current Query"> [Integration Component Field].
- Create a new record.
      Name="Test01", Data Type="DTYPE_TEXT", Length="30", User Visible="TRUE",
        Type="Data", External Name="Test01", External Data Type="DTYPE_TEXT",
        External Length="30", XML Sequense="22", XML Tag="ssTest01", Inactive="FALSE"

- Go [Integration Component Field User Prop].
- Create a new record.
      Name="PICKLIST", Value="N", Inactive="FALSE"

8. Modify template file and replace (or upload)

- open "aclist.rtf" via MS-Word (with BIP Desktop add-in).
- change the field from "ssIndustry" to "ssTest01".
- save it.

- backup <BIP_HOME>\xmlp\XMLP\Reports\SiebelCRMReports\Account List\aclist.rtf.
- locate the modified "aclist.rtf" to <BIP_HOME>\xmlp\XMLP\Reports\SiebelCRMReports\Account List.

9. Start Siebel Server and BIP Server

- locate the compiled Repository file (.srf) into <SIEBEL_SERVER_ROOT>/OBJECTS/<LANG>.
- Start the Siebel Server service.
- Start BI Publisher service.

10. Set the defaults for reporting, and create data

- Login to Siebel Web Client.
- Move [Sitemap]> Administration - BI Publisher Reports]> [Administration - BI Publisher Reports].
- set [Output Type]="PDF" and [Default Locale]="Japanese - Japan".

- Move [Account] tab> [Account List].
- Create a new record (or use existing record), and set any value into [Test01] field.

(2) Execution for outputting the report

- Login to Siebel Web Client.
- Move [Account] tab> [Account List].
- Press [Report] icon and select "Accout List" report. (No "Output Type" dialog of choosing report format and locale displayed.)



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.