Provisioning a User for Oracle BI Cloud Connector Console Access

Use these steps to provide additional users access to the Oracle BI Cloud Connector Console (BICCC) user interface.

The service request that you created to deploy the Oracle BI Cloud Connector Console performs the setup for the identified user. See Creating Service Requests for Oracle Business Intelligence Cloud Connector Console. Complete these steps only if additional users need to access the console.

For Oracle Fusion Applications Release 10 and 11 Data Sources

To provision a user for Oracle BI Cloud Connector Console access:

  1. Using Oracle Authorization Policy Manager (APM), assign ESSAPP stripe, Application role – ESSAdmin (this is for the ability to schedule and monitor the BI connector ESS jobs) to the applicable new or existing user:

    Note:

    If you are accessing APM to complete this assignment, you must have the service administration privileges.
    1. Log into APM.

    2. Click Applications, click ESSAPP, and then select Role Catalog.

    3. Search for the application role name beginning ESS and select the ESSAdmin role (Display Name is ESS Administrator Role) in the Search Results section.

    4. Go to the External Role Mapping section and click Add to assign users to this role.

  2. Similarly, using APM, search for the application role BIA_ADMINISTRATOR_DUTY and add the external role ORA_ASM_APPLICATION_IMPLEMENTATION_ADMIN_ABSTRACT to this duty role.
    1. Log into APM.

    2. Click Applications, click OBI, and then select Role Catalog.

    3. Search for the BIA_ADMINISTRATOR_DUTY application role.

    4. Select it in the Search Results area and double-click it or click Open to display the page for the application role.

    5. In the External Role Mapping region, click Add to display the Add a Role dialog. Use this dialog to search for the external role, ORA_ASM_APPLICATION_IMPLEMENTATION_ADMIN_ABSTRACT.

    6. Click Map Roles.

  3. Using Oracle Identity Manager (OIM), assign OBI stripe, Enterprise Role – ORA_ASM_APPLICATION_IMPLEMENTATION_ADMIN_ABSTRACT (this is for the ability to access the user interface of Oracle BI Cloud Connector Console) to the applicable new or existing user:

    Note:

    Search for ORA_ASM_APPLICATION_IMPLEMENTATION_ADMIN_ABSTRACT in OIM using the Application Implementation Administrator role display name or use the Advanced Search in Roles page to search for this role.

For Oracle Fusion Applications Release 12 and 13 Data Sources

Use the Security Console in Oracle Fusion Applications to create an administrative role that inherits the Oracle BI Cloud Connector Console privileges from existing roles and assign the user to that role.

To provision a user:
  1. In Oracle Fusion Applications, navigate to the Security Console in the Navigator.

  2. In the Security console, create a BICC_ADMIN role.
    1. Click Create Role.

    2. In the Basic Information page, enter the following values and click Next.
      1. Role Name: BICC_ADMIN

      2. Role Code: BICC_ADMIN

      3. Role Category: BI — Abstract Roles

    3. Click the Add icon in the Role Hierarchy list.

    4. In the Add Role Membership dialog, search for ESS.

    5. In the search results, confirm that the ESS Administrator role is displayed and then click Add Role Membership.

    6. Search for ORA_ASM_APPLICATION_IMPLEMENTATION_ADMIN_ABSTRACT and click Add Role Membership.

    7. Search for OBIA_EXTRACTTRANSFORMLOAD_RWD and click Add Role Membership.

    8. Close the Add Role Membership dialog.

    9. Click Next.

    10. In the Users page, click Add User.

    11. In the Add User dialog, search for the name of the user you want to assign access to, and then click Add User to Role.

    12. Close the Add User dialog.

    13. Click Next.

    14. Click Save and close.