Oracle Business intelligence roles apply to both Oracle Business Intelligence publisher and Oracle Fusion Transactional Business Intelligence (OTBI). They grant access to business intelligence functionality such as ability to run or authors reports.

Role Name	Description
BI Consumer Role	Runs Business Intelligence reports.
BI Author Role	Creates and edits reports.
BI Administrator Role	Performs administrative tasks such as creating and editing dashboards and modifying security permissions for reports, folders, and so on. It is super user role.it inherits BI Author role which inherits BI consumer role. You are recommended to provision this role to users in test env only. None of the predefined HCM job roles have BI Administrator Role access.
BI Publisher Data Model Developer Role	Creates and edits Business Intelligence Publisher data models. BI Publisher Data Model Developer Role is inherited by the Application Developer role, which is inherited by the Application Implementation Consultant role. Therefore, users with either of these predefined job roles can manage Business Intelligence Publisher data models.

We cannot assign all these roles to the user directly.

To assign these roles to the user, we need to create custom role and need to refer these roles to assign to user.

Let us create custom BI role.

Navigate to Tools—>Security Console—->Roles—> Create.

Click on Next.

Click on Next.

Click on next.

Click on Add Role Membership.

Click on Next.

Click on next.

Click on Next.

Click on Save and Close.

Before adding role:

Now assign custom role to user.

Click on Add Role Membership.

Click on Save and Close.

Submit below two ESS job:

Import User and Role Application Security Data

Now login to application with this user and navigate to reports and analytics.

Here we can see all the access for BI admin activity.