My Oracle Support Banner

AML 811 :Alerts Are Not Getting Generated for multi-match task,Error Msg :-> ORA-01858: a non-numeric character was found where a numeric was expected (Doc ID 2858769.1)

Last updated on MARCH 31, 2022

Applies to:

Oracle Financial Services Behavior Detection Platform - Version 8.1.1 and later
Information in this document applies to any platform.

Symptoms

AML 811 Alerts Are Not Getting Generated for multi-match task.
See the following error:
03/07/2022 16:54:03 DEBUG : Thread ID = 140154322106112: mantas: File = TableActivity.cc: Line = 209: INSERT INTO ofsaafccm.KDD_ACTIVITY (ACTVY_ID, REVIEW_ID, START_DT, NEW_REVIEW_STATUS_CD, NEW_REVIEW_OWNER_ID, ACTVY_TYPE_CD, CREAT_ID) VALUES (:ACTVY_ID, :REVIEW_ID, :START_DT, :NW_REVIEW_STATUS_CD, :NW_REVIEW_OWNER_ID, :ACTVY_TYPE_CD, :CREAT_ID)
Error Msg :-> ORA-01858: a non-numeric character was found where a numeric was expected

Error Msg :-> ORA-01858: a non-numeric character was found where a numeric was expected

Error Msg :-> ORA-01858: a non-numeric character was found where a numeric was expected

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
References


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