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.
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.
The issue has the following business impact:
Due to this issue, users cannot Run Alert Assignment
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