Unable to see direct SQL option under subject area in fusion BI

Issue:

Unable to see fusion Direct SQL option under subject area in fusion BI after upgrade R11 to R12

Solution:

1. Login to Fusion Application and choose the "Security Console" option

2. Under the Roles Tab, click on Create Role button and fill out the form as seen in the screen shot

3. Click next till you get to the "Role Hierarchy" and then click on the Plus sign (+) to add the seeded BI Administrator Role

4. Search for the BI Administrator Role and then click on "Add Role Membership"

5. Click Next and then Submit the request

6. To assign the newly created "Custom BI Administrator Role" to a user, you need to query up the Role and click "Edit Role"

7. Click Next or jump to "Users" and then click on "Add User"

8. Search for the user and then click on "Add User to Role" button

9. Then click on Next and then "Save and Close"

10. Now run the "Retrieve Latest LDAP Changes" ESS Job.


The user should now have the BI Administrator Role. Please allow up to 20 minutes for the change to take effect.