My Oracle Support Banner

Final Score Missing for Additional Data Points Using PL/SQL Procedure (Doc ID 2559289.1)

Last updated on JANUARY 28, 2022

Applies to:

Oracle Credit Management - Version 12.2.6 and later
Information in this document applies to any platform.


In Credit Management, 12.2.6

After the patch 28818768:R12.OCM.C, Final Score is missing from the Case Folder for additional data points using
functions and procedures.

When refreshing the case folder the score values are missing for the
additional data points that have functions and procedures to calculate the score.

"AR_CMGT_SCORING_ENGINE.GET_TOTAL_SCORE package" has a  wrong condition which
needs to be commented on.

/* 9342120 - Added function_name to view */
       SELECT v.data_point_category, v.function_name
INTO l_category, l_function_name
FROM ar_cmgt_scorable_data_points_v v
where v.data_point_id = p_data_point_id;

(IF l_category='ADDITIONAL' AND l_function_name IS NOT NULL
   l_updt_flg :='N';
   END IF;) need to comment this condtion. this condition is failing if the
additional data points has function and procedure.

If the additional data points do not have functions or procedures, the condition is going to pass.


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
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps

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