Oracle Fusion ERP

Overview

The Oracle Fusion ERP connector enables your Leena AI Agents to integrate with your organization's Oracle Fusion Cloud ERP platform, facilitating automated procurement lookups including supplier search, supplier records, supplier sites, supplier addresses, supplier products and services, approved supplier list entries, and catalog items.

Oracle Fusion Cloud ERP is Oracle's comprehensive cloud-based enterprise resource planning suite that provides end-to-end capabilities including financials, procurement, and supply chain management. The Oracle Fusion ERP connector allows Leena AI to look up supplier and item data and answer procurement queries seamlessly. All actions in this connector are read-only.

API Details

Leena AI integrates with Oracle Fusion ERP via REST APIs.

Documentation link: https://docs.oracle.com/en/cloud/saas/procurement/26b/fapra/api-suppliers.html

Setup

The Oracle Fusion ERP connector supports the following authentication type:

  • Username and Password (Basic authentication over SSL)

Prerequisites

Before setting up the Oracle Fusion ERP connector, ensure you have:

  • Administrator access to your Oracle Fusion Cloud ERP instance
  • An integration user account with the appropriate security roles and privileges
  • The Oracle Instance URL for your ERP environment (e.g., https://your-company.oraclecloud.com)
  • Access to Oracle Security Console for role and privilege management
  • Access to your Leena AI workspace with connector management permissions

Get credentials

Username and Password

Here is how to set up an integration user in Oracle Fusion ERP:

  1. Log in to Oracle Fusion Cloud as a Security Administrator
  2. Create or identify an Integration User:
    1. Navigate to Tools > Security Console
    2. Go to the Users tab
    3. Create a new user or identify an existing integration user account
    4. Ensure the user has a non-expiring password or a service account configuration
  3. Assign Required Security Roles:
    1. In the Security Console, search for your integration user
    2. Click on the Display Name to access user information
    3. Click Edit and then Add Role
    4. Assign roles that grant the privileges needed for the actions you need. Common privileges include:
      • View Supplier — for supplier search and supplier record access, and required by every supplier action
      • View Supplier Site — for supplier sites access
      • View Supplier Address — for supplier addresses access
      • View Supplier Products and Services Categories — for supplier products and services access
      • Roles with REST access to approved supplier list entries and items — for the actions in those groups
    5. Save and close
  4. Note the following credentials:
    • Oracle Instance URL: Your Oracle Cloud environment URL (e.g., https://your-company.fa.us2.oraclecloud.com)
    • Username: The integration user's username
    • Password: The integration user's password

Add connection

Here is how to add a connection on Leena AI:

  1. Log in to your Leena AI workspace
  2. Navigate to Settings > Integrations
  3. Search for "Oracle Fusion ERP" and select it from the list to add its new connector
  4. Select the authentication type and configure the connector:

Username and Password

  1. Select the authentication type: Username and password
  2. Start configuring the connector:
    1. Oracle instance URL: Your Oracle Fusion Cloud instance URL (e.g., https://your-company.oraclecloud.com)
    2. Username: Integration user's username
    3. Password: Integration user's password
  3. Click Test Connection to verify the credentials
  4. Save the connector configuration

Note

Test Connection reads one supplier record. A successful test confirms the credentials and supplier access, but not access to items or approved supplier list entries. If one of those actions fails after a successful test, check the integration user's privileges for that resource.

Actions

The following actions are supported for the Oracle Fusion ERP connector:

Suppliers

Search Suppliers

Finds suppliers in Oracle Fusion ERP by partial name. This action can be leveraged by Leena AI Orchestrator/Agent to look up a supplier before retrieving its details.

Input Parameters

Here are the input parameters required to set up this action:

Mandatory
NameDescription
Supplier Name ContainsPart of the supplier name to search for (a search term is always required; unfiltered supplier lists are not allowed)
Optional
NameDescription
Only DataExclude links and metadata from the response (default: on)
LimitMaximum number of records to return (default: 25)
OffsetNumber of records to skip

Response

The action returns a list of matching supplier records, each containing the supplier ID, name, number, and status.


Get Supplier by ID

Retrieves a specific supplier's full record by its unique identifier.

Input Parameters

Here are the input parameters required to set up this action:

Mandatory
NameDescription
SupplierThe supplier to retrieve, searchable by supplier name
Optional
NameDescription
Only DataExclude links and metadata from the response (default: on)

Response

The action returns the complete supplier record.


Get Supplier Sites

Retrieves the purchasing sites of a supplier.

Input Parameters

Here are the input parameters required to set up this action:

Mandatory
NameDescription
SupplierThe supplier whose sites are to be retrieved, searchable by supplier name
Optional
NameDescription
Only DataExclude links and metadata from the response (default: on)
LimitMaximum number of records to return (default: 25)
OffsetNumber of records to skip

Response

The action returns a list of the supplier's site records.


Get Supplier Addresses

Retrieves the addresses of a supplier.

Input Parameters

Here are the input parameters required to set up this action:

Mandatory
NameDescription
SupplierThe supplier whose addresses are to be retrieved, searchable by supplier name
Optional
NameDescription
Only DataExclude links and metadata from the response (default: on)
LimitMaximum number of records to return (default: 25)
OffsetNumber of records to skip

Response

The action returns a list of the supplier's address records.


Get Supplier Products and Services

Retrieves the procurement categories a supplier serves.

Input Parameters

Here are the input parameters required to set up this action:

Mandatory
NameDescription
SupplierThe supplier whose products and services are to be retrieved, searchable by supplier name
Optional
NameDescription
Only DataExclude links and metadata from the response (default: on)
LimitMaximum number of records to return (default: 25)
OffsetNumber of records to skip

Response

The action returns a list of the products and services categories recorded for the supplier.


Approved Supplier List

Get Approved Supplier List Entries

Retrieves approved supplier list entries from Oracle Fusion ERP. This action can be leveraged by Leena AI Orchestrator/Agent to list all entries or filter by specific criteria.

Input Parameters

Here are the input parameters required to set up this action:

All parameters are optional for this action.

Optional
NameDescription
Filter ExpressionAdvanced query filter, e.g. to filter by item, supplier, or procurement business unit
Only DataExclude links and metadata from the response (default: on)
LimitMaximum number of records to return (default: 25)
OffsetNumber of records to skip

Response

The action returns a list of approved supplier list entries matching the filter.


Items

Search Items

Searches catalog items in Oracle Fusion ERP by description or item number.

Input Parameters

Here are the input parameters required to set up this action:

Mandatory
NameDescription
Search TermPart of the item description or item number to search for
Optional
NameDescription
Search ByThe field to search: Item description (default) or Item number
Only DataExclude links and metadata from the response (default: on)
LimitMaximum number of records to return (default: 25)
OffsetNumber of records to skip

Response

The action returns a list of matching item records.


Did this page help you?