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:
- Log in to Oracle Fusion Cloud as a Security Administrator
- Create or identify an Integration User:
- Navigate to Tools > Security Console
- Go to the Users tab
- Create a new user or identify an existing integration user account
- Ensure the user has a non-expiring password or a service account configuration
- Assign Required Security Roles:
- In the Security Console, search for your integration user
- Click on the Display Name to access user information
- Click Edit and then Add Role
- 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
- Save and close
- 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
- Oracle Instance URL: Your Oracle Cloud environment URL (e.g.,
Add connection
Here is how to add a connection on Leena AI:
- Log in to your Leena AI workspace
- Navigate to Settings > Integrations
- Search for "Oracle Fusion ERP" and select it from the list to add its new connector
- Select the authentication type and configure the connector:
Username and Password
- Select the authentication type: Username and password
- Start configuring the connector:
- Oracle instance URL: Your Oracle Fusion Cloud instance URL (e.g.,
https://your-company.oraclecloud.com) - Username: Integration user's username
- Password: Integration user's password
- Oracle instance URL: Your Oracle Fusion Cloud instance URL (e.g.,
- Click Test Connection to verify the credentials
- 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
| Name | Description |
|---|---|
| Supplier Name Contains | Part of the supplier name to search for (a search term is always required; unfiltered supplier lists are not allowed) |
Optional
| Name | Description |
|---|---|
| Only Data | Exclude links and metadata from the response (default: on) |
| Limit | Maximum number of records to return (default: 25) |
| Offset | Number 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
| Name | Description |
|---|---|
| Supplier | The supplier to retrieve, searchable by supplier name |
Optional
| Name | Description |
|---|---|
| Only Data | Exclude 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
| Name | Description |
|---|---|
| Supplier | The supplier whose sites are to be retrieved, searchable by supplier name |
Optional
| Name | Description |
|---|---|
| Only Data | Exclude links and metadata from the response (default: on) |
| Limit | Maximum number of records to return (default: 25) |
| Offset | Number 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
| Name | Description |
|---|---|
| Supplier | The supplier whose addresses are to be retrieved, searchable by supplier name |
Optional
| Name | Description |
|---|---|
| Only Data | Exclude links and metadata from the response (default: on) |
| Limit | Maximum number of records to return (default: 25) |
| Offset | Number 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
| Name | Description |
|---|---|
| Supplier | The supplier whose products and services are to be retrieved, searchable by supplier name |
Optional
| Name | Description |
|---|---|
| Only Data | Exclude links and metadata from the response (default: on) |
| Limit | Maximum number of records to return (default: 25) |
| Offset | Number 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
| Name | Description |
|---|---|
| Filter Expression | Advanced query filter, e.g. to filter by item, supplier, or procurement business unit |
| Only Data | Exclude links and metadata from the response (default: on) |
| Limit | Maximum number of records to return (default: 25) |
| Offset | Number 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
| Name | Description |
|---|---|
| Search Term | Part of the item description or item number to search for |
Optional
| Name | Description |
|---|---|
| Search By | The field to search: Item description (default) or Item number |
| Only Data | Exclude links and metadata from the response (default: on) |
| Limit | Maximum number of records to return (default: 25) |
| Offset | Number of records to skip |
Response
The action returns a list of matching item records.
Updated about 13 hours ago
