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.
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
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.
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.
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.
Component |
Sub-component |
Bug |
Subject |
Description |
STAGING |
- |
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 |
- |
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 |
- |
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. |