8124 | KYC H$APPLN_RISK_RATING_PARAMS Has Fewer Columns And Smaller Size Than Expected (Doc ID 2975194.1)

Last updated on SEPTEMBER 25, 2023

Applies to:

Symptoms

Issue #1: In OFS BD 8124, the table H$APPLN_RISK_RATING_PARAMS has the column V_RISK_PARAM_CODE with size of VARCHAR2(20 CHAR) but in the APPLN_RISK_RATING_PARAMS the column V_RISK_PARAM_CODE has size of VARCHAR2(40 CHAR).
This cause the audit process to fail when it tries to log the action for a parameter with more than 20 chars. The column should have the same size and it should be size on APPLN_RISK_RATING_PARAMS.

Issue#2: Additionally the V_CODE_SET is missing on the H$APPLN_RISK_RATING_PARAMS as this column is part of the configuration shouldn’t be also audited?

Issue#3: The same issue is also present on the tables param_risk_score_jrsdn and h$param_risk_score_jrsdn.
Table: param_risk_score_jrsdn
-> V_PARAM_RULE_CODE VARCHAR2(40 CHAR)
Table: h$param_risk_score_jrsdn
-> V_PARAM_RULE_CODE VARCHAR2(20 CHAR)

Cause

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