Oracle Financial Services Capital Adequacy Pack v8.0.3.1.0 One-Off Patch Release #1 (8.0.3.1.1)

Description

OFS CAP Application Pack 8.0.3.1.1 One-Off Patch Release #1 (ID 25308832).

This One-Off Patch Release of OFS CAP is cumulative of enhancements and bug fixes done since the 8.0.3.1.0 Maintenance Level Release.

Prerequisites

1.       Minimum Patch level set to Oracle Financial Services Capital Adequacy Pack (OFSCAP) 8.0.3.1.0

2.       Minimum OBIEE version must be 11.1.1.7.150120

 

How to Apply this Patch

1.       Copy/FTP the zip file 25308832_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 following command:

unzip -a 25308832_GENERIC.zip

Note: For a multi-tier installation of OFSAAI, patch must be executed on the database tier.

3.       Navigate to ./OFS_CAP_ADQ/conf directory and update params.conf file with appropriate values for UPLOAD_MODEL=0

4.       Provide RWX permissions to the shell script: ./OFS_CAP_ADQ/bin/install.sh

5.       Stop All OFSAA services and Web services.

6.       Execute the command: install.sh

7.       Start All OFSAA services and Web services.

8.       Verify the log OFS_CAP_ADQ_patch_installation.log file under ./OFS_CAP_ADQ/logs directory, to ensure if the patch is applied successfully.

9.       Navigate to ./OFS_CAP_ADQ/bin/CAP/repository directory and fetch OFS Basel Regulatory Capital Analytics - Repository.zip file.

a.        Extract and deploy the RPD file as per the Oracle Financial Services Capital Adequacy Pack Release 8.0.3.1.1 Admin Guide.

10.    Navigate to ./OFS_CAP_ADQ/bin/CAP/catalog/INDIA directory and fetch the catalog files present.

a.        Deploy the catalog files as per the Oracle Financial Services Capital Adequacy Pack Release 8.0.3.1.1 Admin Guide.

 

Post Patch Application

1.       Trigger the batches as per the 'Oracle Financial Services Basel RCA III Runchart - INDIA.xls' Runchart post data load.

2.       Trigger the 'IND Basel III Capital Calculation - Standardised Approach - Indian Banks'  or  'IND Basel III Capital Calculation - Standardised Approach - Foreign Banks' Run.

3.       As per the 'Oracle Financial Services Basel RCA III Runchart - INDIA.xls' Runchart, trigger the Batch '<Infodom>_BASEL_RCAIII_REFRESH_MAT_VIEWS' command after successful completion of the above run.

You can access Oracle documentation online from Documentation Library for OFSCAP 8.x. The Runchart documents are present in the 2017256.1 MOS page.

 

List of Features in this Release of OFS CAP

1.       Conforms to RBI RCAIII v1.3 latest template.

2.       Conforms to Metadata related to RBI RCAIII v1.3 latest template.

3.       Basel Reporting table population process (T2Ts and Metadata) is attached to 'IND Basel III Capital Calculation - Standardised Approach - Indian Banks' and 'IND Basel III Capital Calculation - Standardised Approach - Foreign Banks' Runs.

 

List of Known Issues Present in This Release of OFS CAP

Component

Sub-component

Bug

Subject

Description

STAGING

-

25335822

RCA III: NOTIONAL PRINCIPAL PAY AMOUNT NOT POPULATED FROM ALL PP TABLES

The data flow to populate the Notional Principal Pay Amount for derivatives in Fact Common Account Summary (FCAS) table is currently available only for Stage Swaps Contracts table. The same will be extended to cover Futures, Options, Money Market, and Repo Contract tables. Customers can modify the T2T populating into FCAS to populate the N_NOTIONAL_PRINCIPAL_PAY column from Futures, Options, Money Market, and Repo Contract tables for the cases where the reporting bank is a seller, that is, it has a short position in the instrument.

STAGING

-

25336586

RCA III: SANCTIONED AMOUNT IS NOT POPULATED FROM ALL THE PP TABLES

The data flow to populate the Sanctioned Amount of loans in Fact Common Account Summary (FCAS) table is currently available only for Stage LC Contracts table. The same will be extended to cover Loans and other similar tables. The customers can modify the T2T populating into FCAS to populate the n_limit column from Loans, OD and Credit Cards tables.

METADATA

-

25390920

RCA III: EXPOSURE AMOUNT IS NOT POPULATED

The data flow to populate the QCCP exposures is currently available in cases where in the QCCP also acts as a counterparty to the Reporting bank in other transactions. This is enhanced to cover all exposures to QCCPs regardless of whether they also act as counterparty to other transactions or not. The customers can modify the T2T populating FRCCS to populate the N_COUNTERPARTY_SKEY and other relevant information from FCT_CCP_DETAILS. This will be addressed in next release.