Configure Access to Joint Venture Operational Reporting in Oracle Transactional Business Intelligence

Perform these tasks to set up joint venture users with access to joint venture operational reporting in Oracle Transactional Business Intelligence (OTBI).

• Create a role and add the BIAuthor role to it. Then, assign the role to each user.
• Make sure that the key flexfield segments are enabled for OTBI.
• Make sure that users have been set up with ledger access.

You must be a user with the IT Security Manager role to perform these tasks.

To create a role that includes the BIAuthor role:

1. Open the Security Console, select the Roles tab, and click Create Role.

2. On Basic Information, complete the following fields:

   • Role Name.

   • Role Code.

   • Role Category. Select Financials - Job Roles.

3. Click Next until you reach the Role Hierarchy page.
4. Click Add Role and then search for "BI Author Role".
5. Select the role and add membership.
6. Click Next until you can save and close the page.
7. Click the Users tab and search for the user that you want to assign the role to.
8. Click the user link to access the user details.
9. Click Edit and then click Add Role.
10. Search for the role you added and click Add Membership, Done.

To make sure that the key flexfield segments are enabled for OTBI:

1. In FSM, search for the "Manage Chart of Accounts Structure Instances" task.

2. On Manage Chart of Accounts Structure Instances, enter GL# for General Ledger in the Key Flexfield Code field and click Search.

3. In the results, select the row for the General Ledger application and click Manage Structure Instances.

4. On Manage Key Flexfield Structure Instances, in the Structure Instance Code field, enter the code for the structure instance in which your joint ventures are managed and click Search.

5. In the results, select the row with the structure instance and click Actions, Edit.

6. On Edit Key Flexfield Structure Instance: select the row with the appropriate segment code and click Actions, Edit.

7. In the dialog box, click the BI enabled checkbox and click OK.

8. Click Save and Close, and then click Done.

To make sure that users have been set up with ledger access:

1. In FSM, search for the Manage Reference Data Set Data Access for Users task for the Enterprise Profile functional area and open it.

2. On Manage Data Access for Users, select the Users with Data Access option.

3. In the Security Context list, select Ledger.

4. Enter the user name and click Search.

   The results show the ledgers that the user has access to.

5. If the user doesn't have access to the appropriate ledger, then use the "Users without Data Access" option to set up user access to the ledger.