Problem Queue Link To Alerts (Doc ID 2923475.1)

Last updated on JANUARY 31, 2023

Applies to:

Symptoms

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

Changes

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 = ?

Cause

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