FRY9LP : Reg Product Classifications - ADNONBANASSO, ADBANASSSUB Corrections (RRS 80911)
(Doc ID 2730237.1)
Last updated on NOVEMBER 24, 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.
Y9LP Schedule PC-A MDRMs:
2.b. Nonequity investments in and receivables due from bank subsidiaries and associated banks:
(1) Loans, advances, notes, bonds, and debentures.
2.d. Nonequity investments in and receivables due from nonbank subsidiaries and associated nonbank companies:
(1) Loans, advances, notes, bonds, and debentures
In USFED 80911, The associated reg product classifications ADNONBANASSO, ADBANASSSUB classified using the rule :
RLUS_FRAS_REG_PROD_CLASS_28 - Reg US Reg Acc Summ Reg Product Class 28 - Advance Due from Subsidiaries - still have
1> entity type join with old entity type values (BANFORSUB,COMBANK,ASSHC,BHC etc)
2> member bank id join
LEFT OUTER JOIN dim_entity_type ON fct_reg_account_summary.n_intrnl_cust_entity_type_skey = dim_entity_type.n_entity_type_skey
LEFT OUTER JOIN dim_boolean_flags a_dim_boolean_mem_bnk_id ON dim_org_structure.f_member_bank_id = a_dim_boolean_mem_bnk_id.v_flag_code
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