Oracle Communities

Oracle Analytics and AI

Child Item

An user cannot view data with the role: FAW Licensed ERP Consumers Role

SERGIO BARRETO

Hello,

I have user #1 to which I have assigned the license role: FAW Licensed ERP Consumers Role

I have user #2 which has the license role: FAW Service Administrator Role

Now, the AR report: AR Transactions Activity Analysis, user #1 does not have any data:

But user #2 does have data:

It should be noted that the security we have implemented is the standard one. For example, user #1 has the role of fusion: Accounts Receivable Manager where he has related the two business units for data access:

What is required for user#1 to be able to see data in the reports?

Find more posts tagged with

ERP Analytics Content

Fusion ERP Analytics

Accepted answers

Mallikarjuna Kuppauru-Oracle

Hi @SERGIO BARRETO

As per your test case, user 1 having only consumer role and some set of fusion duty/data roles. For user 2 is an Admin role means no security filter will be applied on top of the data while running the report.

user 1 —> security filters are not satisfying while retrieving the data. Make sure, you can refer below for roles which are predefined at Subject Area level to get the data.

https://docs.oracle.com/en/cloud/saas/analytics/24r3/faiae/subject-areas-chapter.html#GUID-1F567325-1C9F-458A-98E4-4DFBCCF1C946

Regards,

Arjun

All comments

Mallikarjuna Kuppauru-Oracle

Hi @SERGIO BARRETO

user 1 —> security filters are not satisfying while retrieving the data. Make sure, you can refer below for roles which are predefined at Subject Area level to get the data.

https://docs.oracle.com/en/cloud/saas/analytics/24r3/faiae/subject-areas-chapter.html#GUID-1F567325-1C9F-458A-98E4-4DFBCCF1C946

Regards,

Arjun

SERGIO BARRETO

@Mallikarjuna Kuppauru-Oracle Hi,

The user has the role that allows access to the subject areas of AR according to the document you send me. I send you evidence.

I see everything ok in the user? will it be necessary to open a SR?

Mallikarjuna Kuppauru-Oracle

Hi @SERGIO BARRETO

You can take the session log of the user 1 and see what type of security filters has been applied .Run the same on DB and see are you able to find else you can open an SR if you need further help?

Regards,

Arjun

SERGIO BARRETO

Hi @Mallikarjuna Kuppauru-Oracle

Is there a process that refreshes the data? Because now if information appears with the user #1. When no information appeared I had just set the role: FAW Licensed ERP Consumers Role.