My Oracle Support Banner

REG REP USFED-Potential Incorrect Join Condition in DEFD1950 For Agreement Sponsor Code (Doc ID 2720047.1)

Last updated on JUNE 23, 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.

Symptoms

REG REP USFED 80960

Hierarchy applicable for agreement sponsor party HREG2804='FDIC' and DE DEFD1950 data set having below logic

Hierarchy logic,
coalesce(a_fsi_agrmt_sponsor_party_map.v_std_party_code, 'MSG') AS hreg2804

Join condition,
LEFT OUTER JOIN FSI_PARTY_STD_PARTY_MAP_HIST A_FSI_AGRMT_SPONSOR_PARTY_MAP
ON DIM_LOSS_SHARE_AGREEMENT.V_AGREEMENT_SPONSORER_CODE = A_FSI_AGRMT_SPONSOR_PARTY_MAP.V_PARTY_ID
AND DIM_DATES.N_DATE_SKEY = A_FSI_AGRMT_SPONSOR_PARTY_MAP.N_MIS_DATE_SKEY

 

Issue- Here the join is on V_AGREEMENT_SPONSORER_CODE and V_PARTY_ID which is having different data values, Expected join on V_STD_PARTY_CODE instead of V_PARTY_ID.



Changes

 NA

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
Changes
Cause
Solution
References


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