My Oracle Support Banner

RC-O: Uninvested Trust Funds In Line 1 (Doc ID 2809872.1)

Last updated on OCTOBER 03, 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.


RC-O line 1 (RCFDF236): Total deposit liabilities before exclusions: it mentions to include 'Uninvested trust funds held in the institution’s own trust department'

Uninvested trust funds is being done through FCT_REG_ACCOUNT_SUMMARY.N_STD_SEC_LOB_SKEY

DIM_STD_SECONDARY_LOB.V_STD_SEC_LOB_CODE = BL62 (Corporate Trust & Agency)

Currently using RLUS_FRAS_REG_STD_SEC_LOB_MAP-->BPRMP013-->DSRMP013.
Per DSRMP013, LEFT OUTER JOIN dim_org_unit ON dim_org_unit.n_org_unit_skey = fct_common_account_summary.n_org_unit_skey
  LEFT OUTER JOIN dim_lob ON dim_lob.n_lob_skey = fct_common_account_summary.n_lob_skey

As per Jan 2020 SVF file, v_lob_code and V_ORG_UNIT_CODE from none of the PP tables have been mapped for RC-O. 


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

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