MLOV value is not displayed with specified default locale when outputting BIP report.

(Doc ID 1581075.1)

Last updated on AUGUST 24, 2015

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.)



Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms