My Oracle Support Banner

DQ Generic Type Output Results Does Not Populate Column V_DQ_SEVERITY in the DQ Result Tables (Doc ID 1681425.1)

Last updated on FEBRUARY 27, 2019

Applies to:

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


Data Quality (DQ) generic type rules output does not populate the column v_dq_severity in the DQ result tables. For specific check type it is working as expected.

The V_DQ_SEVERITY column should be updated with respective severity in results tables (dq_result_summ_master,dq_result_detl_master).

Steps to reproduce:

1. Login to OFSAA Infrastructure with a valid user credentials and navigate to Data Quality Framework Summary screen UMM-> Data Integrator
    Framework->Data Quality Framework->Data Quality Summary.
2. Define a Generic Check rule with severity as Information. Also, define some valid assignments.
3. Approve and execute the rule.
4. Verify value in V_DQ_SEVERITY column in dq_result_summ_master and dq_result_detl_master tables.




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

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