Column Standardization for Data Sanity Table [DATA_SANITY_CHECK_RESULTS]. (Doc ID 2920512.1)

Last updated on JANUARY 12, 2023

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------
Data Sanity table [DATA_SANITY_CHECK_RESULTS] column standardization.

The columns in DATA_SANITY_CHECK_RESULTS table are not standardized, for some type of dsr_check_name_cd column1 contain acc_nbr and for the other dsr_check_name_cd - the ac_nbr is stored on column2 or column 3.

Where possible, standardize the column usage – column 1 should be the account number; column 2 should be aad_id; etc.

EXPECTED BEHAVIOR
-----------------------
System should have the column standardization for the data sanity tables.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Not Mentioned.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot have the DATA_SANITY tables with column standardization.

Cause

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