OFSS.png

 

Regulatory Reporting for US Federal Reserve – Lombard Risk Integration Pack v8.0.4.1.0 One-off Patch Release #1 (8.0.4.1.1)

 

OFS Regulatory Reporting for US Federal Reserve – Lombard Risk Integration Pack is a separately licensed product.

Description

Patch 26422232 - Oracle Financial Services Regulatory Reporting for US Federal Reserve – Lombard Risk Integration Pack v8.0.4.1.0 One-off Patch Release #1 (8.0.4.1.1)

This release of OFS REG REP US FED is cumulative of all enhancements and bug fixes done since v8.0.4.1.0 release.

Prerequisite

The prerequisite software that must be installed are:

1.     OFS REG REP US FED v8.0.4.1.0 Interim Release patch 26228650

2.     Agile Reporter version 1.15.4-b1112

3.     AgileREPORTER Templates version ARforFED_v1.10.0.5.zip

How to Install This One-off Patch Release?

Perform the following instructions to download, extract and install this one-off patch:

1.     Download the 26422232_GENERIC.zip archive file from https://support.oracle.com/ for patch 26422232 under the Patches & Updates tab.

2.     Copy the archive file to your OFSAA server in Binary mode.

3.     Shut down all the OFSAAI Services. For more information, see the Start/Stop Infrastructure Services section in Oracle Financial Services Advanced Analytical Applications Infrastructure Pack Installation Guide – Release 8.0.4.1.0.

NOTE:    Ensure that the FICSERVER is up and running.

4.     Execute unzip -a <name of the file to be unzipped>

For example: unzip -a 26422232_GENERIC.zip

NOTE:    The above "-a" option is mandatory to unzip the patch.
If you notice an error message “unzip: not found [No such file or directory]”, contact your UNIX administrator to resolve this issue.

5.     Execute chmod –R 755 OFS_REG_REP_USFED

6.     Navigate to <>/OFS_REG_REP_USFED/conf directory

7.     Configure UPLOAD_MODEL parameter in the params.conf file to determine if Model Upload is required or not:

0 = If you have already performed Model Upload and want to skip Model Upload process

1 = If you want to perform Model Upload

8.     Navigate to <>/OFS_REG_REP_USFED/bin directory and execute ./install.sh

9.     The installation progress can be viewed by periodically refreshing the log file under the <>/OFS_REG_REP_USFED/logs directory

10.  After installation is completed, verify the log file for any Errors or Warnings. Contact My Oracle Support in case of any issues.

NOTE:    This patch installation has taken approximately 15 minutes to complete in Oracle Labs.

 

Post-Installation Steps

The post-installation steps required for this release are:

1.     Generate the application EAR / WAR file and redeploy the application on the configured Web Application Server. For more information on generating and deploying EAR / WAR file, refer to the Post Installation Configuration section in Oracle Financial Services Advanced Analytical Applications Infrastructure Pack Installation Guide – Release 8.0.4.1.0.

2.     Execute A_SECURITIZED_FLAG.sql script file in Config Schema after replacing the ##INFODOM## placeholder with the corresponding INFODOM name.

3.     Restart all the OFSAA services. For more information, see the Start/Stop Infrastructure Services section in Oracle Financial Services Advanced Analytical Applications Infrastructure Pack Installation Guide – Release 8.0.4.1.0.

4.     Except <<INFODOM>>_USFED_FR2052A_RESAVEDEPV, Re-save derived entities using the batches available for the respective reports.

 

Post USFED Run Execution

Perform the following instructions after US FED Run Execution:

1.     For prior date reporting, please see the Prior Date Reporting document.

2.     Execute ##INFODOM##_USFED_RUNEXE_RESAVE batch to populate RUNEXESUMM table.

Lombard AgileREPORTER would display additional filters of Run Execution ID and Run Status during report retrieval based on RUNEXESUMM table.

a.     Run Execution ID is Run Execution Identifier concatenated with Run Description.

b.    Run Status shows the status of US FED Run Execution.

c.     Define the entities as SOLO or CONSOLIDATED in Lombard AgileREPORTER before retrieving returns.

 

Deploying Lombard AgileREPORTER Package Configuration

After saving the derived entities, proceed to deploy the product configuration on the Lombard AgileREPORTER using the OFSAA_REG_REP_USFED_80411.zip file bundled inside Config_Package directory (OFS_REG_REP_USFED\Config_Package\) of the installer.

To deploy Product Configuration on Lombard AgileREPORTER, see the Lombard AgileREPORTER Installation Guide v1.15.4.

 

List of Bugs Fixed in This Release

The bugs fixed in this release are as follows.

Component

Sub Component

Bug ID

Subject

Metadata

26422590

FFIEC-031 AND FR-Y14Q RETAIL DATA SCHEDULE VERSION CHANGES

26389128

H-M LINKAGE MISSING FOR CELL ID: CQSCS370

T2T

26386995

F_RESTRUCTURED_FLAG IS NOT REQUIRED FOR MDRM CODES BHCKK163 & RCFDK163

 

Known Issues/ Limitations in This Release

There are no known issues / limitations in this release.

 

 

Oracle Financial Services Software Confidential and Restricted   |   Copyright © 2017, 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