HC-S/RC-S : Issues On Lineage And Join
(Doc ID 2824764.1)
Last updated on DECEMBER 05, 2021
Applies to:
Oracle Financial Services - Regulatory Reporting for US Federal Reserve - Lombard Risk Integration Pack - Version 8.0.9 and laterInformation in this document applies to any platform.
Goal
Related SR# 3-24611530261
#1 ERL-6865 SBT - Missing Principal balance field in lineage for STG_CREDIT_PARTCPN_DETAILS
STG_CREDIT_PARTCPN_DETAILS.N_EOP_CURR_PRIN_BAL in present in RRS 8.1.1.1 lineage for other MDRMs in HC-S and RC-S. but missing for 2 MDRMs ('BHCKA591','RCFDA591')
#2 ERL-6870 - SBT - Clarification for Mapping of Sec pool ID to Single Tranche ID
MDRM BHCKHU16:N_AMORTIZED_COST_RCY is doubling up when data flows through the Derived Entity DEFD1900. This is happening when sec_pool_id has multiple tranches in Stg_securitization_tranche.
Referring to a code within DSFD1900:
LEFT OUTER JOIN DERG1501 ON FCT_REG_ACCOUNT_SUMMARY.N_SEC_POOL_SKEY = DERG1501.PK_HREG0022 AND FCT_REG_ACCOUNT_SUMMARY.N_MIS_DATE_SKEY = DERG1501.PK_HIREG001 AND FCT_REG_ACCOUNT_SUMMARY.N_RUN_SKEY = DERG1501.PK_HIREG002
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 |
| References |