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.
Version: RRS 80961, FSDF 80930
Report/Schedule: FFIEC009/ C-Part II
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
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