OFSS.png

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

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

Description

ID 29957985 – OFS Retail Performance Analytics  - Language Translation for Spanish-Spain (ES_ES).

Functional/ Technical Fix Applied

This patch will apply the Language Pack translation for the Spanish 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# 29957951 under the Patches and Updates tab.

2.       Download the 29957951_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 29957951_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 the 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_es/captions.

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

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

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

30632708

Customer Age, Customer Income, Age on Book dropdowns and Customer Distribution by Age Legends are not translated as we do not have a batch to load the DIM_BANDS_MLS table as of now.

 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 DIM_BANDS_MLS table needs to be considered as it is missing in the current run chart.

 

30428552

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

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.

 

30606090

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 Spanish 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

No results in Spanish. The report is available in English for Defaults Filters (Report 8).

30428309

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

30428284

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

30428261

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

30428244

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

30427841

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

30427819

There are no results in Spanish whereas the report is available in English for default filters (Report 3).

30427803

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

30427764

There are no results in Spanish. 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