My Oracle Support Banner

FSI_PARTY_STD_PARTY_MAP TABLE USE IN JOINS WITH SCD TABLES DIM_ISSUER, DIM_PARTY, DIM_CUSTOMER IN DIFFERENT DERIVED ENTITIES (Doc ID 2490220.1)

Last updated on NOVEMBER 06, 2019

Applies to:

Oracle Financial Services - Regulatory Reporting for US Federal Reserve - Lombard Risk Integration Pack - Version 8.0.6 and later
Information in this document applies to any platform.

Goal

FSI_PARTY_STD_PARTY_MAP is used in different DEs having join with SCD table like DIM_ISSUER.
FSI_PARTY_STD_PARTY_MAP is populated by some seeded data and DIM_ISSUER is client downloadable table.

Under this kind of scenario below join may not work because of which MDRM's based on issue/agency is not yielding desired result.

OUTER JOIN FSI_PARTY_STD_PARTY_MAP A_FSI_PARTY_ISSUER ON
A_FSI_PARTY_ISSUER.V_PARTY_ID = DIM_ISSUER.V_ISSUER_CODE

Solution

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
Goal
Solution

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