My Oracle Support Banner

Unable To View CTR's When User Has Multiple Roles (Doc ID 2860918.1)

Last updated on APRIL 11, 2022

Applies to:

Currency Transaction Reporting - Version 8.0.0 and later
Information 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


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