Duplicate Rows Inserted into DQ_RESULT_SUMM_MASTER for Data Quality Rule Results (Doc ID 1590563.1)

Last updated on JUNE 13, 2017

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.3.1 to 7.3.2.3.0 [Release 7]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Services Analytical Applications (OFSAA) 7.3, when you run a Data Quality (DQ) Group that contains multiple Data Quality rules, duplicate rows are output to DQ_RESULT_SUMM_MASTER for a Data Quality Rule.  The issue only appears to occur when a DQ Group has multiple DQ Rules and the rules use the same "Check Type".  You expect to see only one row output to DQ_RESULT_SUMM_MASTER per Data Quality Rule.

Steps to Reproduce:

  1. Go to Unified Metadata Manager
  2. Go to Data Integrator Framework
  3. Go to Data Quality Framework > Data Quality Rules
  4. Create more than one Data Quality rule that does a Referential Check
  5. Go to Data Quality Groups, create a group, and add the rules to the group
  6. Execute the Data Quality Group

Duplicate rows are output to DQ_RESULT_SUMM_MASTER for a Data Quality Rule.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms