Oracle Fusion Cloud ERP
Modified on Tue, 13 Aug at 8:34 AM
With Oracle Fusion Cloud ERP modules in Make, you can watch, search for, create, retrieve, update, and delete records.
Note
To use the Oracle Fusion Cloud ERP 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 ERP API documentation for a list of available endpoints.
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.
Log in to your Make account, add an Oracle Fusion Cloud ERP module to your scenario, and click Create a connection.
Optional: In the Connection name field, enter a name for the connection.
In the Server Name field, enter the URL of your Oracle Cloud service. For example,
servername.fa.us2.oraclecloud.com.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.
Set the connection's Scope by selecting the relevant record types.
Note: If you receive a
data.collection is too bigerror, limit the Scope selection to specific record types.Click Save.
You have successfully established the connection. You can now edit your scenario and add more Oracle Fusion Cloud ERP 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.
Triggers when records are created.
Connection | Establish a connection to your Oracle Fusion Cloud ERP 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 |
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 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: |
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 ERP 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 |
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 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. |
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 ERP 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 |
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 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. |
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 ERP 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 |
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 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 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 To specify nested child records types, use the format |
Updates a record by its ID.
Connection | Establish a connection to your Oracle Fusion Cloud ERP 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 |
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 Different record types use different parameters as ID. |
ID | Enter the ID of the record you want to update. When mapping, use the 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 ERP 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 |
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 Different record types use different parameters as ID. |
ID | Enter the ID of the record you want to delete. When mapping, use the Different record types use different parameters as ID. |
Performs an arbitrary authorized API Call.
Connection | Establish a connection to your Oracle Fusion Cloud ERP account. |
URL | Enter a path relative to Refer to the Oracle Fusion Cloud ERP 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. |
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article