Oracle Fusion
Overview
The Oracle Fusion HCM connector enables your Leena AI Agents to integrate with your organization's Oracle Fusion Human Capital Management (HCM) platform, facilitating automated HR operations including absence management, worker lifecycle management, benefits enrollment, and approval workflows.
Oracle Fusion HCM is Oracle's comprehensive cloud-based human capital management suite that provides end-to-end HR capabilities including core HR, talent management, workforce management, and payroll. The Oracle Fusion HCM connector allows Leena AI to automate HR workflows, manage worker data, handle absence requests, and interact with HCM processes seamlessly.
API Details
Leena AI integrates with Oracle Fusion HCM via REST APIs.
Documentation link: https://docs.oracle.com/en/cloud/saas/human-resources/24d/farws/Quick_Start.html
Setup
The Oracle Fusion HCM connector uses Username and Password (Basic) authentication over SSL.
Prerequisites
Before setting up the Oracle Fusion HCM connector, ensure you have:
- Administrator access to your Oracle Fusion Cloud HCM instance
- An integration user account with the appropriate security roles and privileges
- The Oracle Instance URL for your HCM 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
Here is how to set up an integration user in Oracle Fusion HCM:
- 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 the necessary roles based on the actions you need. Common roles include:
- Human Capital Management Integration Specialist — for worker and absence data access
- Use REST Service - Worker as HR — for workers REST API access
- Benefits Administrator — for benefits enrollment actions
- Save and close
- Configure Data Security (if required):
- Navigate to Setup and Maintenance > Tasks > Manage Data Role and Security Profiles
- Create a data role with the appropriate security profiles to control data-level access
- Assign the data role to your integration user
- 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 HCM" and select it from the list to add its new connector
- 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
Actions
The following actions are supported for the Oracle Fusion HCM connector:
Absence Management
Create Absence
Creates a new absence record for a worker in Oracle Fusion HCM. The Agent can leverage the skill (workflow), which has been designed to create a new absence request, once the user raises a query to do so.
Input Parameters
Here are the input parameters required to set up this action:
Mandatory
| Name | Description |
|---|---|
| Person ID | The person for whom the absence is being created |
| Absence Type | The type of absence being requested |
| Start Date | The start date of the absence |
| End Date | The end date of the absence |
| Legal Entity ID | The legal entity associated with the worker |
Optional
| Name | Description |
|---|---|
| Start Time | The start time of the absence |
| End Time | The end time of the absence |
| Start Date Duration | Duration type for the start date (e.g., full day, half day) |
| End Date Duration | Duration type for the end date |
| Absence Status | The status of the absence record |
| Absence Attachments | File attachments for the absence request (file name, URL, data type code) |
| Comments | Additional comments for the absence request |
Response
Upon successful creation, the action returns the created absence details including the absence record ID and status.
Update Absence
Updates an existing absence record in Oracle Fusion HCM. The Agent can leverage the skill (workflow), which has been designed to modify an existing absence record, once the user provides the details to be updated.
Input Parameters
Here are the input parameters required to set up this action:
Mandatory
| Name | Description |
|---|---|
| Absence Unique ID | The unique identifier of the absence to update |
Optional
| Name | Description |
|---|---|
| Absence Type Reason | The reason for the absence |
| Absence Status | The updated status of the absence |
| Start Date | The updated start date |
| End Date | The updated end date |
| Start Time | The updated start time |
| End Time | The updated end time |
| Comments | Updated comments for the absence |
Response
Upon successful update, the action returns the updated absence record details.
Delete Absence
Deletes an existing absence record from Oracle Fusion HCM. The Agent can leverage the skill (workflow), which has been designed to remove an absence record, once the user specifies the absence to be deleted.
Input Parameters
Here are the input parameters required to set up this action:
Mandatory
| Name | Description |
|---|---|
| Absence Unique ID | The unique identifier of the absence to delete |
Optional
| Name | Description |
|---|---|
| Comments | Comments for the deletion request |
Response
Upon successful deletion, the action returns a confirmation of the deletion.
Get All Absences
Retrieves a list of absence records from Oracle Fusion HCM. This action can be leveraged by Leena AI Orchestrator/Agent to list all absences 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 |
|---|---|
| Person Number | Filter absences by person number |
| Start Date | Filter by absence start date |
| End Date | Filter by absence end date |
| Absence Status | Filter by absence status |
| Approval Status | Filter by approval status |
| Fields | Specific fields to include in the response |
| Expand | Child resources to expand in the response |
| Limit | Maximum number of records to return |
| Page | Page number for pagination |
| Order By | Field to order results by |
| Only Data | Exclude links and metadata from the response |
| Total Results | Include total result count in the response |
| Query (q) | Advanced query filter |
Response
The action returns a list of absence records, each containing absence details, dates, status, and approval information.
Get Absence by ID
Retrieves a specific absence record by its unique identifier.
Input Parameters
Here are the input parameters required to set up this action:
Mandatory
| Name | Description |
|---|---|
| Absence Unique ID | The unique identifier of the absence to retrieve |
Optional
| Name | Description |
|---|---|
| Only Data | Exclude links and metadata from the response |
Response
The action returns the complete absence record details including dates, type, status, and associated metadata.
Get Absence Type Balance
Retrieves the absence type balance for a specific worker, showing remaining leave entitlements.
Input Parameters
Here are the input parameters required to set up this action:
Mandatory
| Name | Description |
|---|---|
| Person ID | The person whose absence balance is to be checked |
| Effective Date | The date for which the balance is calculated |
Optional
| Name | Description |
|---|---|
| Assignment ID | Filter by a specific assignment |
| User Context | Additional context for the balance calculation |
Response
The action returns the absence type balance details including available balance, used leave, and entitlement information.
Get Applicable Absence Types By User
Retrieves the list of absence types that are applicable for a specific user based on their employment configuration.
Input Parameters
Here are the input parameters required to set up this action:
Mandatory
| Name | Description |
|---|---|
| Person ID | The person whose applicable absence types are to be retrieved |
Optional
| Name | Description |
|---|---|
| Limit | Maximum number of records to return |
| Offset | Number of records to skip |
Response
The action returns a list of applicable absence types for the specified user.
Worker Management
Create Worker (Hire)
Creates a new worker (hire) in Oracle Fusion HCM. The Agent can leverage the skill (workflow), which has been designed to initiate a new hire process, once the user provides the worker details.
Input Parameters
Here are the input parameters required to set up this action:
Mandatory
| Name | Description |
|---|---|
| First Name | The first name of the worker |
| Last Name | The last name of the worker |
| Legislation Code | The legislation code for the worker's country |
| Effective Date | The hire date |
| Legal Employer Name | The legal employer for the worker |
| Worker Type | The type of worker (e.g., Employee, Contingent Worker) |
| Action Code | The hire action code |
| Business Unit Name | The business unit for the worker |
| Phone Type | The type of phone number |
| Phone Number | The worker's phone number |
| Email Type | The type of email address |
| Email Address | The worker's email address |
| Address Type | The type of address |
| Country | The country for the worker's address |
Optional
| Name | Description |
|---|---|
| Projected Start Date | Projected start date (required if creating a Pending Worker) |
| Proposed User Person Type | Proposed person type (required if creating a Pending Worker) |
| Address Line 1–4 | Address line fields |
| Town or City | The city of the worker's address |
| Postal Code | The postal code of the worker's address |
Response
Upon successful creation, the action returns the created worker details including the worker ID and person number.
Update Worker
Updates an existing worker's information in Oracle Fusion HCM. The Agent can leverage the skill (workflow), which has been designed to modify worker details, once the user provides the fields to be updated.
Input Parameters
Here are the input parameters required to set up this action:
Mandatory
| Name | Description |
|---|---|
| Worker ID | The unique identifier of the worker to update |
| Effective Date | The effective date for the update |
Optional
| Name | Description |
|---|---|
| Update Person Info | Toggle to update personal information |
| Update Name | Toggle to update name details |
| Update Email | Toggle to update email address |
| Update Address | Toggle to update address |
| Update Phone | Toggle to update phone number |
| Date of Birth | Updated date of birth (when updating person info) |
| Country of Birth | Updated country of birth |
| Name Unique ID | Unique ID for the name record to update |
| First Name | Updated first name |
| Last Name | Updated last name |
| Email Unique ID | Unique ID for the email record to update |
| Email Address | Updated email address |
| Address Unique ID | Unique ID for the address record to update |
| Address Line 1–2 | Updated address lines |
| Town or City | Updated city |
| Postal Code | Updated postal code |
| Phone Unique ID | Unique ID for the phone record to update |
| Phone Number | Updated phone number |
| Phone Type | Updated phone type |
| From Date | Effective start date for the phone record |
Response
Upon successful update, the action returns the updated worker details.
Get All Workers
Retrieves a list of workers from Oracle Fusion HCM. This action can be leveraged by Leena AI Orchestrator/Agent to list workers with various filtering and expansion options.
Input Parameters
Here are the input parameters required to set up this action:
All parameters are optional for this action.
Optional
| Name | Description |
|---|---|
| Effective Date | The effective date for the query |
| Expand | Child resources to expand (e.g., names, emails, phones) |
| Fields | Specific fields to include in the response |
| Limit | Maximum number of records to return |
| Offset | Number of records to skip |
| Order By | Field to order results by |
| Sort Order | Sort direction (ascending or descending) |
| Only Data | Exclude links and metadata from the response |
Response
The action returns a list of worker records, each containing worker details, employment information, and any expanded child resources.
Get Worker By Id
Retrieves a specific worker's details by their unique identifier.
Input Parameters
Here are the input parameters required to set up this action:
Mandatory
| Name | Description |
|---|---|
| Worker ID | The unique identifier of the worker to retrieve |
Optional
| Name | Description |
|---|---|
| Expand | Child resources to expand in the response |
| Effective Date | The effective date for the query |
| Fields | Specific fields to include in the response |
| Only Data | Exclude links and metadata from the response |
Response
The action returns the complete worker record including personal information, employment details, and any expanded child resources.
Terminate Worker
Terminates a worker's employment in Oracle Fusion HCM. The Agent can leverage the skill (workflow), which has been designed to process a termination, once the user provides the necessary details.
Input Parameters
Here are the input parameters required to set up this action:
Mandatory
| Name | Description |
|---|---|
| Worker ID | The unique identifier of the worker to terminate |
| Period of Service ID | The period of service identifier for the termination |
| Action Code | The termination action code |
| Termination Date | The effective date of termination |
Optional
| Name | Description |
|---|---|
| Date of Death | Date of death (applicable if action code is Death) |
| Recommended for Rehire | Whether the worker is recommended for rehire |
Response
Upon successful termination, the action returns the termination confirmation and updated worker status.
Benefits
Get Enrollment Opportunities
Retrieves benefit enrollment opportunities available for workers in Oracle Fusion HCM.
Input Parameters
Here are the input parameters required to set up this action:
All parameters are optional for this action.
Optional
| Name | Description |
|---|---|
| Person Number | Filter by a specific person number |
| Fields | Specific fields to include in the response |
| Expand | Child resources to expand |
| Limit | Maximum number of records to return |
| Offset | Number of records to skip |
| Effective Date | The effective date for the query |
| Only Data | Exclude links and metadata from the response |
Response
The action returns a list of enrollment opportunities including plan types, coverage options, and eligibility information.
Get Benefit Enrollments
Retrieves benefit enrollment records from Oracle Fusion HCM.
Input Parameters
Here are the input parameters required to set up this action:
All parameters are optional for this action.
Optional
| Name | Description |
|---|---|
| Person ID | Filter by a specific person |
| Plan Type ID | Filter by a specific benefit plan type |
| Limit | Maximum number of records to return |
| Offset | Number of records to skip |
| Expand | Expand child resources in the response |
Response
The action returns benefit enrollment records including plan details, coverage levels, and enrollment status.
Get Enrollment by ID
Retrieves a specific benefit enrollment record by person ID.
Input Parameters
Here are the input parameters required to set up this action:
Mandatory
| Name | Description |
|---|---|
| Person ID | The person whose enrollment record is to be retrieved |
Optional
| Name | Description |
|---|---|
| Plan Type ID | Filter by a specific benefit plan type |
| Enrollment Result ID | Filter by a specific enrollment result |
| Expand | Expand child resources in the response |
Response
The action returns the enrollment record details including plan information, coverage, and enrollment status.
Notifications & Tasks
Get Notification Content
Retrieves the content of a business process notification (approval task) from Oracle Fusion HCM. This action enables the Agent to fetch pending notification details for display or processing.
Input Parameters
Here are the input parameters required to set up this action:
Mandatory
| Name | Description |
|---|---|
| Task ID | The unique identifier of the notification/task |
Response
The action returns the notification content including task details, requester information, and approval context.
Perform Task Action
Performs an approval action on a pending business process task in Oracle Fusion HCM. The Agent can leverage this action to approve, reject, or take other actions on pending workflow tasks.
Input Parameters
Here are the input parameters required to set up this action:
Mandatory
| Name | Description |
|---|---|
| Task ID | The pending task to perform the action on |
| Approval Action | The action to perform. Options: Approve, Reject, Request Information, Withdraw, Push Back |
Optional
| Name | Description |
|---|---|
| Comments | Notes or comments for the audit trail |
Response
Upon successful execution, the action returns the task action result including updated task status and confirmation.
Updated about 2 hours ago