FRY9LP : Reg Product Classifications - ADNONBANASSO, ADBANASSSUB Corrections (RRS 80911) (Doc ID 2730237.1)

Last updated on NOVEMBER 24, 2020

Applies to:

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

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