OFSS.png

Financial Services Retail Customer Analytics Release v8.0.7.2.0 One-off Patch #6 (8.0.7.2.6)

OFS Retail Performance Analytics is a part of the OFS Profitability Application Pack.

Description

ID 29958003 – OFS Retail Performance Analytics  - Language Translation for Japanese-Japan (JA_JP).

Functional/ Technical Fix Applied

This patch will apply the Language Pack translation for the Japanese Language.

Prerequisites

1.        Oracle Financial Services Profitability (PFT) Application Pack 8.0.7.2.0

2.       AAI LP 8.0.7.2.0

3.       OBIEE Version: Oracle Business Intelligence 12.2.1.4.0

How to Install this Language Pack Release?

1.        Login to https://support.oracle.com/, and search for the Bug# 29958003 under the Patches and Updates tab.

2.       Download the 29958003_GENERIC.zip archive file, and copy it to your OFSAA server in binary mode.

3.       Extract the contents of the patch archive file by using the command:

unzip -a 29958003_GENERIC.zip

This command will create a folder named OFS_PFT.

Note: In case of a multi-tier installation of OFSAAI, the patch needs to be executed on the DB tier.

4.       Navigate to ./PFT_PFT/conf and update params.conf file with appropriate values for UPLOAD_MODEL=0.

5.       Provide RWX permission to the shell script ./OFS_PFT/bin/install.sh.

6.       Execute install.sh

7.     Check the log fine OFS_PFT_patch_installation.log at the location ./OFS_PFT/logs in the patch to see if it has been applied successfully.

Catalog Configuration for Language Pack - OBIEE

1.        Navigate to ./OFS_PFT/bin/patchfiles/CaptionsXML and copy the retail+performancecaptions.xml file.

2.       Navigate to the OBIEE folder at $ORACLE_HOME/user_projects/domains/bi/bidata/service_instances/ssi/metadata/content/msgdb

3.       Create a folder structure named /l_ja/captions.

4.       Paste the retail+performancecaptions.xml file corresponding to the Japanese Language in the captions folder.

5.       Restart the OBIEE servers and login to Analytics by selecting the language as Japanese.

6.     Verify that the captions are translated in the Dashboard Reports.

Post-installation Step

The post-installation step required for this release is deploying the RPD and Catalog:

1.        Take the rpd and catalog from the location $FIC_HOME/OFSPFTPACKBI/OBIEE/12.2.1.4.0 and deploy it.

Note: For detailed installation instructions, see Deploying OFS PFT Pack Report Analytics section in Oracle Financial Services Profitability Application Pack Installation Guide 8.0.7.0.0.

Known Issues in This Release

The known issues in this release are as follows:

Category

Sub-category

Bug ID

Description

 Other

 

 

BI

30556178

The following issues are identified (not translated) in the OBIEE reports:

·         NIBT Hierarchy values under product summary

·         LOB values in a Report

·         Channel values and X-Axis

·         Flash messages

·         “CUSTOMER NAME” and “CUSTOMER ID”

·         “NET CREDIT LOSSES” values

·         Reporting line column values

·         Customer Gender filter values

·         Legends

30605665

"Customer Distribution" report under Customer Summary is not translated.

30605636

"NULL" value under LOB dropdown of the LOB performance is not translated.

30605589

"Profit & Loss Scenario Comparison" under Product Performance: NIBT is not translated.

 Data

 

30400677

SCD for DIM_SEGMENT_MLS needs to be considered as it is missing in the current run chart.

No MLS TABLE for segment types.

30632708

Batch to load the DIM_BANDS_MLS table needs to be considered as it is missing in the current run chart.

 

30428552

Batch to load the DIM_GENDER_MLS table needs to be considered as it is missing in the current run chart.

 

30632797

Few records in the REV_DIMENSIONS_TL, DIM_BANDS_TL, and FSI_MESSAGES_MLS tables are not translated.

Metadata

30348668

Few records in the METADATA_LOCALE_MASTER table are not translated.

30466402

MENU_IDs 'OFS_AAI' and 'OFS_AAI_SYSADMN' are not translated in the AAI_MENU_TL  table.

UI

30428491

“NET INCOME BEFORE TAXES” is not translated.

 

30632809

This is a generic bug to address few UI related translation issues.

Limitations in This Release

The limitations in this release are as follows:

Category

Sub-category

Bug ID

Description

 Other

 

 

BI

30483222

Report in Japanese is not available for "NEW ACCOUNT DISTRIBUTION BY CUSTOMER SEGMENT" under NEW BUSINESS ANALYSIS.

30406705

Under BUSINESS SUMMARY > WHAT-IF ANALYSIS > COMPARISON OVER APPLIED VARIATIONS is showing results in English when we click "PLAY".

30428460

There are no results in Japanese. Report is available in English for Defaults Filters (Report 8).

30428309

Only one report is coming in Japanese whereas we have two reports in English (Report 7).

30428284

There are no results in Japanese. The report is available in English for default filters (Report 6).

30428261

There are no results in Japanese. The report is available in English for default filters (Report 5).

30428244

Only one report is coming in Japanese whereas we have two reports available in English for default filters (Report 4).

30427841

Two reports are missing for the same default filters in Japanese.

30427819

There are no results in Japanese. The Report is available in English for default filters (Report 3).

30427803

There are no results in Japanese. The report is available in English for default filters (Report 2).

30427764

There are no results in Japanese. The report is available in English for default filters (Report 1).

Data

30428473

Product Family value “MISSING” is not translated.

 

Oracle Financial Services Software   |   Copyright © 2020, Oracle and/or its affiliates. All rights reserved.   |   Phone: +1.650.506.7000   |   Fax: +1.650.506.7200   |   www.oracle.com/industries/financial-services/index.html