Unable To View CTR's When User Has Multiple Roles
(Doc ID 2860918.1)
Last updated on NOVEMBER 28, 2022
Applies to:
Currency Transaction Reporting - Version 8.0.0 and laterInformation in this document applies to any platform.
Symptoms
On : 8.0.7 version, Installation
ACTUAL BEHAVIOR
---------------
Unable to view CTR's when user has multiple roles
When a user is mapped to multiple user groups/roles they are unable to view CTR's on the Search page.
This is caused by a failure of this query in the UMM log file:
[17-03-22 16:34:42,018 GMT PM] [DEBUG] [WEB] [UMM] [08101752_TEST] [CTRTASKDAO] Calling the Query For User Role ::select listagg(csmr.v_role_code, ',') within group( order by csmr.v_role_code desc), listagg('''' || csmr.v_role_code || '''', ',') within group( order by csmr.v_role_code desc) from cssms_group_role_map csmr where csmr.v_group_code in (select cugm.v_group_code from cssms_usr_group_map cugm where cugm.v_usr_id = '08101752_TEST')
[17-03-22 16:34:42,020 GMT PM] [DEBUG] [WEB] [UMM] [08101752_TEST] [CTRTASKDAO] Error in Fetching User RoleORA-01489: result of string concatenation is too long
The listagg() function is restricted to 4000 characters. When a user has multiple roles, the results of the query above go over 4000 quickly.
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 |
| Cause |
| Solution |
| References |