KYC RAOR Onboarding Risk Assessments Not Being Created (Doc ID 2742711.1)

Last updated on MAY 10, 2023

Applies to:

Symptoms

In KYC 8.0.7, Sending POST request to RAOR service using below URLs:
http://<HOST>:<PORT>/InitiateOnboardingService/OB/Initiate (this gives us the RequestID)
http://<HOST>:<PORT>/RAOR/service/json/score(this gives us the score using the RequestID)

Giving correct score values from the above URL but facing following issues.

1. Model Based highlights shows as "null", even though the highlights are tagged to evaluation in IPE.

2. No assessment were created in FCC_OB_RA table. 

3. KYC workflow was not completed. 

In UMMservice.log:
DEBUG] 2020-12-17 10:21:57.316 [pool-7-thread-3] DBAssessmentOutputRecorder$HelperDAO - Insert SQL: insert into RTI_ASSMNT_RESULT (N_ASSMNT_RESULT_ID, N_ASSMT_ID, N_ASSMNT_VERSION, N_ASSMNT_SCORE, N_ENTITY_SEQ_ID, D_ASSMNT_EXEC_TM, V_ERROR_CODE, V_ERROR_MSG, N_ACTIVITY_BUS_ID, V_ASSMNT_EXEC_MODE, V_ASSMNT_EXEC_RESULT, N_ALERT_ID, V_INFODOM , V_APP_ID) values (SEQ_ASSESSMENT_RESULT.nextval, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,?)
Id column: N_ASSMNT_RESULT_ID
Values: [20469, 0, 0.0, 1020, 2020-12-17 11:32:51.0, null, null, 19789, LIVE, FAIL, null, ECMINFO, OFS_KYC]
[ERROR] 2020-12-17 10:21:57.319 [pool-7-thread-3] DBAssessmentOutputRecorder - Failed to store assessment result in database. Assessment output: Assessment Results - Entity :
Transformed Source Entity - type: FCC_OB_REQUEST
Business Entity type: Entity Bus Id=19789 : domain=OB : infodom=ECMINFO: appID=OFS_KYC
Attributes:
Name: REQUEST_ID :: Physical Name: REQUEST_ID :: Value: 1020
Assessment Output : [assessment id:: 20469
score:: 0.0
result:: FAIL
evaluation results:: [Evaluation: eval id=25047 : version=0 : name=Rule Based Customer Type
evaluation score: 0.0 :: exec time: 2020-12-17 11:32:51.0], assessment id:: 21027
score:: 13.5
result:: PASS
evaluation results:: [Evaluation: eval id=21245 : version=0 : name=Country of Residence for Individual or of the UBOs- Parent Entity For Org Weighted Score
evaluation score: 13.5 :: exec time: 2020-12-17 11:32:51.0]]
Response : com.ofs.aai.inline.model.response.RTIResponseList@88c36d37
[ERROR] 2020-12-17 10:21:57.319 [pool-7-thread-3] ErrorDBLogHandler -
com.ofs.aai.inline.error.BaseRTIException: 1021 : Post Processing step failed : Failed to execute [Store Assessment Output in Database] step
at com.ofs.aai.inline.process.postexec.DBAssessmentOutputRecorder.run(DBAssessmentOutputRecorder.java:98) [realtime-processing.jar:?]
at com.ofs.aai.inline.process.postexec.DBAssessmentOutputRecorder.processAssessmentResult(DBAssessmentOutputRecorder.java:78) [realtime-processing.jar:?]
at com.ofs.aai.inline.process.postexec.SeparateThreadStepExecutor$SeparateThreadPostProcessTask.run(SeparateThreadStepExecutor.java:70) [realtime-processing.jar:?]

Cause

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