My Oracle Support Banner

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.

Symptoms

Y9LP Schedule PC-A MDRMs:
BHCP0533
2.b. Nonequity investments in and receivables due from bank subsidiaries and associated banks:
(1) Loans, advances, notes, bonds, and debentures.
BHCP0537
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

 

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.