Oracle Fusion 

Oracle Fusion is a suite of open standards-based applications that enable organizations to deploy business applications.

Business Intelligence Cloud Connector (BICC) is used to sync data from Oracle Fusion Cloud applications to your destination. Once we connect to your Oracle instance, the BICC extract jobs are created for each object to extract data. The connectors manage the life cycle of these jobs.

During syncs, the connectors re-use and schedule the BICC jobs which write incremental data files to UCM, then extract the data files from Oracle UCM and sync the data to your destination.

• For more information about connecting to SaaS applications, see 連線到 SaaS 應用程式.

• For more information about Lite connectors, see SaaS 應用程式連接器的分類.

• Depending on your use case, you might need to install 資料移動閘道 to move data from SaaS applications. For more information, see 何時需要 資料移動閘道？.

Supported update methods

For more information, see 目標更新方法概述.

Landing tasks:

• Reload and compare

Replication tasks:

• Full load

Landing data in a data lake tasks:

• Reload

Preparing for authentication

To access your Oracle Fusion data, you need to authenticate the connection with your account credentials.

Before you start using the Oracle Fusion application, it is recommended to read the Overview of Business Intelligence Cloud Connector in the Oracle documentation.

To connect to Oracle Fusion, you need:

• An Oracle Cloud account.
• An active Oracle Cloud Fusion subscription.
• Access to the application console. For more information, see Use the Application Console in the Oracle documentation.
• The Security Manager role to access the security console.
• To follow the procedures:
  • Finding the Server URL.
  • Creating a user.
  • Creating BICC and UCM roles.
  • Configuring the UCM storage for BICC.

Supported services

The following Oracle Fusion Cloud applications are supported:

• Customer Experience
• Enterprise Resource Planning
• Supply Chain Management
• Human Capital Management

Finding the Server URL

The server URL is required to configure the UCM storage for BICC.

1. Log in to Oracle Cloud.
2. Navigate to Application Console. For more information, see Use the Application Console in the Oracle documentation.
3. Click your Oracle application instance in the Active Applications section. If you do not have an instance, see Create an instance in the Oracle documentation.
4. From the application instance details, copy and paste the Service Environment URL.

   For example, https://servername.fa.us2.oraclecloud.com.

Creating a user

Creating a user is required to get your username and password necessary for the connection.

1. Log in to the Oracle Fusion Cloud Application instance for which you want to sync the data.
2. From the left panel, click Tools > Security Console, then Users > Add User Account.
3. Navigate to the Application Console. For more information, see Use the Application Console in the Oracle documentation.
4. On the Add User Account page, enter the user details in the User information section.
5. Copy and paste your User Name and Password into a secured file.
6. Click Save and Close.

Creating BICC and UCM roles

For more information about Business Intelligence Cloud Connector (BICC), see Overview of Business Intelligence Cloud Connector in the Oracle documentation.

1. Log in to the Oracle Fusion Cloud Application instance for which you want to sync the data.
2. From the left panel, click Tools > Security Console, then Roles.
3. In the top-right corner, click Create Role > Basic information and enter the role details.

   Connection settings

   Field name	Description
   Role Name	Enter the role name. Example: BICC_QLIK_ROLE, UCM_QLIK_ROLE
   Role Code	Enter the role code. Example: BICC_ADMIN_QLIK, UCM_ADMIN_QLIK
   Role Category	Enter BI - Abstract Role.
   Predefined	Clear the checkbox.
   Description	Enter a description for the role. This field is optional.

4. Click Next.
5. Click Next to skip the Function Security Policies and Data Security Policies pages.
6. One the Role Hierarchy page, click Add Role.
7. In the Add Role Membership dialog box, search for the following roles:

   Connection settings

   Roles	Description
   ESS Administration Role	Creates and manages schedules for global data extracts or jobs.
   ORA_ASM_APPLICATION_IMPLEMENTATION_ADMIN_ABSTRACT	Gets job information, describes data store, and performs other BICC related operations.
   OBIA_EXTRACTTRANSFORMLOAD_RWD	Views and downloads extracted files from UCM.

8. Click Add Role Membership.
9. Close the dialog box and click Next.
10. Click Next to skip the Segregation of Duties page.
11. On the Users page, click Add User and enter the user created in Creating a user.
12. Click Next. You are on the Summary page.
13. Verify the details and click Save and Close.

Configuring the UCM storage for BICC

To configure the UCM storage, you need the server URL and your username and password created in the previous procedures.

1. Using the server URL, launch the BI Applications Configuration Manager.

   For example, when the server URL is https://my-oracle-fusion-cloud.oraclecloud.com, use https://my-oracle-fusion-cloud.oraclecloud.com/biacm.

2. Log in using your username and password.
3. Click Configure External Storage on the right.
4. Select the UCM Connections tab and click Test UCM Connection. The External Storage Connection Succeeded window pops up.
5. Click OK to close the window.

You are all set. You can create the connection.

Optional settings

The following procedures are optional. They let you configure more settings that are not required to connect to Oracle Fusion.

Adding custom object to an offering

Tables that are not part of an offering are excluded from the sync.

Follow Add a Datastore for an Offering in the Oracle documentation.

Selecting primary keys for custom objects

Tables with no defined primary keys are excluded from the sync.

You need the server URL and your username and password created in the previous procedures.

1. Using the server URL, launch the BI Applications Configuration Manager.

   For example, when the server URL is https://my-oracle-fusion-cloud.oraclecloud.com, use https://my-oracle-fusion-cloud.oraclecloud.com/biacm.

2. Log in using your username and password.
3. Click Manage Offerings and Data Stores on the right.
4. Navigate to the offering associated with the custom objects.
5. Select your custom data store, then the Edit Columns tab.
6. Select the checkbox of the corresponding objects in the Primary Key column.
7. Click Save.

Creating the connection

For more information, see 連線到 SaaS 應用程式.

1. Fill in the required connection properties.

2. Provide a name for the connection in Connection name.

3. Select Open connection metadata to define metadata for the connection when it has been created.

4. Click Create.