DIM_INDICATOR_VALUES Duplicate Issues Related To DEFD1539 And Possibly Other DEs
(Doc ID 2810273.1)
Last updated on OCTOBER 04, 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.
DIM_INDICATOR_VALUES has unique records for below combination of columns:
select 'DIM_INDICATOR_VALUES' table_name, count dup_count from eone.DIM_INDICATOR_VALUES group by 'DIM_INDICATOR_VALUES',to_char(V_INDICATOR_VALUE_CODE), to_char(N_INDICATOR_TYPE), to_char(n_indicator_numeric_code) having count > 1;
However there are some DEs like DEFD1539, that join to this DIM solely filter on n_indicator_type . And duplicates when excluding n_indicator_numeric_code from above query.
The DEFD1539 would be impacted as its dataset is using dim_indicator_values as below:
LEFT OUTER JOIN DIM_INDICATOR_VALUES A_DIM_RETAIL_WHOLESALE_INDI ON A_DIM_RETAIL_WHOLESALE_INDI.V_INDICATOR_VALUE_CODE = DIM_PRODUCT.F_RETAIL_WHOLESALE_IND AND A_DIM_RETAIL_WHOLESALE_INDI.N_INDICATOR_TYPE = 28
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