Oracle Financial Services Customer Information – Retail Performance Analytics Application v8.0.3.0.0 Patch Release #2 (8.0.3.0.2)

This Readme has the following sections:

·         Description

·         Prerequisites

·         Applying This Minor Release

·         Limitations and Known Issues

Description

Bug 25474039 – LANGUAGE PACK TRANSLATION FOR OFS CIRPA - CANADIAN FRENCH

This one off patch will apply the Language Pack translation for  Canadian French Language.

Prerequisites

·         Oracle Financial Services PFT Pack 8.0.3.0.0

·         OFS AAI LP 8.0.3.0.0.

Applying This Patch Release

To apply this patch, do the following:

1.       Copy/FTP the zip file " 25474039_GENERIC.zip" in BINARY mode, to a temporary folder on the server where OFSAAI is installed.

2.       Extract the contents of the zip file using the "unzip -a 25474039_GENERIC.zip" command. This will create a folder by the name OFS_PFT.

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

3.       Go to "./OFS_PFT/conf" and update 'params.conf' file with appropriate values for UPLOAD_MODEL=0.

4.       Provide RWX permissions to the shell script "./OFS_PFT/bin/install.sh"

5.       Execute install.sh

6.       Check the log file OFS_PFT_patch_installation.log¯ present under "./OFS_PFT/logs" in patch, to see if the patch is applied successfully.

CATALOG CONFIGURATION FOR LANGUAGE PACK – OBIEE

1.       Go to "./OFS_PFT/bin/patchfiles/CaptionsXML",copy " retail+performancecaptions.xml" file.

2.       Navigate to the OBIEE folder : $ORACLE_INSTANCE/bifoundation/OracleBIPresentationServicesComponent/$COMPONENT_NAME/msgdb/

3.       Create a folder structure in the following manner:

/msgdb/l_ar/captions

4.       Place the " retail+performancecaptions.xml" corresponding to Canadian French Language in the “captions” folder in the above folder structure.

5.       Restart Presentation Services in Enterprises Manager and login to analytics by selecting the language as Canadian French.

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

Limitations and Known Issues

The following table lists the known issues in this release:

Component

Sub- component

Bug ID

Description

Translation

-

25875681

REPORTS ON REGION USING DIM_LOCATION INSTEAD DIM_LOCATION_MLS.

25875251

OTHER LANGUAGES REPORTS USING DIM_CUSTOMER INSTEAD OF DIM_CUST_MLS

25875133

TRANSLATIONS ARE MISSING FOR SOME OF THE LABELS AND SUBJECT AREAS

25875315

REPORTS USE DIM_PRODUCT INSTEAD OF DIM_PRODUCT_MLS TABLES

Data Model

-

25881459

FEW COLUMNS IN DIM_******_MLS TABLES ARE MISSING