My Oracle Support Banner

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

Last updated on JANUARY 13, 2021

Applies to:

Oracle Financial Services Know Your Customer - Version 8.0.0 and later
Information in this document applies to any platform.

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

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
Symptoms
Cause
Solution


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