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 laterInformation in this document applies to any platform.
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
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 |