My Oracle Support Banner

Usage Of Issuer Code From 'STG_MITIGANTS' For Producing FFIEC-009 Report For Lending SOR (Doc ID 2749653.1)

Last updated on FEBRUARY 09, 2021

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

Version: RRS 80961, FSDF 80930
Report/Schedule: FFIEC009/ C-Part II

Issue:
The current Oracle configuration expects Issuer Code from STG_MITIGANTS in order to perform the collateral determination however the lending SORs (AFS, Infolease and LoanIQ) do not have securities used as mitigants and hence do not have the issuer code associated.

Request is to consider account's customer where issuer code is not available
 

below logic can be implemented in 009 Fund Lend T2Ts
Std Mitigant type - Field
Cust - DIM_ORG_STRUCTURE.N_PARTY_SKEY
GUAR - FCT_MITIGANTS.N_GUARANTOR_SKEY
Others - coalesce(FCT_MITIGANTS.N_ISSUER_SKEY, skey of
DIM_INSTRUMENT_CONTRACT.V_ISSUER_CODE, DIM_PARTY.N_PARTY_SKEY)

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.