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.
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
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