Regulatory
Reporting for US Federal Reserve – Lombard Risk Integration Pack v8.0.4.0.0
One-off Patch Release #2 (8.0.4.0.2)
OFS Regulatory Reporting for US Federal Reserve – Lombard Risk Integration Pack is a separately licensed product.
Description
Bug
26198382 - Oracle Financial Services
Regulatory Reporting for US Federal Reserve – Lombard Risk Integration Pack
v8.0.4.0.0 One-off Patch Release #2 (8.0.4.0.2)
This
release of OFS REG REP US FED is cumulative of all enhancements and bug fixes
done since v8.0.4.0.1 release.
The
prerequisites for this one-off patch are:
1.
The minimum patch set level must be OFS REG REP US FED v8.0.4.0.0 (Bug 25710692).
2.
AgileREPORTER version 1.15.3-b1033 must be installed.
3.
AgileREPORTER Templates (ARforFED_v1.9.1.6.zip) must be available in AgileREPORTER.
4.
OFS REG REP US FED 8.0.4.0.0 needs additional attributes in
the data model only for FR-2052A. Extend FSDF model with the following
attribute.
a.
On FSDF 804, perform the following change to the OFSAA
model:
|
Physical Table Name |
Attribute Name |
Table Description |
|
FSI_ACCT_COLL_CASHFLOWS |
FSI Account
Collateral Cashflows |
This processing
table stores the details of account cashflows according to the result bucket
and the collateral. |
|
Physical Table Name |
Column Name |
Attribute Name |
Data Type |
Domain |
Null Allowed? |
PK |
FK |
Reference Table
Name |
Reference Column
Name |
Column Comments |
|
FCT_REG_AGG_CASH_FLOWS |
N_COLLATERAL_ASSET_LEVEL_SKEY |
Collateral Asset Level
Surrogate Key |
NUMBER(10) |
SurrogateKey_Long |
Yes |
No |
Non-Identifying |
DIM_ASSET_LEVEL |
N_ASSET_LEVEL_SKEY |
This attribute
stores the Surrogate Key (SKey) for the asset level of the collateral. |
|
FCT_REG_AGG_CASH_FLOWS |
N_COL_FAIR_VALUE_RCY |
Collateral Fair
Value In Reporting Currency |
NUMBER(22,3) |
Amount |
Yes |
No |
– |
– |
– |
This attribute
stores the collateral fair value as assessed by the entity to which has
received the collateral in reporting currency. |
|
FCT_REG_AGG_CASH_FLOWS |
V_COLL_CCY_CODE |
Collateral Currency
Code |
VARCHAR2(3) |
Code_Currency |
Yes |
No |
Non-Identifying |
DIM_CURRENCY |
V_ISO_CURRENCY_CD |
This attribute
stores the currency code associated with collateral. |
|
FCT_REG_AGG_CASH_FLOWS |
F_QUALIFIED_UNENCUMBRANCE_FLAG |
Qualified
Unencumberance Flag |
CHAR(1) |
Flag |
Yes |
No |
– |
– |
– |
This attribute
indicates if unencumbered collateral satisfies conditions of Unencumbrance as
described in FR-2052A. |
|
FCT_REG_AGG_CASH_FLOWS |
N_COL_FAIR_VALUE |
Collateral Fair
Value |
NUMBER(22,3) |
Amount |
Yes |
No |
– |
– |
– |
This attribute
stores the collateral fair value as assessed by the entity to which has
received the collateral. |
|
FCT_REG_AGG_CASH_FLOWS |
N_UNDERLYNG_ASSET_LEVEL_SKEY |
Underlying Asset
Level Surrogate Key |
NUMBER(10) |
SurrogateKey_Long |
Yes |
No |
Non-Identifying |
DIM_ASSET_LEVEL |
N_ASSET_LEVEL_SKEY |
This attribute
stores the underlying asset level SKey. |
|
FCT_REG_AGG_CASH_FLOWS |
N_UNDERLYNG_ASSET_VALUE |
Underlying Asset
Value |
NUMBER(22,3) |
Amount |
Yes |
No |
No |
– |
– |
This attribute
stores the underlying asset value. |
|
FCT_REG_AGG_CASH_FLOWS |
N_UNDERLYNG_ASSET_VALUE_RCY |
Underlying Asset
Value In Reporting Currency |
NUMBER(22,3) |
Amount |
Yes |
No |
No |
– |
– |
This attribute
stores the underlying asset value in reporting currency. |
|
FCT_REG_AGG_CASH_FLOWS |
V_UNDERLYNG_ASSET_CCY_CODE |
Underlying Asset
Currency Code |
VARCHAR2(3) |
Code_Currency |
Yes |
No |
Non-Identifying |
DIM_CURRENCY |
V_ISO_CURRENCY_CD |
This attribute
stores the currency code of the underlying asset. |
|
FCT_REG_AGG_CASH_FLOWS |
N_ASSET_LEVEL_SKEY |
Asset Level
Surrogate Key |
NUMBER(10) |
SurrogateKey_Long |
Yes |
No |
Non-Identifying |
DIM_ASSET_LEVEL |
N_ASSET_LEVEL_SKEY |
This attribute
indicates if customer is affiliated to the covered company. Affiliated with
respect to a covered company that is a consolidated subsidiary of a bank
holding company or savings and loan holding company of which the covered
company is also a consolidated subsidiary. |
|
FSI_ACCT_COLL_CASHFLOWS |
N_MIS_DATE_SKEY |
Extraction Date Key |
NUMBER(10) |
SurrogateKey_Long |
No |
Yes |
Identifying |
DIM_DATES |
N_DATE_SKEY |
This attribute stores
the date surrogate key corresponding to MIS date. |
|
FSI_ACCT_COLL_CASHFLOWS |
N_RUN_SKEY |
Run Surrogate Key |
NUMBER(10) |
SurrogateKey_Long |
No |
Yes |
Identifying |
DIM_RUN |
N_RUN_SKEY |
This attribute
stores the Unique SKey for each Run. |
|
FSI_ACCT_COLL_CASHFLOWS |
N_ACCT_SKEY |
Account Surrogate
Key |
NUMBER(10) |
SurrogateKey_Long |
No |
Yes |
Identifying |
DIM_ACCOUNT |
N_ACCT_SKEY |
This attribute
stores the Unique SKey generated for each Account Number. |
|
FSI_ACCT_COLL_CASHFLOWS |
N_RESULT_BUCKET_SKEY |
Result Bucket
Surrogate Key |
NUMBER(10) |
SurrogateKey_Long |
No |
Yes |
Identifying |
DIM_RESULT_BUCKET |
N_RESULT_BUCKET_SKEY |
This attribute
stores the Time bucket SKey. |
|
FSI_ACCT_COLL_CASHFLOWS |
N_MITIGANT_SKEY |
Mitigant Surrogate
Key |
NUMBER(10) |
SurrogateKey_Long |
No |
Yes |
Identifying |
DIM_MITIGANT |
N_MITIGANT_SKEY |
This attribute
stores the Unique SKey to represent a particular mitigant. |
|
FSI_ACCT_COLL_CASHFLOWS |
N_PLACED_COLLATERAL_SKEY |
Posted Collateral
Surrogate Key |
NUMBER(10) |
SurrogateKey_Long |
No |
Yes |
No |
– |
– |
This attribute
stores the SKey of the posted collateral. |
|
FSI_ACCT_COLL_CASHFLOWS |
N_CASHFLOW_AMT_DENOMENATOR |
Cashflow Amount
Denominator |
NUMBER(22,3) |
Amount |
Yes |
No |
– |
– |
– |
This attribute
stores the sum of cashflows of an account. |
|
FSI_ACCT_COLL_CASHFLOWS |
N_CASHFLOW_AMT_NUMERATOR |
Cashflow Amount
Numerator |
NUMBER(22,3) |
Amount |
Yes |
No |
– |
– |
– |
This attribute
stores the cashflows of an account for a particular result bucket. |
|
FSI_ACCT_COLL_CASHFLOWS |
N_CASHFLOW_ALLOCATION_RATIO |
Cashflow Allocation
Ratio |
NUMBER(9,6) |
Ratio |
Yes |
No |
– |
– |
– |
This is the ratio
of N_CASHFLOW_AMT_NUMERATOR and N_CASHFLOW_AMT_DENOMENATOR columns. |
|
FSI_ACCT_COLL_CASHFLOWS |
N_COLLATERAL_AMT_DENOMENATOR |
Collateral Amount
Denominator |
NUMBER(22,3) |
Amount |
Yes |
No |
– |
– |
– |
This attribute stores
the collateral value (adjusted for collateral weight) for an account from
particular collateral. |
|
FSI_ACCT_COLL_CASHFLOWS |
N_COLLATERAL_AMT_NUMERATOR |
Collateral Amount
Numerator |
NUMBER(22,3) |
Amount |
Yes |
No |
– |
– |
– |
This attribute stores
the total collateral value (adjusted for collateral weight) for an account. |
|
FSI_ACCT_COLL_CASHFLOWS |
N_COLLATERAL_ALLOCATION_RATIO |
Collateral
Allocation Ratio |
NUMBER(9,6) |
Ratio |
Yes |
No |
– |
– |
– |
This is the ratio of
N_COLLATERAL_AMT_NUMERATOR and N_COLLATERAL_AMT_DENOMENATOR columns. |
|
FSI_ACCT_COLL_CASHFLOWS |
N_COLLATERAL_ASSET_CLASS_SKEY |
Collateral Asset
Level Surrogate Key |
NUMBER(10) |
SurrogateKey_Long |
Yes |
No |
Non-Identifying |
DIM_ASSET_LEVEL |
N_ASSET_LEVEL_SKEY |
This attribute
stores the SKey for the asset level of the collateral. |
|
FSI_ACCT_COLL_CASHFLOWS |
N_COLLATERAL_VALUE |
Collateral Value |
NUMBER(22,3) |
Amount |
Yes |
No |
– |
– |
– |
This attribute stores
the collateral fair value as assessed by the entity which has received the
collateral for the account cashflow. |
|
FSI_ACCT_COLL_CASHFLOWS |
N_CASHFLOW_VALUE |
Cashflow Value |
NUMBER(22,3) |
Amount |
Yes |
No |
– |
– |
– |
This attribute stores
the cashflow amount adjusted according to the mapped collateral. |
Note: These
columns will be regularized as part of OFSDF v80500 release.
How to Install This One-off Patch Release?
The
steps to install the one-off patch are:
1. Login to https://support.oracle.com/, and search
for Bug# 26198382
under Patches and
Updates tab.
2.
Download 26198382_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
26198382_GENERIC.zip
Note: The above "-a" option is mandatory to unzip the patch.
In case you notice an error message “unzip: not found [No such file or
directory” before the package is installed, contact your UNIX administrator to
resolve this issue.
5.
Grant RWX (755) permissions for folder by executing the command:
chmod 755 OFS_REG_REP_USFED
6.
Navigate to the path:
<>/OFS_REG_REP_USFED/conf
7.
Update params.conf file with upload model parameter as 0.
8.
Navigate to the path:
<>/OFS_REG_REP_USFED/bin
9.
Execute the install command:
./install.sh
10.
Verify the patch installation logs in the path:
<>/OFS_REG_REP_USFED/logs
11. Generate the application EAR/WAR
file and redeploy the application in the configured web application server.
12. After successful deployment, restart all the OFSAAI
services.
13. Except <<INFODOM>>_USFED_FR2052A_RESAVEDEPV, Re-save derived entities using the batches
available for the respective reports.
Post-Installation
Steps
The post-installation
steps required for this release are:
1.
Execute the following view scripts (available under “OFS_REG_REP_USFED/Post_Scripts”
directory of the patch) in Atomic Schema:
a.
FR2052A_ASSET_INFLOW.sql
b.
FR2052A_DEPOSITS_OUTFLOW.sql
c.
FR2052A_FX_SUPPLEMENTAL.sql
d.
FR2052A_INFO_SUPPLEMENTAL.sql
e.
FR2052A_OTHER_INFLOW.sql
f.
FR2052A_OTHER_OUTFLOW.sql
g.
FR2052A_SECURED_INFLOW.sql
h.
FR2052A_SECURED_OUTFLOW.sql
i.
FR2052A_UNSECURED_INFLOW.sql
j.
FR2052A_WHOLESALE_OUTFLOW.sql
2.
Execute the batch <<INFODOM>>_USFED_FR2052A_RESAVEDEPV after the previous SQL scripts
are executed.
3.
The following SQL statement must be executed in Config Schema, if this
INDEX is not created:
CREATE INDEX index_mdr_mod_parent_child
ON mdb_object_dependencies
(parent_object_def_id,child_object_def_id)
COMPUTE STATISTICS
/
Post USFED Run
Execution
The post US FED run execution
steps required for this release are:
1.
For prior date
reporting, please see the Prior
Date Reporting document
2.
After US FED run
execution is completed, execute the following batch:
##INFODOM##_USFED_RUNEXE_RESAVE
List of Bugs
Fixed in This Release
The bugs fixed in this
release are as follows.
|
Component |
Sub Component |
Bug ID |
Subject |
|
Metadata |
SCD |
MATURITY
AMOUNT IS NOT SHOWING UP IN SUMMARY VIEW FOR DEFR025 |
|
|
– |
DEINC001
FILTER ISSUE |
||
|
– |
FCT_DEPOSITS_BORROWINGS:
FK ON N_CUST_TYPE_SKEY REFERENCING DIM_PARTY_TYPE |
||
|
– |
ISSUE
WITH ATTRIBUTE "INTERNAL" OF FR2052A_DEPOSITS_OUTFLOW FOR DEFR008 |
||
|
– |
I.S.7
DE-JOIN ISSUE CAUSING DUPLICATE RECORDS |
||
|
– |
FR-2052A:
HIREG142 OVERWRITTEN BY PATCH of RBI - 8.0.3.0.8 |
||
|
– |
CHANGE
IN DE FOR O.W |
||
|
– |
PRIME
BROKERAGE FLAG REPORTING IN I.O.8 |
||
|
– |
I.O.8
DE-JOIN ISSUE CAUSING DUPLICATE RECORDS |
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