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 8.1.1.10 [23021] and laterInformation in this document applies to any platform.
Symptoms
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.)
Cause
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
Symptoms |
Cause |
Solution |