My Oracle Support Banner

Incorrect Join Conditions In DEFD1536- FRY9C, FFIEC031, FFIEC041 (Doc ID 2757475.1)

Last updated on MARCH 09, 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

Version: RRS 80970
Report/Schedule: HC-B/RC-B
Lines/MDRM: M3, 1778

Issue:

In DEFD1536
--HREG1102 (HIR - RR Source Holding Type) COALESCE(A_DIM_SRC_HOLDING_TYPE.V_HOLDING_TYPE, 'MSG') is joining on BPRG3011 which is not holding type but FRAS.N_AMORTIZED_COST_RCY

LEFT OUTER JOIN DIM_HOLDING_TYPE A_DIM_SRC_HOLDING_TYPE ON DERG0301.BPRG3011 = A_DIM_SRC_HOLDING_TYPE.N_HOLDING_TYPE_CD

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.