# 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](https://docs.oracle.com/en/cloud/get-started/subscriptions-cloud/csgsg/create-instance.html) to create it.

<figure><img src="/files/hrexVjiqIauMEwnvM36w" alt=""><figcaption></figcaption></figure>

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`

{% hint style="info" %}
Make a note of this URL. You will need it to configure Drivetrain.
{% endhint %}

<figure><img src="/files/cVqX1T1pppsZcUksYWvZ" alt=""><figcaption></figcaption></figure>

### 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.**

<figure><img src="/files/sJUHf9iggDQpbOJY2JSY" alt=""><figcaption></figcaption></figure>

3. Navigate to **Users → Add User Account.**

<figure><img src="/files/kRmxRMWWwERSAS2IuILd" alt=""><figcaption></figcaption></figure>

4. On the **Add User Account page**, enter the **User details.**&#x20;
   1. Username (e.g., `DRIVETRAIN_SYNC_USER`)
   2. Password
   3. Email: **Shared by your Drivetrain implementation team**

<figure><img src="/files/39rRVQMZbzcP2yTg7WYo" alt=""><figcaption></figcaption></figure>

5. Click **Save and Close.**

{% hint style="warning" %}
Make a note of the **Username & Password.** These will be required in Drivetrain and in later steps.
{% endhint %}

### 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.**

<figure><img src="/files/fSXl5VMf8pxTnK1ggYn1" alt=""><figcaption></figcaption></figure>

{% hint style="warning" %}
You must have the **Security Manager role** to **create a role.**
{% endhint %}

#### 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.](#step-2-create-a-user-basic-authentication)
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.](#step-1-find-your-oracle-fusion-server-url) 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.](#step-2-create-a-user-basic-authentication)
3. Click **Configure External Storage.**

<figure><img src="/files/x6uVbpTnMgR40cgaYeZm" alt=""><figcaption></figcaption></figure>

4. Go to the **UCM Connection tab → click Test UCM Connection.**
5. You should see: **External Storage Connection Succeeded.**
6. Click **OK**.

<figure><img src="/files/Etg0eJaXoSvRNfVdRjtN" alt=""><figcaption></figcaption></figure>

### Step 5: Select Columns for Extraction

1. Log into **BI Applications Configuration Manager (BIACM)** using your server URL you found in [Step 1.](#step-1-find-your-oracle-fusion-server-url) 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.**

<figure><img src="/files/2uPpOARRuYemv6vCa5yw" alt=""><figcaption></figcaption></figure>

3. Open the offering that contains your objects.
4. Select the relevant datastore.
5. Go to **Edit Columns tab.**
6. Select the checkbox under **Select List** for every column to sync.&#x20;
7. Click **Save**.

<figure><img src="/files/fFdMeQRDJ03PKjSyRTk8" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}
Drivetrain can only sync columns that have the **Select List** box checked.
{% endhint %}

### 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**.

<figure><img src="/files/ozMtrMGqpLLbxtdlY7ov" alt=""><figcaption></figcaption></figure>

{% hint style="warning" %}
Tables without **at least one primary key** are excluded from sync.
{% endhint %}

### 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](https://docs.oracle.com/en/cloud/saas/applications-common/24b/biacc/add-a-data-store-for-an-offering.html#u00180694) 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**.

<figure><img src="/files/Qkzje2SQKE2dJkZ0c90F" alt=""><figcaption></figcaption></figure>

### 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

<details>

<summary>Do we need JWT or certificate authentication?</summary>

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.

</details>

<details>

<summary>What happens to tables without primary keys?</summary>

Oracle excludes them; Drivetrain will not receive those tables.

</details>

<details>

<summary>Can custom objects be synced?</summary>

Yes, as long as they are:

* Added to an offering
* Have selected columns
* Have primary keys defined

</details>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://integrations.drivetrain.ai/integration-guide/integrate-with-drivetrain/others/integrating-with-oracle-fusion.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.