My Oracle Support Banner

Syndication/Participation - Net Share Sourcing/calculation Uptake In RRS (Doc ID 2606083.1)

Last updated on NOVEMBER 19, 2019

Applies to:

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

Symptoms

The issue is with respect to the RRR application's intake of mapping changes based on FSDF changes happened for Syndication/Participation. Below changes are required in RRR application with respect to incorporation of Syndication/Participation

1. Stage Credit Participation Details table to have only one records for Net Share wrt one Syndication Account number.
2. STG_PARTY_ACCOUNT_ROLE_MAP/STG_PARTY_ROLE_MAP not required for Net Share calculation but only for identifying the ‘Agent’ Bank for H1 schedule.
3. Sourcing of following fields required for Reg reporting wrt syndication to be sourced as under, along with the Change ETAs.
a. STG_CREDIT_PARTCPN_DETAILS.N_DEFERRED_CUR_BAL will be added to DE sheet and used, changes/T2T mappings will be available in v RRS 8084.
b. STG_CREDIT_PARTCPN_DETAILS.N_EOP_BOOK_BAL will be added to DE sheet and used, changes/T2T mappings will be available in v RRS 8084.
c. STG_LOANS_CONTRACTS.N_SANCTIONED_LIMIT will be used (and N_CURRENT_CREDIT_LIMIT will be removed from DE sheet).
From STG_CREDIT_PARTCPN_DETAILS.N_TOT_COMM_AMT is the corresponding column and that will be used.
d. STG_CREDIT_PARTCPN_DETAILS. N_FEES will be added to DE sheet and used, changes/T2T mappings will be available in v RRS 8084.
e. STG_CREDIT_PARTCPN_DETAILS. N_ACCRUED_INTEREST will be added to DE sheet and used, changes/T2T mappings will be available in v RRS 8084.
f. Available SCPD. N_UNDRAWN_AMOUNT already shown in DE sheet will be used.
g. N_DEFERRED_FEE_BAL-Stg Loan Contracts/PP table itself supposed to store only Lead Bank’s in this column - N_DEFERRED_FEE_BAL thus will be used. (and thus is not required/will not be added/used from STG_CREDIT_PARTCPN_DETAILS.).
h. N_DEF_CUR_PREM_DISC- This column from Investment/MM contracts is not applicable for Syndication/Participation. Instead the other column N_DEFERRED_CUR_BAL is the applicable column (commented above).
i. N_NET_UNAMORTIZED_LOAN_FEE - Stg Loan Contracts/PP table itself supposed to store only Lead Bank’s in this column - N_NET_UNAMORTIZED_LOAN_FEE thus will be used. (and thus is not required/will not be added/used from STG_CREDIT_PARTCPN_DETAILS.).
4.While sharing Lead Bank Net shared in Stg Credit Participation Details table, though the Gross share is required in the Stage PP Table, in case this information is not available, sourcing the Net Share in Stage PP Table can be done and will not have any issue 
5 . The account number for the record with Lead Bank Net share in Stage Credit Participation will generally be the same as the Syndication account number

Cause

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
Symptoms
Cause
Solution


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