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

Last updated on JANUARY 28, 2022

Applies to:

Symptoms

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
   THEN
   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.

Cause

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