My Oracle Support Banner

Problem Queue Link To Alerts (Doc ID 2923475.1)

Last updated on JANUARY 31, 2023

Applies to:

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


Steps to Reproduce:

Step1: Access TF application

Step2: Open the queue and check the counter and check the option if view all alerts is available or not

Step3: Click on view all alerts and verify the count of alerts inside

Actual behavior:

View all alerts option is not shown on Queue page under each queue

Expected behavior:

View all alerts option should be available on queue


Need to check the output of below queries to understand if there are any alerts which are unassigned or assigned to logged in user.

select * from fcc_queue --> Queue_id
select * from fcc_queue_alert_map_tf where active_fl = 'Y' --> No.of alerts
select * from fsi_rt_alerts where n_alert_id in (select entity_id from fcc_queue_alert_map_tf where active_fl = 'Y')

select distinct V_FUNCTION_CODE from cssms_usr_group_map t inner join cssms_group_role_map k on t.v_group_code = k.v_group_code inner join cssms_role_function_map b on k.v_role_code = b.v_role_code where t.v_usr_id = ?


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

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