My Oracle Support Banner

Required Few Data Elements in table 'stg_rep_contracts' for reporting 'Reverse Repo' Reported As Loans in HC-C, RC-C schedules (FRY9C, FFIEC031/041) (Doc ID 2689144.1)

Last updated on JULY 15, 2020

Applies to:

Oracle Financial Services - Regulatory Reporting for US Federal Reserve - Lombard Risk Integration Pack - Version 8.0.9 and later
Information in this document applies to any platform.

Goal

REG REP USFED 80940

FSDF 8.0.9.0.0

Report- FRY9C, FFIEC031/041
Schedule- HC-C, RC-C
Line items- 2 and 9a

2. Loans to depository institutions and acceptances of other banks.........1288 2

2.a. To U.S. banks and other U.S. depository institutions...........1292 2.a.

b. To foreign banks.............1296 2.b.

 

9. Loans to non depository financial institutions and other loans:

a. Loans to non depository financial institutions..............J454 9.a.


Issue 1) Reverse Repos backed by mortgages/loans need to be reported as loans in RC-C Line 2 & 9a
Line 2 & 9a MDRMs uses business processors 'BPFD1664 and BPFD1691' which uses following data elements that are not available in table 'Stg_Repo_Contracts' for sourcing such Rev Repo loans
- N_AMORTIZED_COST
- N_CURRENT_FEES
- N_UNEARNED_INCOME
- V_SELLER_ID

Requirement:
a) Need these fields/equivalent to be incorporated in Stg_Repo_contracts
b) T2T should be updated to flow the information to FCAS

Issue 2) Such loans (Rev Repo reported as loans) have revolving facilities, while the revolving facilities can be captured in Stg_Credit_Line_Details, currently there is no V_LINE_CODE in 'Stg_Repo_Contracts' table for linking the Repo loans with Facilitie s (like Stg_Loan_Contracts)

Requirement:
a) Need the V_LINE_CODE/equivalent to be incorporated in Stg_Repo_contracts
b) T2T should be updated to flow the information to FCAS
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.