Oracle Financial Services Capital Adequacy Pack (OFSCAP) Application Pack Release 8.1.2.3.0 One-off Patch Release #1 (8.1.2.3.1)

Description

Patch ID 35536941: OFS CAP APPLICATION PACK 8.1.2.3.0 ONE-OFF PATCH RELEASE #1 - 8.1.2.3.1

 Pre-installation Requirements

· Ensure that you have installed the Oracle Financial Services Capital Adequacy Pack 8.1.2.3.0.

Pre-Installation Steps

In the PR2 TABLES in CONFIG SCHEMA:

1. Take back up of table PR2_RULE_QUERY.

2. Truncate the table PR2_RULE_QUERY.

How to Install this Release

To install the one-off patch, follow these steps:

1. Log in to My Oracle Support, and search for 35536941 under the Patches & Updates tab.

2. Download the 35536941_GENERIC.zip archive file and copy it to your OFSAA server in Binary mode.

3. Extract the contents of the patch archive file using the command:

unzip -a <name of the file to be extracted>

For example: unzip -a 35536941_GENERIC.zip

NOTE	The -a option is mandatory to unzip the patch.

If you notice the error message: unzip: not found [No such file or directory before the package is installed, contact your UNIX administrator.

4. Navigate to the following directory: ./appsLibConfig/conf

5. Update params.conf file with appropriate values for UPLOAD_MODEL=0

6. Provide RWX permissions to the shell script: ./OFS_BASEL_IRB/bin/setup.sh

7. Stop all the OFSAA services and Web services.

8. Execute the install command: ./setup.sh

9. Verify the log OFS_BASEL_IRB_installation.log file in the ./OFS_BASEL_IRB/logs directory to ensure that the patch is applied successfully.

10. After the successful installation of the release, restart all OFSAAI services.

Post-Installation

PR2 TABLES in CONFIG SCHEMA

1. Restore the backup of PR2_RULE_QUERY, if required for the already run execution audit.

Bugs Fixed in this release

The following issues are fixed in this release.

Bug ID	Bug Description	Change Description
35505087	ADD PROCESS TYPE FILTER WHEREVER APPLICABLE AND CHANGE RATING_MAP AND DIM_REG_CAP_RATING JOINS TO LEFT OUTER	Technical change. Rating standardization can differ for each record type within an approach depending upon the type of record getting processed which is handled through rule filters for metadata reusability. Such joins should be made left to avoid data filtering at the dataset level. The jurisdiction affected is RBI.
35477842	ANALYTICS FAILURES IN 8123	Technical change. Installer requires to commit characters for any metadata to be created or added.
35467100	RLSFT202 IS FAILING FOR UNSTABLE SET OF ROWS	Technical change. Rating standardization can differ for each record type within an approach depending upon the type of record getting processed which is handled through rule filters for metadata reusability. Such joins should be made left to avoid data filtering at the dataset level. Jurisdiction affected in KW/SAUD.
35410254	MR ATTRIBUTE T2TS MISSING IN 81X MARKET RISK	Technical Change. Stage-sourced data for Market Risk consumption handled. The jurisdiction affected is RBI.
35504900	CBK RULE RLMITI185 TO BE REMOVED FROM SAMA/RBI RUNS	Technical change. Jurisdictional changes for KW/RBI/SAUD.
35478155	ISSUE WITH LOAN SPLIT METHOD	Technical Change. The placement of rules changed to persist the RWA for accounts undergoing Loan Split or Unhedged Treatment. The jurisdiction affected is SAUD.
32725107	NEED NEW RULES TO STAMP N_STD_ACCT_HEAD_SKEY AND N_CAP_COMP_GROUP_SKEY IN FCT_ISSUED_INSTR_POSITIONS	Technical Change. Stamping of standard accounting head for Market Risk specific calculations.
35569337	V_PRODUCT NOT GETTING UPDATED IN DIM_RUN	Technical Change. Reporting requirement for populating DIM_RUN with the application code.

---

Oracle Financial Services Software   |   Copyright © 2023, 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