My Oracle Support Banner

Alert not displayed in alerts summary section in TF (Doc ID 2755668.1)

Last updated on MARCH 02, 2021

Applies to:

Oracle Financial Services Transaction Filtering - Version 8.0.8 and later
Information in this document applies to any platform.

Symptoms

Swift messages posted and alerts are created but not displayed in alert summary section in TF UI

Steps to reproduce:

Step 1 : Post the swift message through sanctionspost.jsp

Step 2 : Check in below tables with group message id for the alerts.

SELECT * FROM FSI_RT_ALERTS A ORDER BY A.N_ALERT_ID DESC;

Step 3 : Login as TFAnalyst and check for the posted alert in summary section in TF.

Expected behavior:

Alerts must be displayed in alert summary section without issue.

Actual behavior:

Alerts are not displayed but observed below error in RTISERVER logs.

Issue encountered :

[19-02-21 20:11:08,307 GMT PM] [ERROR] [WEB] [0A2VPN158] [NA] [ SANCTIONS ]Exception occurred while executing QueryList
ORA-00920: invalid relational operator

Changes

Roles are configured recently for users

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
Changes
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.