My Oracle Support Banner

Alert Assignment Post Processing Job Issue (Doc ID 2454926.1)

Last updated on NOVEMBER 10, 2019

Applies to:

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

Symptoms

On : 8.0.2 version, Database

Issue in alert assignment after applying patch for watch list management.

Alert assignment job which is part of Post processing fails with an error;

Message 10019: Unexpected Exception: com.ofss.bdf.common.RethrownException: ORA-00904: "USER_ROLE_CD": invalid identifier

It is observed that the query is trying to pick column, USER_ROLE_CD from the table, ofsaafccm_us.kdd_focus_alert_asgmt whereas the column itself is not available in the respective table.

ERROR
-----------------------
ORA-00904

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot Run Alert Assignment

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.