Create the Business Intelligence User and Role

The AIAPPS_BIP_ROLE role is required in Oracle Business Intelligence (BI) to extract values from Oracle Financials Cloud and train the AI Apps machine-learning models.

Important: It's best practice to create a dedicated user, however, you may prefer to create and add this role to an existing user. To avoid any disruption of the services, ensure that this user is excluded from password reset policies.

1. Connect to the Oracle Financials Cloud as a user with the IT Security Manager role.

2. In the Navigator menu, under Tools, click Security Console. You may need to click More to expose the Tools options.

3. Create the AIAPPS_BIP_ROLE:

   1. On the Roles page, click Create Role.

   2. Enter these values:

      Field	Value
      Role Name	AIAPPS_BIP_ROLE
      Role Code	AIAPPS_BIP_ROLE
      Role Category	BI - Abstract Roles

   3. Click Next three times.

   4. On the Role Hierarchy stop, click Add Role.

   5. In the Add Role Membership window, search for and select BIAuthor, then click Add Role Membership.

   6. Search for and select BIPDataModelDeveloper, then click Add Role Membership.

   7. Click Cancel to close the window.

   8. Click Next two times.

   9. Click Save and Close, and then click OK.

4. Create a user account named AIAPPS_BIP with the AIAPPS_BIP_ROLE role:

   1. Click Users.

   2. On the User Accounts page, click Add User Account.

   3. In the User Information section, enter values for all of the required fields.

   4. Rename the User Name value to AIAPPS_BIP.

   5. Click Add Role.

   6. In the Add Role Membership window, search for and select AIAPPS_BIP_ROLE, then click Add Role Membership.

   7. Click Done to close the window.

   8. Click Save and Close.

5. Schedule a process to import the user and role security data as follows:

   1. From the Navigator menu, in the Tools section, select Scheduled Processes.

      You may need to click More to expose the Tools options.

   2. Click Schedule New Process and select the values shown here:

      Field	Value
      Type	Job
      Name	Import User and Role Application Security Data

   3. Click OK.

   4. In the Process Details window, click Submit.

   5. Make a note of the process ID, and then click OK.

   6. Click Refresh until the status of the process ID you noted shows as succeeded.