SQL Query to extract username along with roles, data access and security Context in oracle fusion .

Summary:

I need the table to get security context column values in oracle fusion tables. Currently I am using the table FUN_USER_ROLE_DATA_ASGNMNTS but in this table inside the column ' DATASEC_CONTEXT_TYPE_CODE' do not have the security context values.

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

R13

Code Snippet (add any code snippets that support your topic, if applicable): currently I am using the below code.

SELECT
pu.username
, ROLE.role_name
,'DATA_ACCESS_SET' AS DATASEC_CONTEXT_TYPE_CODE
, gl.name
FROM
fusion.fun_user_role_data_asgnmnts ROLE