DQPROD0003 - STG_PRODUCT_MASTER.V_BALANCE_SHEET_CATEGORY (Doc ID 2874665.1)

Last updated on JUNE 07, 2022

Applies to:

Symptoms

 DQPROD0003 found under Data Management Framework > Data Quality Framework > Data Quality Rules under table STAGE PRODUCT MASTER.

After giving below query in atomic schema
SELECT * FROM DQ_CHECK_MASTER WHERE v_dq_check_id = 'DQPROD0003';

Below is the partial output for column V_DETL_SQL

"case when STG_PRODUCT_MASTER.V_BALANCE_SHEET_CATEGORY NOT IN ('ON','OFF') and (1=1) and

length(trim(STG_PRODUCT_MASTER.V_BALANCE_SHEET_CATEGORY)) is not null then 1 else 0 end lov_Case

 There is only ON/OFF for LOV values. But for DIM_BALANCE_SHEET_CATEGORY there are some more LOV values. So this particular DQ should be referenced to DIM_BALANCE_SHEET_CATEGORY.

Cause

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