Skip to main content

Oracle Fusion Cloud HCM

With Oracle Fusion Cloud HCM modules in Make, you can watch, search for, create, retrieve, update, and delete records.

Note

To use the Oracle Fusion Cloud HCM app in Make, you must have the Make Enterprise plan. All Enterprise apps are currently labeled as premium tier 3 in Make.

Refer to the Oracle Fusion Cloud HCM API documentation for a list of available endpoints.

Connect Oracle Fusion Cloud HCM to Make

To establish the connection, you must enter your Oracle Cloud service server name and login credentials. This information can be found in the Oracle Cloud service welcome email sent to your Oracle Cloud service administrator.

  1. Log in to your Make account, add an Oracle Fusion Cloud HCM module to your scenario, and click Create a connection.

  2. Optional: In the Connection name field, enter a name for the connection.

  3. In the Server Name field, enter the URL of your Oracle Cloud service. For example, servername.fa.us2.oraclecloud.com.

  4. In the Username and Password fields, enter your Oracle Cloud service login credentials. Your account must have the necessary user permissions to be able to access the relevant records in Make.

  5. Set the connection's Scope by selecting the relevant record types.

    Note: If you receive a data.collection is too big error, limit the Scope selection to specific record types.

  6. Click Save.

You have successfully established the connection. You can now edit your scenario and add more Oracle Fusion Cloud HCM modules. If your connection requires reauthorization at any point, follow the connection renewal steps here.

Caution

The connection may take up to 5 minutes to establish. Please leave the connection window open until the connection is successful.

Records

Triggers when records are created.

Connection

Establish a connection to your Oracle Fusion Cloud HCM account.

Record Type Category

Select the category of the record type to watch for.

Available record types and categories are based on the scopes selected when creating the connection and your Oracle user rights at that time. If your user rights change, go to your Connections page and click Verify next to your connection to update this list.

If you receive an error stating This action is not supported in this category, the selected record type category is not compatible with this module. Please choose a different record type category to watch for.

Record Type

Select the record type to watch for. If no record types are shown, you do not have the user rights for the record type category selected above.

The selected record type must contain a 'datetime' parameter. If it does not, you will receive an error prompting you to choose a different record type.

Parent ID

Enter the parent ID or @context.key value of the records you want to watch for.

Different record types use different parameters as ID.

Date Field

Select which of the record's date fields will trigger the module. It must be type: datetime.

Label Field

Select the label to show when configuring Choose where to start > Choose manually in the module setup.

Fields

Select the record fields to be returned. To improve performance, limit the amount of fields selected.

Limit

Enter the maximum number of results to be worked with during one execution cycle.

Retrieves a list of records filtered by criteria.

Connection

Establish a connection to your Oracle Fusion Cloud HCM account.

Record Type Category

Select the category of the record type to search for.

Available record types and categories are based on the scopes selected when creating the connection and your Oracle user rights at that time. If your user rights change, go to your Connections page and click Verify next to your connection to update this list.

If you receive an error stating This action is not supported in this category, the selected record type category is not compatible with this module. Please choose a different record type category to search for.

Record Type

Select the record type to search for. If no record types are shown, you do not have the user rights for the record type category selected above.

Parent ID

Enter the parent ID of the records you want to search for. When mapping, use the @context.key value.

Different record types use different parameters as ID.

Query Builder

Select whether to use the Builder (filter by selecting from list) or Custom (enter a query string) method to specify filters.

Filter

Create filters to narrow down the search records returned.

Query String

Enter a query string according to the Oracle Fusion Cloud documentation.

Order By

Map or enter the direction in which fields should be returned.

Fields

Select or map the record fields to be returned. To improve performance, limit the amount of fields selected.

Effective Date

Enter the effective date of the records to return.

Limit

Enter the maximum number of results to be worked with during one execution cycle.

Troubleshooting

Oracle search limitations:

[400] Bad Request. Failed to build ViewCriteria from expression...

[500] Internal Server Error.

Due to Oracle limitations, certain record type categories cannot be searched for.

Required fields:

[400] Bad Request. Provide a valid value for [input field].

The input field displayed in the error message is required. Return to the module inputs, enter a value into the required field, and run the module again.

Creates a new record.

Connection

Establish a connection to your Oracle Fusion Cloud HCM account.

Record Type Category

Select the category of the record type to create.

