DQ Generic Type Output Results Does Not Populate Column V_DQ_SEVERITY in the DQ Result Tables

(Doc ID 1681425.1)

Last updated on OCTOBER 04, 2016

Applies to:

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


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.


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