My Oracle Support Banner

Usage Of Dim_indicator_values In RRS 8097 DE. (Doc ID 2824598.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 later
Information in this document applies to any platform.

Goal

The RRS DE use the DIM_INDICATOR_VALUES in some of the DE is not consistent and there are duplicate rows in the table fir indicator_values 28,29,30

select V_INDICATOR_VALUE_CODE, N_INDICATOR_TYPE, count(*) from eone.DIM_INDICATOR_VALUES group by V_INDICATOR_VALUE_CODE, N_INDICATOR_TYPE having count(*) > 1

Supposed to work with duplicates for DE's using the datasets : DSFD1539, DSFDR574?
 

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


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