Integrating with Oracle Fusion

Overview

Drivetrain’s Oracle Fusion connector is able to integrate with the FSCM, HCM, CRM, and ATS applications to extract data and bring them into Drivetrain.

Prerequisites

To integrate Oracle Fusion Cloud Applications with Drivetrain, you need:

• An Oracle Cloud account

• An active Oracle Fusion Cloud subscription

• Access to the Oracle Application Console

• Security Manager role to create users & roles

• Admin Access to Drivetrain with permission to add data sources

Setup Instructions

Step 1: Find Your Oracle Fusion Server URL

1. Log in to Oracle Cloud.

2. Navigate to the Application Console.

3. Locate your Oracle Fusion application instance.

4. If you don’t have one, follow Oracle’s process to create it.

You need to select the specific application that you want to integrate with Drivetrain.

4. In the Overview tab of the application, find the Service Environment URL. For example: https://servername.fa.us2.oraclecloud.com

Make a note of this URL. You will need it to configure Drivetrain.

Step 2: Create a User (Basic Authentication)

Drivetrain uses a dedicated Oracle user with Basic Authentication credentials.

1. Log in to the Oracle Fusion Cloud Application instance for which you want to sync the data.

2. On the left hand navigation page, go to Tools → Security Console.

1. Navigate to Users → Add User Account.

1. On the Add User Account page, enter the User details.

   1. Username (e.g., DRIVETRAIN_SYNC_USER)

   2. Password

   3. Email: Shared by your Drivetrain implementation team

1. Click Save and Close.

Make a note of the Username & Password. These will be required in Drivetrain and in later steps.

Step 3: Create BICC and UCM Roles

1. Log in to the Oracle Fusion Cloud Application instance for which you want to sync the data.

2. On the left hand navigation page, go to Tools → Security Console.

3. Navigate to Roles → Create Role.

You must have the Security Manager role to create a role.

3.1 Basic Information

Fill out the following information:

Field	Value
Role Name	e.g., BICC_DRIVETRAIN_ROLE, UCM_DRIVETRAIN_ROLE
Role Code	e.g., BICC_ADMIN_DRIVETRAIN, UCM_ADMIN_DRIVETRAIN
Role Category	BI – Abstract Role
Predefined Role	Uncheck

Click Next through Function Security Policies → Data Security Policies.

3.2 Add Required Role Memberships

On the Role Hierarchy page → click Add Role → search and add:

• ESS Administrator (Allows scheduled global extract jobs)

• BIA_ADMINISTRATOR_DUTY (Allows datastore description, job listing, BICC operations)

• OBIA_EXTRACTTRANSFORMLOAD_RWD (Allows viewing and downloading extracted UCM files)

• Click Add Role Membership → Close.

• Continue Next through Segregation of Duties.

3.3 Assign the user

On the Users page:

1. Click Add User.

2. Select the Basic Auth user created in Step 2.

3. Click Next → Save and Close.

Step 4: Configure UCM Storage for BICC

1. Log into BI Applications Configuration Manager (BIACM) using your server URL you found in Step 1. For example, if the server URL is https://my-oracle-fusion-cloud.oraclecloud.com, use https://my-oracle-fusion-cloud.oraclecloud.com/biacm.

2. Log in using the Username and Password from Step 2.

3. Click Configure External Storage.

1. Go to the UCM Connection tab → click Test UCM Connection.

2. You should see: External Storage Connection Succeeded.

3. Click OK.

Step 5: Select Columns for Extraction

1. Log into BI Applications Configuration Manager (BIACM) using your server URL you found in Step 1. For example, if the server URL is https://my-oracle-fusion-cloud.oraclecloud.com, use https://my-oracle-fusion-cloud.oraclecloud.com/biacm.

2. Click Manage Offerings and Data Stores.

1. Open the offering that contains your objects.

2. Select the relevant datastore.

3. Go to Edit Columns tab.

4. Select the checkbox under Select List for every column to sync.

5. Click Save.

Drivetrain can only sync columns that have the Select List box checked.

Step 6: Select Primary Keys for Custom Objects (Optional)

To configure:

1. Open the Data Store Columns selection page.

2. Check the Primary Key column(s).

3. Click Save.

Tables without at least one primary key are excluded from sync.

Step 7: Add Custom Objects to an Offering (Optional)

If a table is not part of an offering, it will not sync.

To add a custom datastore to an offering: → Follow Oracle’s documentation for adding custom objects to offerings.

Step 8: Configure Incremental Filters (Optional)

1. Open the Data Store Columns selection view.

2. Locate the TIMESTAMP column you want to use for incremental sync.

3. Check:

   1. Incremental Filter

   2. Select List

4. Ensure the column is TIMESTAMP type.

5. Click Save.

Step 9: Provide Credentials to Drivetrain

Share the following with your Drivetrain team via a secure document:

• Server URL

• Username

• Password

Your Drivetrain team will complete connector activation and validate access.

Still stuck? We can help.

If you need assistance validating your Oracle configuration or enabling advanced BICC objects, your Drivetrain Solutions team can help review your setup via a secure screen-share.

Frequently Asked Questions

Do we need JWT or certificate authentication?

No, Drivetrain uses Basic Authentication for this connector. If you would like to use JWT method for authentication, please reach out to your Drivetrain implementation team.

What happens to tables without primary keys?

Oracle excludes them; Drivetrain will not receive those tables.

Can custom objects be synced?

Yes, as long as they are:

• Added to an offering

• Have selected columns

• Have primary keys defined