Available record types and categories are based on the scopes selected when creating the connection and your Oracle user rights at that time. If your user rights change, go to your Connections page and click Verify next to your connection to update this list.

If you receive an error stating This action is not supported in this category, the selected record type category is not compatible with this module. Please choose a different record type category to create.

Record Type

Select the record type to create. If no record types are shown, you do not have the user rights for the record type category selected above.

Parent ID

Enter the parent ID of the record you want to create. When mapping, use the @context.key value.

Different record types use different parameters as ID.

Record Details

Enter or map the information of the record you want to create into the fields that appear. The fields are dependent upon the selected Record Type.

Troubleshooting

Required fields:

[400] Bad Request. Provide a valid value for [input field].

The input field displayed in the error message is required. Return to the module inputs, enter a value into the required field, and run the module again.

Retrieves the details of a record by its ID.

Connection

Establish a connection to your Oracle Fusion Cloud HCM account.

Record Type Category

Select the category of the record type to retrieve details of.

Available record types and categories are based on the scopes selected when creating the connection and your Oracle user rights at that time. If your user rights change, go to your Connections page and click Verify next to your connection to update this list.

If you receive an error stating This action is not supported in this category, the selected record type category is not compatible with this module. Please choose a different record type category to retrieve.

Record Type

Select the record type to retrieve details of. If no record types are shown, you do not have the user rights for the record type category selected above.

Parent ID

Enter the parent ID of the records you want to retrieve details of. When mapping, use the @context.key value.

Different record types use different parameters as ID.

ID

Enter the ID of the records you want to retrieve details of. When mapping, use the @context.key value.

Different record types use different parameters as ID.

Expand

Enter the name of a child record to include the details of.

To specify multiple child record types, use a , as a separator. For example: Employees,Localizations.

To specify nested child records types, use the format Child.NestedChild. For example: Employees.Managers. If a nested child is provided, the relevant child will be processed implicitly - Employees.Managers is the same as Employees,Employees.Managers.

Updates a record by its ID.

Connection

Establish a connection to your Oracle Fusion Cloud HCM account.

Record Type Category

Select the category of the record type to update.

Available record types and categories are based on the scopes selected when creating the connection and your Oracle user rights at that time. If your user rights change, go to your Connections page and click Verify next to your connection to update this list.

If you receive an error stating This action is not supported in this category, the selected record type category is not compatible with this module. Please choose a different record type category to update.

Record Type

Select the record type to update. If no record types are shown, you do not have the user rights for the record type category selected above.

Parent ID

Enter the parent ID of the record you want to update. When mapping, use the @context.key value.

Different record types use different parameters as ID.

ID

Enter the ID of the record you want to update. When mapping, use the @context.key value.

Different record types use different parameters as ID.

Record Details

Enter or map the information you want to update in the fields that appear. The fields are dependent upon the selected Record Type.

Deletes a record by its ID.

Connection

Establish a connection to your Oracle Fusion Cloud HCM account.

Record Type Category

Select the category of the record type to delete.

Available record types and categories are based on the scopes selected when creating the connection and your Oracle user rights at that time. If your user rights change, go to your Connections page and click Verify next to your connection to update this list.

If you receive an error stating This action is not supported in this category, the selected record type category is not compatible with this module. Please choose a different record type category to delete.

Record Type

Select the record type to delete. If no record types are shown, you do not have the user rights for the record type category selected above.

Parent ID

Enter the parent ID of the record you want to delete. When mapping, use the @context.key value.

Different record types use different parameters as ID.

ID

Enter the ID of the record you want to delete. When mapping, use the @context.key value.

Different record types use different parameters as ID.

Other

Performs an arbitrary authorized API Call.

Connection

Establish a connection to your Oracle Fusion Cloud HCM account.

URL

Enter a path relative to https://<servername>/. For example: /fscmRestApi/resources/11.13.18.05/invoices.

Refer to the Oracle Fusion Cloud HCM API documentation for a list of available endpoints.

Method

Select or map the HTTP method you want to use:

GET to retrieve information for an entry.

POST to create a new entry.

PUT to update/replace an existing entry.

PATCH to make a partial entry update.

DELETE to delete an entry.

Headers

Enter or map the desired request headers. You don't have to add authorization headers; we already did that for you.

Query String

Enter or map the request query string.

Body

Enter the body content for your API call.