My Oracle Support Banner

Credit Management Worflow in Error if Scoring Component is Assigned to a Checklist (Doc ID 2604741.1)

Last updated on SEPTEMBER 21, 2021

Applies to:

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


Credit Management Workflow is in error if scoring component is assigned to Checklist.   Recently you may have upgraded from 12.2.4 to 12.2.8. 

Upon analyzing the issue we could see that package AR_CMGT_SCORING_ENGINE has different version for upgrade and is returning multiple rows in a select into.

old version:
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;

new version:
  SELECT dp.data_point_category, dp.function_name
  INTO l_category, l_function_name
  FROM ar_cmgt_scorable_data_points_v dp, ar_cmgt_score_dtls dtl
  where dp.data_point_id = p_data_point_id
  and dp.data_point_id = dtl.data_point_id
  and dtl.score_model_id = p_score_model_id
  and nvl(dp.descriptive_flex_context_code, 'X') = nvl(dtl.flex_context_code, 'X');


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.