Financial Services Institutional Performance Analytics Release v8.0.7.2.0 One-off Patch Release #4 (8.0.7.2.4)

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

Description

ID 29957967 – OFS Institutional Performance Analytics - Language Translation for Arabic-Egypt (AR_EG).

Functional/Technical Fix Applied

This one-off patch will apply the Language Pack translation for the Arabic (AR_EG) language.

Prerequisites

The prerequisites required for this release are:

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

2.       Oracle Financial Services Institutional Performance Analytics 8.0.7.2.1

3.       AAI LP 8.0.7.0.0 (Patch number 29646990)

4.       AAI Patch 8.0.7.2.0 (Patch number 29920053)

5.       AAI LP Patch 8.0.7.2.0 (Patch number 30516409)

How to Install this Language Pack Release?

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

2.       Download the 29957967_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 29957967_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 permissions to the shell script ./OFS_PFT/bin/install.sh.

6.       Execute install.sh

7.       Check the log file OFS_PFT_patch _installation.log at the location ./OFS_PFT/logs in 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 institutional+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_ar/captions.

4.       Paste the institutional+performancecaptions.xml file corresponding to the Arabic Language in the captions folder.

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

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

Post-installation Steps

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 location 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 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. And No MLS TABLE for segment types.
		30605928	Few records in REV_DIMENSIONS_TL, DIM_BANDS_TL, and FSI_MESSAGES_MLS table are not translated.
		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', 'OFS_AAI_SYSADMN' are not translated in the AAI_MENU_TL  table.
UI	User Interface	30605957	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 Arabic 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".
	Data	30428473	Product Family values “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