Provision Impersonate User for Connection to Oracle Fusion Cloud Applications Suite

You can provision the impersonate user functionality in Oracle Fusion Cloud Applications Suite when your connection target is an application in Oracle Fusion Cloud Applications Suite with Oracle Transactional Business Intelligence.

1. Log in to Oracle Fusion Applications as an administrator with privileges to create or modify a role.
2. Display the Security Console dialog, and display the Users tab.
3. Click Add User Account to create a user. For example, create a user called DV Admin.
4. Display the Roles tab, and click Create Role.
5. Enter a role name in the Role Name field. For example, enter DV Access.
6. Enter a code for the role name in the Role Code field. For example, enter DV_ACCESS.
7. Select BI - Abstract Roles in the Role Category field.
8. Skip the steps Function Security Policies and Data Security Policies.
9. In the Role Hierarchy step, click (+) Add Role and select the existing BIImpersonator role in the Add Role Membership dialog.
10. Select the user that you created (for example, DV Admin).
11. Click Add User to Role in the Add User dialog.
12. Click Save and Close.

    The DV Admin user is added to the BI Impersonator role, and you can use the DV Admin user in Oracle Analytics in conjunction with the Use Active User's Credentials option in the Create Oracle Application Connection dialog.

    You can now test the impersonate functionality.