OFS Regulatory
Reporting for European Banking Authority (EBA) – Lombard Risk Integration Pack
is a separately licensed product.
Description
Bug 25385879
– OFS REG REP EBA LOMBARD RISK INTEGRATION PACK v8.0.3.0.0 MAINTENANCE LEVEL
RELEASE #1 (8.0.3.1.0)
This maintenance level patch of OFS REG REP EBA holds incremental
enhancements / bug fixes done since the 8.0.3.0.0 Release:
·
Lombard Reporter Portal Template version
1.25.0.4
·
Lombard Reporter Portal version
1.15.1-b9070
·
Returns aligned to the supported version
of template 1.25.0.4 are:
o
F 13.03 – Collateral obtained by taking
possession [tangible assets] accumulated
o
F 19 – Information forborne exposures -
Row 140 and Row 160
o
F 20 – Geographical breakdown of assets
o
C 07 – Credit and counterparty credit
risks and free deliveries - Col 10
Prerequisites
The pre-requisites required for this release is as follows:
·
The minimum patch
set level should be OFS REG REP EBA 8.0.3.0.0 (Java7).
·
Oracle Financial
Services Data Foundation version 8.0.4.0.0
How to Apply This Maintenance Level Patch Release?
Follow the below steps to apply the maintenance level
patch:
1.
Login to https://support.oracle.com/ and
search for Bug#
25385879
under
Patches and Updates tab.
2.
Download 25385879_GENERIC.zip archive file, and copy it to your OFSAA server in Binary
mode.
3.
Shut down all the OFSAAI Services.
4.
Extract the contents of the patch archive file by using the
command: unzip
-a <name of the file to be unzipped>
For example: unzip -a 25385879_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” when the package is not installed, contact
your UNIX administrator to resolve this issue.
5.
Grant RWX (755) permissions for folder by executing command: chmod 755 OFS_REG_REP_EBA
6.
Navigate to the path: <>/OFS_REG_REP_EBA/conf
7.
Update params.conf file
with upload model parameter as 0.
8.
Navigate to the path: <>/OFS_REG_REP_EBA/bin
9.
Execute the command: ./install.sh
10.
Verify the patch installation logs in the path <>/OFS_REG_REP_EBA/logs.
Contact Oracle support in case of any errors.
11.
Restart all the OFSAAI services.
Limitations in this Release
If Oracle Financial Services Data Foundation version
8.0.4.0.0 is not available, ensure that the following attributes are available
in the data model.
Column Change Type |
Physical Table Name |
Column Name |
Logical Name |
Data Type |
Domain |
Null Allowed? |
PK |
FK |
Reference Table Name |
Reference Column Name |
Column Comments |
Column Default Value (If Any) |
Add Column |
Fct_Common_Account_Summary |
n_hedged_amount |
Hedged amount |
NUMBER(22,3) |
Amount |
Yes |
No |
No |
– |
– |
This column indicates the amount that is
hedged. If this amount is same as EOP balance then it is a complete hedge. If
this amount is less than the EOP balance then it is a partial hedge. |
– |
Add Column |
Fct_Reg_Account_Summary |
n_tot_prov_rcy |
Total provision amount in RCY |
NUMBER(22,3) |
Amount |
Yes |
No |
No |
– |
– |
This column stores the total provision
amount for the customer in reporting currency. |
– |
Add Column |
Fct_Reg_Account_Summary |
n_nominal_value_rcy |
Nominal Value Rcy |
NUMBER(22,3) |
Amount |
Yes |
No |
No |
– |
– |
Nominal/Face Value in Reporting Currency. |
– |